SQL statement at Birt Report for parameters -

SQL statement at Birt Report for parameters -

currently i'm using birt study generate study system. i'm using input parameter send parameter scheme birt report. problem when i'm trying send multiple parameter system.

sql statement @ birt study 1 parameter

select actualdate table1 storeloc = ?;

when utilize query 1 parameter, work.

i tried sql this

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

i created parameter @ info set , study parameter it's still can't gets work

and birt dont show me options in edit dataset query , linked study parameters in parameters

so should do?

create parameter storeloc in study params section of info source. write query in dataset open:

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

fetch actualdate value in info source fetch , run report.

birt