Report setup disable clause

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,

Matt

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:

 '(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.

Jon

Clever! I will give it a try this afternoon.

Thanks Jon!

I know this post is from many years ago, so this may be a long shot, but Jon, any chance you could further explain your solution in a bit more detail?

I'm trying to replicate the solution, but am not sure how to proceed.

Thanks!