CODEWITHSUNDEEP
birt
qys
qys

Reputation: 13

SQL statement at Birt Report for parameters

Currently I'm using Birt Report to generate report from my system. I'm using input parameter to send parameter from my system to Birt Report. The problem is when I'm trying to send multiple parameter from my system.

SQL statement at Birt Report for one parameter

select actualdate from table1 where storeloc = ?;

When I use this query for one parameter, it work.

I tried sql like this

select actualdate from table1 where storeloc = params["storeloc"].value;

I already created parameter at data set and report parameter but it's still can't gets to work

and also birt dont show me the options in edit dataset for query and Linked To Report Parameters in parameters

so what should i do?

Upvotes: 0

Views: 3950

Answers (1)

Samaya S
Samaya S

Reputation: 11

Create a parameter storeloc in report params section of Data source. Write this query in dataset open:

select actualdate from table1 where storeloc='"+params["storeloc"]+"';

Fetch the actualdate value in data source fetch and run the report.

Upvotes: 1

Related Questions