CR 8.5 - dynamic columns | howto

[nyseguy]

Hello. I am trying to create a report where the number of columns can vary (ie. could be 3 or 5, etc.) How can this be done?

I am already working on one approach where I created a table with maximum possible columns, and I managed to suppress the columns that contain NULLs on the report. This solves the issue of hiding empty columns, but crystal does not adjust the space used by suppressed columns - I have blank columns now in the report. Can I shift columns with data to replace those that were suppressed using crystal?

Ideas on different approaches or help with the one I am working on are really appreaciated.

Thanks.

 

[lbass]

Thread149-655589 shows one approach.

You could also insert multiple detail sections, one with 3, one with 4, and one with 5 fields, and then use a parameter to suppress the detail sections you don't want displayed.

-LB