Number of Cross Tab Columns user defined

[crystalize]

I have created a formula that asks how many columns do you want to see. Next I need to put that formula somewhere into the cross tab so that it will create the number of blank columns I specify.

Also I would like it to number the columns across the top.
Such as column 1, column 2 etc.

Crystal 8, Pervasive SQL 2000i.

 

[lbass]

Are some of the columns populated? Why do you need blank columns? You'll probably need to create a manual crosstab or a manual grid.

-LB

 

[crystalize]

Thanks for your reply. None of the columns are populated. The rows are populated. It's a check list. When the first item in the row is accomplished column 1 get a check mark, when it happens again column2 gets a check mark. Each report has a different number of columns. They are at random. Sometimes 2 columns or 8 columns or 15 columns.

When I print the report I need to have the system ask me how many columns do you want on this report.
Then create the report with the right number of columns.



completed 1 time|completed 2nd time| completed 3rd |
task a
task b
task c


Create the grid only, the user will manually place a check mark in the cell for task 2 column 1 (completed 1 time).

I hope this helps explain it better. The part I need help with is to create the number of columns based on a user prompt for each time the report is printed.

 

[lbass]

How is the user entering the checkoff? Via parameter? This seems a more appropriate report for Excel, where you can maintain the results over time (with subsequent printing). CR won't keep the previous entries unless they are being written to the database, and CR isn't meant to do that.

You could create the column headers conditionally with a formula like this used as each column header:

if {?number of cols} >= 2 then
"Completed 2nd Time} //changing the number for each header

-LB

 

[crystalize]

The user is just writing in the checkoff cell. Also, we don't care about a history.

Tell me more how creating column headers conditionally would work.

I need it to create the number of columns required for this report. Each time the report is ran it will be a different number of columns.
I'm thinking it would work like a parameter. It would prompt me "How many columns do you need for this report now?" I'll select 4 and it will give me 4 columns.

It seems like the column headers conditionally may work but
I'm not sure how to do it.

 

[lbass]

Just create enough formulas to correspond to the maximum of columns like the one above (without the mistake):

if {?number of cols} >= 2 then
"Completed 2nd Time" //changing the number for each header

Lay them out in your page header horizontally.

-LB