Report layout changes based on parameter
I have a report that includes multiple parameters. There are two side by side charts included. In the layout view they fit on the page. When I preview the report for most parameters, the report stays on one page. However, when choosing one particular parameter,
the charts on the right hand side go off to a second page when I preview them in print view. A table that is aligned to the right side of the page also splits and is half on page 1 and half on page 2. The charts are identical for each parameter, except for
the actual data points. Otherwise they are exactly the same, even in size when I print them out. So I can not figure out why the are breaking to the next page when there is clearly room for them on page one. None of the other report elements (text boxes with
parameter name, tables, etc.) go onto the second page or are at all different.
November 3rd, 2010 11:41am
Hi,
To prevent "the charts on the right hand side go off to a second page when I preview them in print view", i would suggest you add a Table control and delete some cells only having 2 cells in horizontal, then put the 2 charts into them.
thanks,
Jerry
Free Windows Admin Tool Kit Click here and download it now
November 5th, 2010 5:34am