Page Header and Multi Groups Question

[RobNauticus]

Hello All, CR10 and Access,

Trying to post this again. lost the last one due to a server error. Here goes...

Got a report with 3 Groups, 3 Columns (groups included), a page header with Group1 summary fields on it. I cannot use a group for the header due to the fact I have my groups set to fall under columns.

The problem: When Group1 spans more than 1 page, the summary fields in the only are correct on the last page.

Solution: Find a way to force the evaluation of the summaries until after all records have been read. The header information must be consistent over each page.

I will be gathering in my formulas and code to attach as a second message, just in case this one does not make it.

Any help would be very awesome!

Rob

 

[synapsevampire]

Too little information shared.

First, a page header is an inappropriate place for summary information, what if a group breaks over the page, you have 2 summaries within the page.

Use the group header.

Next, there are different ways to create sumamries, a Running Total will only show results AFTER the rows have been processed for it's values.

Try posting technical information rather than vague descriptions:

Crystal version
Database/connectivity
Example data
Expected output

This means show the data, then show what the output would be.

As for "Find a way to force the evaluation of the summaries until after all records have been read. The header information must be consistent over each page.", this is dependent on the type of summaries being created, for instance if they are by a group, yo would expect all groups summaries on one page?

Here's a tip on creating formulas:

summing all rows
sum({table.field})

summing rows for a group:
sum({table.field},{table.groupfield})

If you truly want ALL summaries on the first page, then you might consider a cross-tab in the report header, otherwise post specifics.

-k

 

[lbass]

Sounds like you have formatted your report with multiple columns. You might want to consider formatting the group footer to "print at bottom of the page" (a Ken Hamady solution) which forces a new group to start at the top of a column. Then you could insert a summary and drag it to the group header. If you format the group to "repeat group header on each page", then the summary will appear on two pages, if the group crosses pages. However, it will only appear in the first column on each page for that group.

-LB

 

[RobNauticus]

Sorry Guys, out of Net Land for a couple of days...

Synapse: I am using columns for my report, including the groups. I am forced to use the Page header as a place for my summary. The design constraints require this layout. Again it is an MS Access 2003 Db with CR 10. My summary information is all based around Group1 that is set to New Page After, so the summaries will always be based on only that one group.

Lbass: I will experiment with your suggestion. The summary information must span the whole page independent of the columns (as in the page header). The Group1 Header and Footer are supressed in the report right now. I have placed my summary fields for group1 there and are also placed on the page header.




I hope this makes it clearer. Thanks!


Page Header:
{Division} Plan Performance
{@ActivePlans} Active Plans, {@Discontinued} Discontinued Plans, Closings to plan Ratio of {@ClosingRatio} : 1

Group1_Hdr{Division}supressed)

Group2_Hdr{@PlanSQFTGROUP}:

Group3_Hdr{CommunityNumber}:

Details: (supressed)

Group1_Ftr{Division}supressed)

Group2_Ftr{@PlanSQFTGROUP}supressed)

Group3_Ftr{CommunityNumber}supressed)