|Parameter that decides wich table show [message #704506]
||Thu, 28 July 2011 14:01
Registered: July 2011
Hello BIRT comunity, |
I'm quite new into BIRT; I am developing a report that shows the content of a database table which is selected by a parameter in a previous JSP page.
I have modified the "this.queryText" within the beforeOpen event in the dataset ( this.queryText.replace("TABLENAME",parms["MYPARAMETER"].value)") And I just get the data I really want from the table I selected, but I don't know how to "print it" into the report, if I just draw a table within the layout view I got the following message
Column binding "CUSTOMERNUMBER" has referred to a data set column "CUSTOMERNUMBER" which does not exist. (Element ID:967)
because the name of the columns do not match with the name of the supossed table I selected (for example ORDERS)
I also tried to change the column data binding expression like this
if (parms["MYPARAMETER"] =table1)
if (parms["MYPARAMETER"] =table2)
but It doesn't work neither
So, in a nutshell, how can I show in a table the content of a "parametrized DataSet" wich I don't know the name of the columns in advance ?
Thank you very much
Powered by FUDForum
. Page generated in 0.02139 seconds