show parameters on report

[kuzman]

Hi!

I would like to put the selected parameters on the report. I can do this with the $P{paramname}, but I have defined in the JAsperServer listvalues for possible selection. How can I reach this predifenied listvalues for the report to put on?

Br,

 

Zsolt

[ooober]

aoa

An example in jasperreport > demo> sample > datasource, which shows how you can used POJO (java bean) as a datasource.

You can create a datasource of selected values and passed it to report. If you already have a report, then you can create subreport for this.

 

Regards

Hasham

[vishal29bhp]

As you say you have defined list of values it means you have created the Single select list of values . Now must add this control to the report by just following the instruction by the jsps ,

 

 

[kannantechno]

Hi,

1. Define the parameter name eg : $P(P_Name)

2. Modify the query Eg : select * from <table_name> where <column1> = $P(P_Name)

3.login to the server and edit the required report to configure, click 'control and resource'

4. Add control, then click locally defined

5. define the parameter as defined in iReport P_Name ( ref step 1) and select the parameter type (the user use to select)

6.Locate list of values , click locally defined

7. In the screen, list of values-edit values, the value which u typed here should match the value in the database and also case sensitive

8. click next and save the changes to the server

9. Run the report in the server

reg,kannan