>Cetin,
>sorry I didn't make myself clear, I meant have you got any tips for VFP report designer?
>Thanks
>Pete
Hmmm tips. No special tip during design, all native design controls. But thinking "toolbar label icon click then on label click puts you in edit mode" could be a tip (?) lemme try to list rest :
-Right click on controls and on an empty space popup shorcut menus with mostly used "properties" and "preview" respectively
-To align controls easily invoke layout toolbar
-To align a group of controls first group them (format\group) then ungroup when finished
-Also if you'll use colors, keep Color palette toolbar open
-Labels always have field expression alternatives ie: For a header that would change on the fly use field instead of label.
-Do not use report dataenvironment (self preference to avoid headaches - but certainly there are times you would want to)
-To subtotal and total, first create your groupings and summary band. Select fields that would be totalled from detail band copy and paste, move pasted copies to group footer and summary bands. Most of the time "reset" option for calculations is automatically set to group expression and end of report as appropriate (this also saves time for formatting options).
-To create reports easily you could use this approach :
--In app where report would be called prepare your cursor, vars etc and call a development time prg that reside on your development machine
lparameters tcRepName2Create, tnStyle, lcFields
if type("tnStyle") # "N"
tnStyle = 1
endif
if type("lcFields") # "C"
lcFields = ""
else
lcFields = "Fields "+lcFields
endif
lcStyle = iif(tnStyle=1,"COLUMN","FORM")
create report (tcRepName2Create) ;
from (alias()) &lcStyle &lcFields
modi report (tcRepName2Create)
You would call it ie:
select * from mytable ;
into cursor mycursor
=makereport("myreport",,field(1)+","+field(3))
report form myreport preview
All for designer part for now.
Cetin