2005 IR Help Posted September 2, 2006 Share Posted September 2, 2006 By: Dennis M - dennis2681 Help - Can't lock PageFooter at bottom 2005-07-07 12:48 Is there anyway to lock the page footer to the bottom of a report? It seems to work fine when I run single reports -- but as soon as I use the report as a sub-report the page footer jumps up the page to the end of the detail section. Please advise. Thanks. Link to comment Share on other sites More sharing options...
blurboiboi Posted July 20, 2007 Share Posted July 20, 2007 this seems to be a common problem....i am facing it myself....are there any "cures" for it??? thanks Link to comment Share on other sites More sharing options...
jmurray Posted July 21, 2007 Share Posted July 21, 2007 The page footer of a subreport is part of the detail band of the main report. That means that the page footer becomes more like a section footer when the main report gets rendered. That's why you see the output that you describe. The solution is to either: pass the information you are interested in back to variable(s) in the main report and use the variables to display information in a page footer in the main report or use a separate subreport in the page footer band of the main report. Typically this type of subreport would have a query that is based on the query of the subreport used in the detail band of the main report, but would return only summary information using aggregate functions (eg. sum, count, avg, etc.) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now