Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Title Page with multiple possibilities...Help!
Message
 
 
À
30/06/2010 11:17:06
Scott Malinowski
Arizona Fox Software LLC
Arizona, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01471078
Message ID:
01471081
Vues:
64
>Hello All!
>
>Our system creates a report title page for every report that the user runs. This title page shows the selection/search criteria that was used to query for the report.
>
>The issue: reports can be initiated from four (4) separate places in the system: report manager (normal), a specific user form, from multiple search forms and from a report scheduling process.
>
>The one that is really causing me some issues is the search form option.
>
>There are 12 search forms in the system. Each search form has different search criteria on it.
>
>The problem is that a single report can then be run based on a variety of 12 different sets of search criteria.
>
>Putting all those fields in the Title Page band and controlling them with Print When clause is not a preferred solution.
>
>The REAL problem is the fields would all have to be overlaid in order to fit all the different criteria sets into an 8 1/2 by 11 inch window, which is a VFP restriction. Maintaining this every time we make a change to a search form would be a nightmare!
>
>Any ideas on how I can handle this one?
>
>TIA!
>
>Scott M.

I'm not sure if this is helpful, but in my search form I developed two methods. One to return where expression and another to return Criteria in English. This criteria text can be then placed in reports.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform