Eclipse Community Forums: BIRT » Parameter that decides wich table show

Help

Home

Home » Eclipse Projects » BIRT » Parameter that decides wich table show

Show: Today's Messages :: Show Polls :: Message Navigator

Parameter that decides wich table show [message #704506]

Thu, 28 July 2011 14:01

josete4ever
Messages: 2
Registered: July 2011

Junior Member

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)
{
setDataRow["Rowoftable1"]
}

if (parms["MYPARAMETER"] =table2)
{
setDataRow["Rowoftable2"]
}

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

Report message to a moderator

Re: Parameter that decides wich table show [message #704570 is a reply to message #704506]

Thu, 28 July 2011 15:32

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

If you have a small number of tables then why not add them all and then
name them. Then in the beforeFactory drop the ones you do not need.

reportContext.getDesignHandle().findElement("mytable1" ).drop();

This is simpler than calling the de api to change a tables bindings.

Jason

On 7/28/2011 2:01 PM, josete4ever wrote:
> 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)
> {
> setDataRow["Rowoftable1"]
> }
>
> if (parms["MYPARAMETER"] =table2)
> {
> setDataRow["Rowoftable2"]
> }
>
> 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
>
>

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Parameter that decides wich table show [message #705249 is a reply to message #704570]

Fri, 29 July 2011 12:08

josete4ever
Messages: 2
Registered: July 2011

Junior Member

Thanks for your response, at the end of the day what i did is to change the expression for visibility of some tables in the report like this:

Visible if ---> params["TableName"].value != "ParameterTableName"

Embarrassed

Thank for your response.

Report message to a moderator

Re: Parameter that decides wich table show [message #705261 is a reply to message #705249]

Fri, 29 July 2011 12:16

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

Sounds good, but remember hidden tables still run queries.

Jason

On 7/29/2011 12:08 PM, josete4ever wrote:
> Thanks for your response, at the end of the day what i did is to change
> the expression for visibility of some tables in the report like this:
> Visible if ---> params["TableName"].value != "ParameterTableName"
>
> :blush:
> Thank for your response.

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Parameter that decides wich table show [message #709147 is a reply to message #705249]

Wed, 03 August 2011 11:01

M P
Messages: 3
Registered: June 2011

Junior Member

I soved above problem by removing alias from the Query !!

like insted of SELECT v.name as newname FROM table; just use
SELECT v.name FROM table; Alias is creating problem in column binding.

Also if you use birt- viewer then use preview command insted of frameset .

Report message to a moderator

Previous Topic:	Integrating the Report Engine to RCP plugin
Next Topic:	(no subject)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 06:45:12 EDT 2013