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; } } }

Filter parameter depending on value of another parameter

minthril

Hello,
 
I am making report in BIRT Designer Pro using Data Models.
 
I would like to improve parameter input in this way that list of possible values (based on one of Data Models) for parameter (lets call it 'C') will be populated depending on other two parameters (call it 'A' and 'B'). Parameter 'A' will be 'starting date' and parameter 'B' will be 'stop date' to specify time shift. Such approach would be very user friendly because user will be aware of possible values in selected time interval. Without this he will be forced to type and try - it is very time consuming approach.
 
I know there is something called 'cascading parameters' but I am not sure if such thing like filtering is there possible. I tried and was not able to reach acceptable results.
 
Could you please write me if this idea/operation is possible in BIRT? And if yes - could you describe me how to reach this or attach simple sample?
If I wrote (probably..) it unclear - please just ask and I will try to ask in better way

Best regards,
minthril

Find more posts tagged with

Comments

JFreeman

Depending on how your data is setup, cascading parameters may be able to do what you are wanting.
 
I've attached a simple example of using cascading parameters. I set it up with Order Date, Ship Date and Order Number to simulate only displaying orders that align with the Order Date and Ship Date.
 
If you can attach a sample of your data, I can see about writing an example that more closely aligns with your use case.

minthril

Hello JFreeman,
 
thank you for your reply and example. My description was not clear enough but thanks to your report design I hope now it will be clear.
 
I would like to reach situation when: based on two parameters with datepicker (not from data source) the third parameter (list of values from data model) will display only filtered values in previously selected interval.
 
I uploaded little changed report. I added two parameters "dateFrom" and "dateTo".
The situation I would like to reach is that I specify dateFrom and dateTo -> values of for example "Order Date" is dynamically checked if in this range ("dateFrom"-"dateTo") and based on this only "Orders" inside the selected interval will be available/displayed to select.
 
Is something like this possible? This sounds like "cascading parameters ++" but I think someone had such a case before.
 
Maybe it there any possibility to make 2 steps parameter page. First page contains only selecting date. After this page data source is little filtered and shows only values in interval we want - after final selection report runs/generates. (We use iHUB, maybe this will point the way how to handle this)
 
I very appreciate your help, thank you

minthril

Any ideas?
 
Best regards,
minthril

JFreeman

I've been trying a few different things and so far it does not look like using cascading parameters is gong to meet your full requirements.
 
The two options I have come up with thus far are:
 
- Create a custom parameters page.
- This will probably be the most involved/challenging but will provide the most flexibility.
- Take a look at this blog post for reference on getting started with a custom parameter's page: <a data-ipb='nomediaparse' href='http://blogs.actuate.com/custom-parameter-pages/'>http://blogs.actuate.com/custom-parameter-pages/</a>
 
- Create a report that will essentially act as a parameters page that will then drill to the actual report and pass it the parameters selected in the first report.
- This may be a bit quicker/simpler than creating a custom parameters page but isn't as elegant of a solution as a custom parameters page.

minthril

Hello JFreeman,
 
thanks a lot for your advices. I think the second option could be fine for now.
 
When you write: "- Create a report that will essentially act as a parameters page that will then drill to the actual report and pass it the parameters selected in the first report." 
you think: first report will take information from parameter page and use it in next report parameter page?
 
Could you please show me sample (even with one parameter)?
 
 
Best regards,
minthril

JFreeman

The first report will act like a parameters screen (kind of like a custom parameter page but inside of a report design) and will then pass the selected values into the associated parameters in the actual report.
 
I will work on seeing about creating you a simple example.
 
What version of BIRT Designer Professional are you using?

minthril

Thank you for fast response

I checked Help->About and there I found:
Actuate BIRT Designer Professional 
Version: 4.2.3
 
Best regards,
minthril

JFreeman

Thank you for the confirmation on your version.
I will see about making you an example.

minthril

Hello

any updates?

Best regards,
minthril

JFreeman

Sorry for the delay.
Things are very busy on my end right now.
 
You are on the top of my list for examples and I will try and get it to you as quickly as I can.

JFreeman

Sorry again for the delay.
 
Attached is a simple sample that demonstrates a driver report acting as the parameters page.
Take a look at the sample and let me know if you have any questions.