Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding a Group Counter
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Divers
Thread ID:
01156251
Message ID:
01156351
Vues:
29
Thanks. Yes I know I could do it via a cursor in VFP, but in this case I want to avoid changing the exe because the application was already released. Instead I'm trying to accomplish this by editing the existing report. So you don't think there is a way to do this with standard FRX functions?

Mon


>
>Hi Mon,
>
>There is few solutions (that I know/use) to show counts at group header levels but none using standard frx functinality.
>
>1. You can prepare (preprocess) cursor with all counts already in place and then just expose those counts (tmp cursor fields) via ordinary report expressions at group levels.
>
>2. For your case where is only one count that needs to be presented, you can also use simple UDF to accomplish this.
>From ordinary report expression placed in group header, you simply call
>your UDF - wich then returns that count value.
>Hence, it is better to apply that function on tmp cursor - COPY of the one you are reporting, then on main report alias itself.
>For speed purposes on that cursor/copy you can add tmp index tag(s) as per your convinience.
>
>
>
>function StudentsPerTutor
>lparameters nTutorId
>.
>blah blah
>.
>return nStudentCount
>
>
>*In report expression (from grp Header) you wil put simply call to yr udf like
>
>=StudentsPerTutor(Sign-ins.TutorId)
>
>
>
>HTH
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform