Cascading Parameters : BIRT

Senz79

Hello All

Does any one has the steps to create the Cascading Parameter Groups in BIRT

thanks

Senz

Find more posts tagged with

Comments

mwilliams

Hi Senz,

What problem are you having with cascading parameters?

Senz79

Hello

Sorry for the late reply

I will explain what ia m doing

I have created two data set

1. ds_Account
query : select distinct substr("Server_Name",9,3) as "Account", "Server_Name" from "NT_System_H"

This fetches the three letter account name and the server name

2. ds_Server
query : select distinct "Server_Name"
from "NT_System_H"
where "Server_Name" Like ?

which fetches the server name which matches the criteria
here i have created a parameter and connected it to a report CP_Account, which fetches data using the ds_Accounts.

Now i have created a cascading paramete

1. CP_Account which fetches data using the first data set and fetches VALUE as account and DISPLAY TEXT as Account.

2. CP_Server which uses the second dataset to fetch the servers based on the input from CP_Account.

I hope the steps which i following are right as i have reffered to a sample cascading report sample.

But yet i am not able to fetch data for the second list ie the SERVER.

Kindly help me in fixing this.

Thanks
Senz

Virgil Dodson

What might be missing is the link between your newly created cascading paremters... and your data sets. After creating your cascading parameters from multiple data sets, go back into your data set, parameters tab, and link the parameter to your new cascading parameter.<br />
<br />
I created an example of a cascading parameter group and included screenshots of the steps I took using BIRT 2.3.2. I uploaded it to the DevShare area of BIRT Exchange at <a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/969-birt-cascading-parameter-example/#description'>BIRT Cascading Parameter Example - Designs & Code - BIRT Exchange</a>