Input Controls having issues while publishing to Jasper Report Server

[mysteryminds]

Hi Good Morning to all the JRS Users.

I have a problem in publishing the Input Control to the Jasperreport Server. please find below the tasks which I've followed and still not able to find the solution for it.

1. Created a crosstab report in IREPORT 4.1.1 which is quite basic as I'm trying to understand the Jasperreport.

2. The query of the cross tab is SELECT  * FROM  `msisdn_active` msisdn_active WHERE evt_dt = $P{evtdt}

3. When executed in IREPORT it shows a popu screen asking for enter the date and provides the result pertaining to the mentioned date without any issues.

4. Now the MESS starts as I did publish the report to the Repository of JASPERREPORT SERVER

5, When I runt he same query in Jasperserver (4.1), It will display the popup requesting to input the details

6. Once I provide the same details related the tests which I did in IReports 

I get this message all the time "The report is empty." nothing more than that.

 

7. Now I changed the query inside the JASPERREPORT SERVER  to SELECT  * FROM  `msisdn_active` msisdn_active WHERE evt_dt = 2010-05-11 

8. Executed directly without any Input controls it works without any issues. 

So could anyone let me know where am i going wrong.

[waalp]

Did you create an input control on JasperServer with the exact same id as your parameter name in the query, and linked it to your report ?

Regards,

Peter

[mysteryminds]

Hi Peter

Well that's the exact thing I did in Jasperserver.I went to the folder

Right Click > Create Input Control

Type > Single Value

Prompt Text > evtdt

Parameter Name > evtdt

and attached that to the report too...

But it doesn't seem to work.. :( Well I need some help on this please

[waalp]

I usualy do this from iReport itself.

 

-Go to the repository tab in iReport

- Select the folder in wich you save your input controls

- right click the folder, select add -> inputcontrol

- In the id field, put your parameter name (it has to be exact to the value in between the $P{}

- Give it a prompt name

- In the input control details tab, select single value, and select a datatype (you can create a datatype in the same manner in iReport)

- Then go to the folder of you report, and on the input control map right click and select link an existing input control, and select the input control you just created.

 

Regards,

Peter

[mysteryminds]

 Peter 

Thanks for the help, 

I'm not able to do the last step coz i'm not able to find the input controller i've created "evtdt"

 

you can check the screenshots of the process i've followed as per your instructions.

Please advise.

[mysteryminds]

peter!

Well tried your option, but still the same issue....

I'm using IReports 4.1.1 and jasperserver 4.1 is it a good combination?

[waalp]

I'll try to see if i can reproduce your error here.

 

We are using ireports 4.0.1 and jasperserver 4.1, so I think that shouldn't be an issue.

 

Greetings,

Peter