Cross Tab Inserting Page Break and Additional Column 1

[tcgoth]

CR 8.0
SQL

I currently have a Chart & Cross Tab Report in the Report Footer.

Q1 How can I get the Chart to appear on page one, page break, then begin the Cross Tab Table on page two?

Q2 I want to add a column to the cross tab but I do not want the info to appear in the graph AND all I want is the Totals (AddTotColumn below). This column would be a count of primary activity by client. "Serv1 etc..) is a display of secondary activity and we want to be able to compare Primary to Secondary.

Here is an example of the output I would like:

Serv1 Serv2 Serv3 Totals AddTotColumn
Client 1
Client 2
Client 3
etc....

Hopefully this makes sense. Thanks!

 

[lbass]

Insert an extra report footer section and place the chart in the first one, and then format the section to New Page After. Place the crosstab in the b section.

Your best bet in CR 8.0 is to create a second crosstab that uses the count of primary activity as the summary and that uses client as row (no column field). Then suppress the row labels, and in the customize style tab, go to format grid lines->select the unwanted lines->uncheck "draw". Then overlay this new crosstab on the first, using magnification to align the borders.

-LB