Make report Footer the 1st page

[chrisppppp]

Crystal XI

I have a report which has a summary page in the report footer with various formulas in there to show a summary of everything in the report above it. Obviously this summary comes out last the report. I was wondering if there was anyway in which i can code this section to print as the 1st page and then the rest of the report to follow?

 

[hilfy]

The only way I know of is to create a subreport that contains just the summary of the data and put that in either the report header or by itself in the first header section of the first group with "not PreviousIsNull({group field}) and InRepeatedGroupHeader" in the suppression formula for that section.

_Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[lbass]

If you aren't using running totals or variables, you could use the formulas in the report header--so it really depends upon how the summaries in the report footer were created. You could also potentially use a crosstab in the report header.

-LB

 

[chrisppppp]

The problem is that i am using running totals to evaluate in the summary page in the Report Footer. So am i safe to assume that this is now impossible? Any advice for how i could change my report around so that i could have the summary page as page 1?

 

[hilfy]

AFAIK, If you're using running totals, the only way to do this is to use the same running totals in a subreport.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[lbass]

Yes, if you must use running totals, then follow hilfy's advice and use a subreport.

-LB