Keeping in the sprit of the earlier discussion on report setup where clauses....
Does anybody know of a way to make a disable clause dependent on another parameter being null?
Thanks and HNY to everybody in Tessitura land!
Matt
Matt -
If your data is a number (depending on the type) you could do something like:
<<p1>> = 0
Where <<p#>> is the parameter you want to check if it has data.
Heather
Hi Heather,
Thanks for responding! Unfortunately, the parameter I am checking against is a string (ug_id). I should have specified that when I posted.
I want to disable parameter 2 if no user group is selected in parameter 1.
I tried out <<p1>> = '' which runs without incident but parameter 2 is not disabled when parameter is (none).
Then I tried out IsNull(<<p1>>,'') = '' but when I run that I get a message of..."')' expected to close expression after function." The clause looks ok to me, but obviously something is not right.
Thanks again,
Hi Matt,
Can you try this for your disable clause.
Len(<<p3>>) =0
Jon
Hi Jon -Nice try but no cigar. The parameter window pulls up fine, the report runs fine, but the disable clause won't work.Funny, if you put in the opposite of what I want to do, like Len(<<p1>>) >0 or (<<p1>>) > '' then the disable clause works the way you would expect.It's a mystery...Thanks!
Matt,
I got it to work, What I had to do was for the table data I used a view for the users, then in the view
I select the users but I do a union all with the following: select
I select the users but I do a union all with the following:
select
'(None)' ,null,null
Which basically gives me the none value in the list for the drop downs. Then in the default value in the report set up I put (None). And in the disable clause I have pos(<<p3>>,'(None)')>0.
If you need the set xml let me know.
Clever! I will give it a try this afternoon.
Thanks Jon!