Limit columns in a cross tab to 10 1

[ColinGregory]

Hi everybody

Does anyone know a way to limit the number of columns in a cross tab report. In my report the cross tab may have three columns or it may have up to fifteen. Only ten columns will fit on a page so anything over that number spills over onto a blank page.

I've followed Ken Hamadys/lbass/Carynbo's method for creating virtual pages in a cross tab (thread 149-575997) but because there is no pattern to the number of columns which can appear I'm not able to use a formula like "if {table.field} in ["A" to "M"] then 1 else 2"

I need something which counts the columns, if the number of columns is <10 then 1 else 2.

Any ideas out there?

Thanks in advance

 

[Shukhrat]

search and dowload cr6_crosstabs.zip file from

http://www.crystaldecisions.com

 

[ColinGregory]

Thanks for the reply Shukhrat

Need to do a little bit of customization but essentially its exactly what I need.

Thanks again
Colin

 

[Shukhrat]

Hi,
In this sample columns number and rows number related each other, I have problem if I want to put in one cross-tab group of let say 20 patients with columns (analyzes testes) up to 10. and on the bottom of the cross-tab I need get statistic comparison between patients tests.
I mean 11- 20... (more then 10) rows and 10 columns.

Maybe somebody can help me?

Thank you