Want to fire a query on report parameter and display it value on report.

[chavda.charmi]

Hello All,

I am able to generate report successfully now I don't know is it possible what I want to do.

I am taking some parameters based on which I am generating report. So I created Main dataset which executes db procedure.

Now i want to display value from database according to a parameter. say I have 3 parameters and lets assume that one of the parameter is Id, 

Now reports get generated based on parameters in extra i want a textfiled above report to display  name associated with id that I need to fetch from database.Is it possible?

For this I tried to take another datasource but the problem is that parameter is passed in master datasource how can i pass that parameter to newly generated datasource?

 

Thanks in advance

[Siddharth Kothari]

Hi,

It is possible to achieve your requirement. Follow below steps:

1.     Create a parameter in second dataset.
2.     Use List element to show associated name.
3.     In list element's dataset property map first dataset parameter with second dataset parameter.

I have attached a file below which has implementation of above steps.

/sites/default/files/files/Sample_jrxml.txt