0 Replies Latest reply: Aug 16, 2012 4:58 PM by alian_deloitte RSS

    Trellis Chart and Printing

      Hi,

       

      I have a chart that uses the trellis property to compare between a certain variable (ex: City).

      I am doing a horizontal bar chart with 8 rows, each a bar chart. My cities are my columns and my 8 rows are the variables that I am comparing across cities. In this case, they are Questions.

       

      My problem is with printing the report.

       

      I want to print a report so that if I have 8 Questions per City, with 20 cities, there should be 10 pages to my report.

       

      Why 10 pages?

      Each page should have 4 columns - each column a city. That's 5 pages.

       

      Then, since having 8 rows per page is too compressed, I want to show the first 4 Questions on one page, and the last 4 questions on a second page. So 5x 2 = 10 pages.

       

      I know that when you print a report, there is a Banding option. But it only lets you band by one variable -- either cities or questions.

       

      Does anyone know a workaround to get me to my desired out come of 10 pages?

       

      Thanks!