Display Dynamic Column in the report

Hi Friends,
I need to display dynamic columns in the report. I have to show column list to the end user then he/she will select his usefull column and then I have to display the selected coumn in to the Report. other column should not be visible in the report.
Any body know hot to do it?

NilayYou could easily set up a parameter for each column and then display that column conditionally based on the parameter.

For instance, if you have a column that displays First Name, you could have a parameter called DisplayFirstName. Then in design view you'd select the whole FirstName column and in the Visibility-Hidden property set it to :

=iif( Parameters!DisplayFirstName.Value = false, true, false )

This could easily become a big, unwieldy report, though, if you have a great number of dynamic columns. Also, The width of the report is set at design time, and it includes the width of all your columns, not just the visible ones. This could cause you some pagination problems.

Hope this helps.|||Thanks "Double americano",

Really its work. Now i have another problem to displaying the all column to the end user. How to derrive the list of coulmns used in the Report.
Once again thanks for help me,
Nilay|||How about if the report had grouping? Will the grouping feature be affected since we're just hiding the columns?|||Hi,
I am designing a report where user can select the columns that they want to see. Based on user selection, I am setting the column's hidden (visibility) property to false. The report hides the data properly, but blank column (no header or data) appears at the end. If user selects8 columns out of max 10 columns, they blank column appear. I tried seeting column width to 0, still that blank column appears. How can i truely hide a column?|||I think Cross Table may be a good Idea for dynamic Columns in Crystal Report.|||

is it possible to change the page width of a report during runtime? or before I run it from VB?

and is it possible to move columns by code during run-time?

I am thinking these are workarounds to the blank spaces when hiding columns

|||Having the same issue, and afaict you can't change a column width dynamically at runtime. It would sure be nice if someone came along and proved me wrong though.
|||

Hello Nilay,

Hi..I am Murali..in my application i have to show columns same like this( as same as u r scenario) ..If u don't mine send me sample example for tihs.

thanks and regards

muraliMD

|||Cant change the column width in runtime. But we can move the column by changing the Left and Top property of Field Object.
|||Hi Murali / Nilay,
Hope this link will explain you in setting Parameter value.
http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspx