Add Columns in Crosstab wizard dynamically

[Jegan]

Hi,

   I am working in Telerik Reporting. I am using the Cross Tab Wizard to load the reports. It contains two columns in rowgroups and 3 columns in details section. My scenario is to add the columns dynamically based on the dropdown value. For ex. I have 4 column names in dropdown with multiple checkbox. If the user selects 1 column I need to display rowgroups columns with the selected column. I need to add the columns in Cross Tab Wizard dynamically based on the number of columns selected in dropdown. Is that possible to create the columns dynamically in Cross Tab Wizard based on the condition?. If it is possible please provide me the source code.

       Please reply me asap as i need to complete my task in urgent basis.



Thanks
Jegan S

[Jegan]

Hi,
    
      Can anyone please help me to resolve this issue asap.


Thanks,
Jegan

[Peter]

Hi Jegan,

Instead of adding the columns dynamically our suggestion is to add all of the columns and then conditionally filter the table groups/columns that are unwanted. To explore the table groups, please open the group explorer in extended mode.

Check out the following example that shows how to setup group filter against multivalue parameter:

Expression	Operator	Value
= Join(", ", Parameters.MyColumns.Value).Contains("Column1")	=	=True

Kind regards,
Peter
the Telerik team