Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group header - continued
Message
From
20/06/2007 14:54:34
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00858244
Message ID:
01234561
Views:
20
>>Give this a try:
>>
>>Create a report variable called rnGrpLines, set the Calculate option to Count, and set it to reset at the Data Group.
>>
>>In the Group Header, make the expression for company be as follows:
>>alltrim(company) + IIF(rnGrpLines = 0, "", " -- continued")
>>
>>
>>Cathy
>
>Hi Cathy,
>
>This worked very well indeed, thanks a lot. However, I can not make the other part of the trick work for me. I also want to have "continued on the next page" printed on the page that is going to span two pages. I put
>IIF(rnGrpLines > 0, "", " continued on the next page") and set variable to 0 in the Group Footer onExit, but it doesn't print.
>
>I have two groups. Just in case I created a separate variable for the inner group and tried to combine both using OR condition, but it still doesn't want to print.
>
>What can I do to make it print?
>
>Thanks in advance.

In older times this kind of tricks was accomplished by following approach:
1. You run your report two times
2. You have some calls from appropriate band e.g. group header/footer in your request) onExit or onEntry that will fill some extra field in your cursor. This calls will be fired only when you run it first time.
3. So after first run your cursor has information which group will span more than one page (you keep _PAGENO in the cursor)
4. During your second (actual) run you use that extra field to print whatever you want.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform