May 12, 2011 at 4:16 am
hello all,
i have 2 hierarchies in my report
hierarchy 1
region->country
hirarchy2
cutomer->city
i have 4 parameters in the report accordingly
when i select hierarchy1 can i disable hierarchy2 parameters?
similarly if i select hierarchy2 can i disable hierachy1 parameters?
May 12, 2011 at 7:01 am
The short answer is yes, but the hard part is writing the dataset query that will behave properly. Probably you will have to build 2 mostly identical blocks of code that use the different parameters and then use a IF or CASE statement to decide which block to run.
May 12, 2011 at 7:08 am
yes i have used the if condition.
it says
if(hierarchy-1)
(
display values for region and country parameters
)
else
default value
if(hierarchy-2)
(
display values for region and country parameters
)
else
default value
but in this case
when i select hierarchy 1 its popping up values accordingly in to the region and country parameters but even hierarchy 2 is popping up with default value instead of that i need to disable that parameter itself it so that wont pop up anything(looks like disabled)
May 12, 2011 at 9:24 am
I don't really understand your issue. Are you trying to manipulate your dataset query to return the right data in both cases, or are you trying to display or not display your parameter selections based on an earlier selection?
May 12, 2011 at 11:28 pm
hi,
we have four 5 parameters totally
hierarchy(to select hierarchy 1 or hierarchy 2)
region(to select region when we go for hierarchy1)
country(to select country based on region selected for hierarchy 1)
customer(to select customer when we go for hierarchy2)
city(to select city based on customer selected for hierarchy 2)
so user will select either hierarchy 1 or hierarchy 2
when he selects hierarchy 1 then hierarchy 2 parameters(i.e customer and city parameters must be disabled)
when he selects hierarchy 2 then hierarchy 1(i.e region and country parameters must be disabled)
this is the requirement
May 13, 2011 at 7:26 am
I don't believe you can truly disable a parameter. But you have a couple of possible options.
The first option would be to populate the available value of the undesired parameters with a single dummy value such as "N/A" so that it is clear to the user to skip that parameter.
The second option would be to make your parameters generic. For example you could label the first parameter as "Please select Region or Customer" and the second as "Please select Country or City" and then set the available values of the parameters to be filled appropriately depending on the hierarchy choice made initially.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply