Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I always keep at least one detail record?
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01191965
Message ID:
01192754
Views:
31
This message has been marked as a message which has helped to the initial question of the thread.
I think you could achieve that.

Might be smarter ways to do that now with the report listner but one solution i remember in previous versions of VFP was to mark the last record for very group. Make sure that's the last record for the group.

Then in the group footer (NOT the summary) wrap the expressions in a double if: IIF(CheckLastRecord(), RealExpression, Blank).

The footer is essentially 'bound' to the last group record.

I can check the nitty gritty details if i have missed something.

regards

Mathias

>Mathias,
>
>Thanks a lot for your response. The problem is, that sometimes group footer or summary is printed on a separate page without any detail information above. I want to prevent this, but I don't know is it possible?
>
>Thanks again and appreciate your thoughts.
>
>>Naomi how is that possible? I thought you always have to have something you were summarizing.
>>
>>Mathias
>>
>>>Hi everybody,
>>>
>>>Do you know if some generic algoritm exists to always keep at least one detail record on a page before the group footer? In other words, how can I not have orphan group footers or report summary?
>>>
>>>Thanks a lot in advance.
Mathias Banda

Time is longer than a rope.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform