So I've got a report consumer who needs about 20 different reports combined into 1 big one so that they can do some auto pagination and such when they compile these reports as a monthly report. they'd like to then only have to change the source reports instead of having 1 big report to change and then the little ones to change as well...
I've been able to add most of the reports a subreports that way the parameters get passed the same way to all of the reports and it pages correctly. I've added each sub report inside it's own rectangle so that I can do some manual page breaks and such.
the problem I am having is one Matrix report which I can't for the life of me figure out why it won't fit on a 8.5x11 in page in portrait. For some reason the dynamic abilities of the matrix seem to be throwing off my report. I've not had any of the issues with table reports that I do with the matrixes.
The original report is set to 5.125 in wide, originally it was 6.5" wide and I've been reducing it.
I've set the subreport size to everything from 5in to 6.75 in and the result is the same about .125in of my rectangle appears on the next page. Btw, I've tried resizing the rect. the subreport and the original report to even get it this close. Any ideas, or perhaps a better way to have all of the reports generating int he proper sequences with the appropriate page numbers would be very helpful...
Also, the margins have totally been set to 0 at this point for both the source report and the main report, as I figured I'd be able to make use of that space, but that was proven incorrect.
thanks in advance.
To help us help you read this[/url]For better help with performance problems please read this[/url]