Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting the num of Rows and Number of details
Message
De
27/01/2004 11:30:23
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00870944
Message ID:
00871008
Vues:
12
This message has been marked as a message which has helped to the initial question of the thread.
>Hilmar
>
>I do have the data combined into one result set. I have two report variables, nRptCaseCnt & nRptProcCnt. Their initial value is 0 and the value to store is 1. They are set to Sum. Since they are setup the same, I get the same value at the end of the report in the summary band. The value does represent the correct value for the nRptProcCnt, but not for the nRptCaseCnt.
>
>For each meetingnumber (grouped in the report), I may have 1 or more procedures (procedure print in the actual detail section).
>
>Desired Results Example:
>
>meetingnumber      patient
>123                Test, Case
>        Procedure 1
>        procedure 2
>        procedure 3
>124                test, Case 2
>        Procedure 1
>
>-------------------------------------------------------
>Summary Band
>-------------------------------------------------------
>Total Cases:  2    Total Procedures=4
>
>
>Thanks

As I understand it, you want a certain variable to increase by one for each group, right?

Methinks that VFP doesn't have an easy, built-in way to handle this.

I think one option would be to call a UDF, which will increase the variable, either in "Run expression on entry" or in "Run expression on exit".

Another option would be to process your cursor before running the report (running a loop, to insert the "MeetingNumber", in this case).

HTH,

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform