Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting the num of Rows and Number of details
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00870944
Message ID:
00871043
Views:
14
This message has been marked as the solution to the initial question of the thread.
To count the cases, which are data groups, do the following:

- Define the variable nRptCaseCnt with a value of 0, set the calculate to SUM, and Reset at end of report.

- In the OnExit expression of the Case Group Footer, put the following expression: _VFP.SetVar('nRptCaseCnt', nRptCaseCnt+1)


Cathy


>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.
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform