How to map columns names to query dynamically at runtime?

Rana

Hi,

Iam very new to BIRT.
Iam fetching column names from DB & asking user to select the columns to display in the report?
But my question is how can i map the user selected columns to the sql query to display the report with the user selected column..

Any help is appreciated..

Please let me know if u need better clarification on question?

Thanks in Advance

mwilliams

Hi

You can build the query in your dataSet's before open script with this.queryText = "select ......"

So, you could use the selected values for the columns to build your query in javascript.

Hope this helps.