Large crosstab. 1

[mrainv]

Hi folks,

I have a very large cross-tab in CR10 that is causing me some problems. The cross-tab itself is located in a subreport in a group header on the main report. The cross-tab is set up to fill a square in black when the column total is > 1, creating a "true" condition. If the column total = 0 or "false" the field is blank. It's a visual grid representing scientific samples and what analyses need to be performed on any given sample.

The problem is that it can potentially have a lot of rows and columns. Several things are happening at the moment. In this specific data set, the rows are at 61 records and the there are 52 records in the column field. As expected, the columns are spilling over to the "virtual pages", 3 of them to be exact and the rows are also going to 3 pages. The problem is that the virtual pages aren't printing or showing up when I preview the entire report, only the subreport. It seems to be working properly until it gets to row 61 when it repeats rows 1-61 but with the exact same columns, 1-17 rather than 17-34.

Ideally, what I'd like to do is display rows 1-18, with columns 1-17 on the first page. Page 2 would then be rows 19-39, columns 1-17, page 3 rows 40-61 with columns 1-17. The next page should now repeat rows 1-18 but with columns 17-34 and so on.

I must be missing something obvious, but I can't seem to track down the problem...or maybe there is a better way to deal with this data?

Thanks.

 

[lbass]

The problem is the use of a subreport which doesn't expand to virtual pages. If you placed the crosstab directly into the report, you shouldn't have a problem. If you place it in the report footer, you will have a page footer where you can place a page number and a horizontal page number for assembling when you print. Note that virtual pages print first, so the numbering would be: page 1-1, page 1-2, page 1-3, page 2-1, page 2-2,etc. where the second number is the horizontal page number.

-LB