User selectable columns

[stuartgmilton]

Hey folks,

Does anyone know if it is possible to allow the report user to select or deselect the columns they wish to view on the report at refresh time?

Stuart

 

[IdoMillet]

Only with an application and if the company running the application has a Developer license.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[stuartgmilton]

So it would have to be done through the .NET app then? So Could I also pass my stored procedure parameters to the report this way as well, that would save the annoying 'current/new data' window coming up?

Cheers

 

[IdoMillet]

Please start a new thread for new questions.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

For a way to make columns dynamic within CR, please see thread149-655589.

-LB

 

[stuartgmilton]

Cheers lbass, thats the thread I've been looking for.

 

[Maximizer]

Greetings! I have seen this tecnique used previously.

First: Create parameter ‘Columns to be suppressed’; All the column headers need to be added in the parameter field.

Create a formula called ‘display_Columns to be suppressed’ and edit the following as needed:


If {?Columns to be suppressed} = “All”
Then “All”
Else {?Columns to be suppressed} [1] +

If Count({?Columns to be suppressed}) > 1
Then “, “ + {?Columns to be suppressed} [2] +
If Count({?Columns to be suppressed}) > 2
Then “, “ + {?Columns to be suppressed} [3] +
If Count({?Columns to be suppressed}) > 3
Then “, “ + {?Columns to be suppressed} [4] +
.
.
.
If Count ({?Columns to be suppressed}) > 9
Then “, “ + {?Columns to be suppressed} [10];


Then in the Column Header, Format text, add the following text to the Suppress formula:

Instr((@display_Columns to be suppressed), ‘enter Column Header here’) > 0;

Then in the Detail Field, Format text, add the following text to the Suppress formula:

Instr((@display_Columns to be suppressed), ‘enter Detail Field here’) > 0;

Just resharing...Thanks!


James Keep, PMP
Crystal Reports(tm) Certified Consultant 8.5 (CRCC)
Authorized Crystal Engineer (ACE)
CMRC
Crystal Decisions Business Partner
Montreal, Qc, Canada

http://www.cmrc.qc.ca