nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

multiple parameters

newbie1 · 2015-04-09T11:23:37+00:00

Hi, I need to create a report that allow user to enter either one of the 7 parameters. My SQL query is as such: select * from table where f1 = ? -- paramter1 or f2 = ? -- parameter2 or f3 = ? -- parameter3 etc.... Cascading parameter is not it.…

newbie1

Hi,
 
I need to create a report that allow user to enter either one of the 7 parameters.
My SQL query is as such:
 
select * from table
where f1 = ? -- paramter1
or f2 = ? -- parameter2
or f3 = ? -- parameter3 etc....
 
Cascading parameter is not it. Multi Select does not work since it requires only one parameter and multi value. Dynamic does not work because the user can key any one of the 7 parameters.....HELP. I'm stuck at this for the last 2 days.

Find more posts tagged with

Comments

newbie1

sorry, I'm using Birt designer 4.4.2

JFreeman

You can create a report parameter to be paired with each query parameter.

Alternatively, you can use some javascript on the data set to manually add the parameter by modify this.queryText.

newbie1

Thank you Jesse for the fast response. The first option works fine and since I'm new to java script....I'll leave that alone for now.
 
Thank you

JFreeman

You're welcome.
Let us know if you have additional questions.

newbie1

Hi Jesse,
For this report with a list on Parameters, when I ran the report in HTML or Web View, the report is running fine. However, when I run this in PDF (Run -> View Report -> as PDF) - the parameters selection list did not show up and the report got run (with 0 result coming back - which is correct since there is no parameter pass to the query).
 
I download a few of sample of Parameter reports from Birt Forum and ran it as PDF and had no issue. However, there's only one difference between my report and the other sample reports is that my report don't have "Required" parameters. Could this be the result ?
 
Thanks in advance.

JFreeman

So your report does not have any required parameters?
 
If that is the case, I do believe that will be why you are getting that behavior with PDF. If there are no required parameters, I do not believe it is going to prompt for the parameters to be entered when exporting directly to PDF through the designer. It will instead just take the default values for the parameters.
 
If you change just one of the parameters to required in your report design, you should get the parameter prompt when going directly to PDF.