Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting the num of Rows and Number of details
Message
From
27/01/2004 11:30:23
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00870944
Message ID:
00871008
Views:
11
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)
Previous
Reply
Map
View

Click here to load this message in the networking platform