Data Set Parameter

JoeO

Hello,

Is there a simple way to have a parameter that changes the data set referenced by a table? I use data object stores as my data sources, so parameters in the SQL is not an option. The data sets are similar and can use the same table format.

I am not familiar with javascript, but the solution might be to use the beforeOpen script of the data set or the onPrepare script of the table.

Any thoughts would help!

mwilliams

Do they have the same columns and everything? If it's only a few different tables, it might be easy enough to create all three tables and then drop the ones you don't need from the report in your beforeFactory method, based on your parameter value.