Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Total Value on a 2-band report
Message
 
 
To
15/12/2006 20:58:37
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01178103
Message ID:
01178240
Views:
20
>
>OK, I see.
>
>The detail band has an "On entry" expression, perhaps here you can invoke a function that increments a variable for every record. I guess this would be separate for each of the two detail bands.
>
>Similarly, a report field has a "Print When..." condition, where, of course, you might invoke any function.
>
>Provided the "Calculations" by itself (in the individual field, in a detail band) isn't enough.
>
>Otherwise, it is starting to get a little awkward.
>
>On the other hand, one thing I have been doing for a long time is prepare all the data (cursors) beforehand, especially data that is complicated to get through the report. For instance, you might loop through a R/W cursor, and increment a separate summary field.

I have never used On Entry expression, so I will have to look for it (actually the first shot at finding it in VFP 9 help not successful).

As to your last paragraph, of preparing cursor beforehand is what I mentioned in one of my messages. That would be creating a third cursor for storing the SUM values.

Again, thank you for your help (especially on Friday night when most people rest <g>).
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform