bikash.kumar Posted August 11, 2014 Posted August 11, 2014 I have designed a report using iReport 5.0.2 and deployed the same to JasperServer(Version 5.5). I added a parameter in report having value like ALL, 5, 10, ... etc by default it appears ALL. But when i am going to select by typing other, it get erased. Please help me out. Thanks in advance.
H Mendoza Posted August 11, 2014 Posted August 11, 2014 Hi there - You will need to check the propteries of the input control and make sure that everything is set up correctly. You will need to provide more information regarding the set up of your input control if you need assistance.
bikash.kumar Posted August 12, 2014 Author Posted August 12, 2014 Please check the below definition and revert back in case any thing need to be added ===================================== <?xml version="1.0" encoding="UTF-8"?> /organizations/organization_1/Input_Parameters scenarioId 9 Scenario Id 2013-06-04T14:18:58.127+05:30 2013-05-07T15:19:35.704+05:30 4 true false true xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="query"> /organizations/organization_1/Input_Parameters/scenarioId_files Scenario_Id_Query 1 Scenario Id Query This will retrieve all the scenarios from DB. Like: ALL S1 S2 . . s18 2013-06-04T14:18:58.127+05:30 2013-05-15T10:49:45.367+05:30 sql SELECT 'all' scenarioId FROM DUAL UNION ALL SELECT * FROM ( SELECT DISTINCT(UPPER(scenarioId)) scenarioId FROM JIRA_VIEW WHERE scenarioId IS NOT NULL ORDER BY scenarioId ASC ) /organizations/organization_1/DB_Connection_Object/JIRA_DB scenarioId scenarioId
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