Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
First Foray into VFP 9 Report Writer
Message
From
06/06/2013 08:25:49
 
 
To
05/06/2013 18:35:44
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01575711
Message ID:
01575744
Views:
103
>Please bear with me on this. I know it's basic stuff but it's the first time I've tried it.
>
>I have a table with (for example) the city, county, and population of every city in California. I want to print a report sorted by population within county. If the city population is greater than 100,000 I want all the information to be bold.
>
>In VFP 8 Report Writer I would create two field controls for each of the fields I need to show. The Print When property would be set to population >= 100000 for one set of fields and population < 100000 for the other set of fields. The corresponding field objects would overlay each other and the report would print the way I want.
>
>If I'm understanding it properly, I can create Optional Detail Bands and put one set of controls in one band and the other set of controls in the other band. Essentially the same thing except visually better since I don't have to deal with "invisible" fields.
>
>Is there something within the report writer itself (not within a listener object - I'm taking baby steps) that can control the Print When of the entire band? I tried looking at the On Entry expression for the band, but couldn't figure out how to make it work.
>
>Thanks to all..............Rich

There's no reason to do this with two bands or with two sets of controls in VFP 9 SP2. Instead, use the new Dynamics tab of the Field Properties dialog to set up dynamic formatting. You can specify a condition and formatting to go with it.

You will have to do this for each control (though you may be able to set it up for multiple controls at a time, not sure).

Also, you will have to SET REPORTBEHAVIOR 90.

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform