Jump to content
Changes to the Jaspersoft community edition download ×

Not able to select menu from drop down in JasperServer-pro 5.5 as input control


bikash.kumar

Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...