Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
First Foray into VFP 9 Report Writer
Message
De
06/06/2013 13:06:54
 
 
À
06/06/2013 12:06:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01575711
Message ID:
01575761
Vues:
61
>>>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
>
>
>Sorry Tamar............I mis-clicked when setting the VFP Version. It is SP1 and not SP2. I think the Dynamics tab is an SP2 feature.

Any reason you can't go to SP2?

Tamar
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform