mysteryminds Posted September 8, 2011 Share Posted September 8, 2011 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 SERVER5, When I runt he same query in Jasperserver (4.1), It will display the popup requesting to input the details6. 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. Link to comment Share on other sites More sharing options...
waalp Posted September 8, 2011 Share Posted September 8, 2011 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 Link to comment Share on other sites More sharing options...
mysteryminds Posted September 8, 2011 Author Share Posted September 8, 2011 Hi PeterWell that's the exact thing I did in Jasperserver.I went to the folderRight Click > Create Input ControlType > Single ValuePrompt Text > evtdtParameter Name > evtdtand attached that to the report too...But it doesn't seem to work.. :( Well I need some help on this please Link to comment Share on other sites More sharing options...
waalp Posted September 8, 2011 Share Posted September 8, 2011 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 Link to comment Share on other sites More sharing options...
mysteryminds Posted September 8, 2011 Author Share Posted September 8, 2011 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. Link to comment Share on other sites More sharing options...
mysteryminds Posted September 8, 2011 Author Share Posted September 8, 2011 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? Link to comment Share on other sites More sharing options...
waalp Posted September 8, 2011 Share Posted September 8, 2011 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now