Eclipse Community Forums: BIRT » Report Parameters

Help

Home

Home » Archived » BIRT » Report Parameters(Cascading Parameters)

Show: Today's Messages :: Show Polls :: Message Navigator

Report Parameters [message #1707049]

Tue, 01 September 2015 20:16

latronda Washington

Messages: 11
Registered: March 2014

Junior Member

Hi All, I need some help with cascading parameters please! I have found many examples explaining how cascading parameters work and I see the example of choosing Country, State, City from the cascading examples.

However, what I am trying to do is show one parameter and not 3 different ones. I want to be able to chose either Country, state, or city from one drop down. So, if I chose country, I want to be able to only choose A country and nothing else. As well as, if I choose State, I want to choose a state and nothing else.

What I have in my reports is a parameter that shows a list with 8 items to choose from. I want to choose, for example, Building, and then, once I choose building, I want another list display the buildings. Or, if I choose campus, I want the below list to display the list of campuses.

I have this as part of my dataset for choosing the detail from the list but this isn't working
IF DIFFERENCE(UPPER(@iOption), 'CAMPUS') = 4
--Campus
SELECT DISTINCT T1.TRINAMETX AS NAME--, T1.CDCAssetIDTX AS ASSET_ID
FROM T_TRIPROPERTY T1
WHERE UPPER(T1.TRINAMETX) Not LIKE 'PLEASE% A CAMPUS'

ELSE IF DIFFERENCE(UPPER(@iOption), 'BUILDING') = 4
-- Building
SELECT DISTINCT T1.TRINAMETX AS NAME
FROM T_TRIBUILDING T1
WHERE T1.TRIPARENTPROPERTYTX IS NOT NULL AND T1.TRIIDTX IS NOT NULL
AND T1.SYS_GUIID = 10002954 AND T1.SYS_PROJECTID = 1 AND T1.SYS_OBJECTID > 0

Also, to get my list, which is just a list, I have created this below but I can't seem to tie it in with my detail dataset:
select 'Please Select An Option' AS NAME, 1 AS ID
union
select 'Campus' AS NAME, 2 AS ID
union
select 'Building' AS NAME, 3 AS ID
union
select 'Unit Craft' AS NAME, 4 AS ID
union
select 'Supervisor' AS NAME, 5 AS ID
union
select 'Equipment Type' AS NAME, 6 AS ID
union
select 'Task Name' AS NAME, 8 AS ID
union
select 'Request Class' AS NAME, 9 AS ID
union
select 'CIO' AS NAME, 10 AS ID

Report message to a moderator