Cross Tab Query CR XI - Horizontal Pages

[robwilliams71]

Hi,

We have a CR based on Product Spec for clothing. Each product can have multible sizes (e.g. A Yellow Bra can be size 34A, 34B etc)

On the main report is the spec (colour, picture etc), then there is a subreport that contains a Cross Tab table based on the individual sizes (this is in the Report Footer)

Each size has 8 records (material used, cut size etc)

Our problem is that when there are more than 6 sizes, the preview does not show them on the cross tab, they are on the 'Virtual Pages'

I have looked on here for help, but with no luck.

The CR help suggests ticking the 'Repeat on Horizontal Pages' check box in the Format dialog box, but this is greyed out.

I have even created a Cross Tab on the report, but it is still greyed out, and I get too many records back in the main report.

Any suggestions please?

Thanks
Rob

 

[lbass]

The crosstab can't be in the subreport if it has virtual pages (since the virtual pages won't appear for a sub), so make the main report the subreport, and put the crosstab in the main report. The other approach you might consider is pivoting the crosstab so that the columns are the rows--but this depends upon how many instances you expect of each.

-LB