Swapping data set with different result columns at run time

anitat

I need to use two data sets based on a param value entered by the user at run time. The data sets have different columns. In this case, how to design the report and what column bindings should be used.

Thanks in advance.

mwilliams

Hi anitat,

One thing you could do if you don't have tons of data to slow down your report rendering, would be to create two tables and just hide one based on the parameter value. Another possibility would be you might be able to create both tables and actually drop one of them from the design based on the parameter value. I'd have to look further into this option though, to let you know that it can for sure be done.