change report labels at run time

Dear sirs
how can I change the labels of the fields in a report at run time, these
labels may have spaces, ex: Dept Name
how can I do that???

plz help
thnx
mohammed

Anders
Sat Dec 04 09:06:27 CST 2004

Hi Mohammed
VFP's reports are based on VFP data cursors. These cursors and tables can't
have spaces in column names. So I suppose what you want is to print column
names with spaces. You do that by editing the labels in the report. If you
label is Dept_name or Deptname, click on the label to put it in editing
mode. Then use the arrow keys to go into the label and delete and insert
characters where you want.
-Anders

"Mohammed Abdel-Razzak" <MohammedAbdelRazzak@discussions.microsoft.com>
wrote in message news:1EF5EA51-3944-44FD-96C8-54051226C0BD@microsoft.com...
> Dear sirs
> how can I change the labels of the fields in a report at run time, these
> labels may have spaces, ex: Dept Name
> how can I do that???
>
> plz help
> thnx
> mohammed

Cindy
Sat Dec 04 11:50:16 CST 2004

Hi Mohammed,

How are you creating your report? If you have a report form created at
design time you can put labels on top of each other and use Print When to
determine which one shows.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com


"Mohammed Abdel-Razzak" <MohammedAbdelRazzak@discussions.microsoft.com>
wrote in message news:1EF5EA51-3944-44FD-96C8-54051226C0BD@microsoft.com...
> Dear sirs
> how can I change the labels of the fields in a report at run time, these
> labels may have spaces, ex: Dept Name
> how can I do that???

Andrew
Mon Dec 06 06:16:33 CST 2004

Mohammed Abdel-Razzak wrote:
> Dear sirs
> how can I change the labels of the fields in a report at run time,
> these labels may have spaces, ex: Dept Name
> how can I do that???

If it's constant text then use labels as per Anders' post. If you want
"slightly dynamic" labels then use labels on top of each other with a "print
when" as per Cindy's post. If you need to change the name very often then
you can create expressions that are variables on your report, eg

m.lclabel1
m.lclabel2
m.lclabel3
m.lclabel4
etc.

and assign values to these variables in your program before calling the
report.

--
HTH
Andrew Howell