Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report with bands how to count items in top band
Message
From
14/02/2007 18:26:07
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01195816
Message ID:
01195821
Views:
18
>Using ReportBehavior 90, I want to count items in the top band, so item 1 in the top band shows as "1. First Item" and then all the detail from band 2 print and then all the detail from band 3 print. Then I want Item 2 to show as "2. Second Item" If I set the variable to count, it will start with 1 and then jumps to 6 or whatever number it reiterates, because of the way ReportBehavior works. How do you get around this?

You need two variables. One to count within a group, let's call it cnt1, and the other cnt2 to calculate cnt2+iif(cnt1=1, 1, 0), initialize with zero.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform