Printing Report Footer First

[hungtran817]

Hi,

I got this report that I want for the report footer to print as the first page. The reason is that when I place all the summaries on the header, my totals doesn't tie up. So the only way is to have it at the footer. Any suggest either about printing the footer or redoing my summaries would be appreciated.

Thanks,
Hung

 

[IanWaterman]

You can't do it.

Use a subreport which replicates totals and print that in Repor Header.

Ian

 

[lbass]

It depends upon what your summaries are. You might be able to insert a crosstab in the report header, for example. Please specify what your current summaries (if formulas, show the content).

-LB

 

[hungtran817]

I've tried the crosstab route and it didn't like the way to worked. Most of my summaries are running totals.
The subreport works perfectly, the only thing is that when I run the report, it ask for the parameter twice.

-Hung

 

[lbass]

Link the subreport to the main report on the parameter fields. In the subreport linking screen, using the dropdown in the lower left to select {?parm} instead of the default {?pm-?parm}.

-LB

 

[hungtran817]

It works, thanks.