Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to handle user inputs for reports
Message
 
 
À
13/05/2002 10:58:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00655681
Message ID:
00655711
Vues:
15
>I am writing a large app that is going to several clients and I am wondering how to handle the various inputs required for reports ie; A/R Aging report requires a date field, an optional customer ID, an optional Salesman ID, and an optional 'number of days overdue' variable.
>I allow 'super-users' of the system to modify report layouts as required and I would like them to be able to add reports to the system. But how to handle these inputs that are required for most reports? Do I design a form class and show it and add objects to it in the init of the report? Sounds like a lot of work...
>
>We are using SQL 2000 on the back end and have made stored procs to actually retrieve the data for each report by passing them the parameters required.
>
>Thanks.

If the report layout is always the same, but only conditions change, you have to design a user selection criteria form, which would return your select statement (or where condition)... I have several classes designed for user selection form criteria, I'll probably publish them here lately, after I receive some feedback from Steve Kramer...
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