Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Summary Band Problem
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00520842
Message ID:
00521717
Views:
17
>>>I've dealt with this issue before and it's a PITA. I think what I ended up doing was defining the summary band as Start on New Page and then included the header and footer information in the summary band. Of course, this meant that even if the summary would have fit on the bottom of the last page, I ended up with the summary on the next page.
>>>
>>>Another idea you could try is to wrap your report in another group band that somehow triggers after the last record of the report. Then move your summary information to the group footer and eliminate the summary band.
>>>
>>>Cathy
>>
>>Hi Cathy,
>>
>>Do you think, the solution I proposed, would not work? If there is no stretch with overflow fields and you know, that one page always have 8 detail records and there are no groups at all, you just have to place the exact record from detail to the summary (assuming, that this is just one detail line) and then use Print when condition.
>>
>>BTW, I had the similar problem recently when my group footer appears without at least one detail line. I tried Start on the new page then less than option, but it didn't work. Finally I just put one field from group footer to detail band and put .f. in print when condition. This seems to do the trick.
>
>
>It probably would work just fine but I *HATE* to hard-code anything so I was trying to offer a more global solution.

>Regarding your "start on new page" issue, it *should* work just fine. Were you sure that you were using a number that was appropriate for the unit of measure? What I do is add together the height of the group header, then I look at the height of the detail band and add 2 times that number. This makes sure that if the header and two detail lines don't fit, it will start on a new page.
>
>Cathy

It should, but when I tried, it didn't. I believe I spent about 2h. this day trying to make it work, but finally just gave up and wrote a message in UT. I received banch of interesting advices, and I also came up to the simplest idea, which I described. On the next day I changed this report a little bit and could not reproduce the problem, but I haven't tested it really well with different sample data. My mission was to create a prototype of this report, which I did.

BTW, thanks again for the nice articles in FoxTalk. I wrote an article in Russian for the Russian site, where I described the problem with adding blank page with reference to your article.

Best wishes,
Nadya
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform