Page Break on Columns

[n_ramesh_in]

Hi All,

I have a cross tab report which is sectioned on Product Category .There is also a page break applied on the same.The numer of columns of the cross tab depends on the number of values fetched from the database.But the client wants only 10 columns to be displayed on a single page and from the 11 column onwards(next 10 records) should be on the next page.How do i achieve this ?
Ramesh

[COGNOiSe administrator]

This would be an interesting enhancement request.

[goose]

This can be done, set the "Rows Per Page" for the crosstab to 10. In the below example you will see this working with a setting of 4 for "Rows Per Page". This might only work if the data coming back in the crosstab query is at the same level that you want to break it up on. When I get a chance will test if crosstab aggregates data the principle still works.

PS: if the item you are grouping on has 15 records for example, 1st page will crosstab with 10 records, next page  will have crosstab with 5 records

[goose]

n_ramesh_in do you want columns or rows (like above post) spread across pages?

[COGNOiSe administrator]

I think he said columns ... Rows are easy.

[goose]

Yeah think your right....

[n_ramesh_in]

yeah i said columns.. :)