Hello all,
I have two parts in my report. Each part needs a diff set of
parameters.
Need a way to hide one of the 2 parts based on the parameters typed in
(like if they type in A or B or C i need to hide ReportX and vice-versa
if they type in D, E, F). Tried the table properties Visibility
properties but not much success.
Any ideas will be appreciated.
Thx
BofoI am able to get the thing working by using the following expression.
iif(Parameters!param1.Value="", TRUE, FALSE)
But the problem is I have 4 params like this.
I am trying to use the iif inside an iif. But havent had success yet.
Thx
Bofo|||iif(Parameters!param_numAvPrevia.Value="",
iif(Parameters!param_avPreviadesde.Value="",
iif(Parameters!param_avPreviaHasta.Value="",
iif(Parameters!param_estado.Value="", TRUE, FALSE), FALSE), FALSE),
FALSE)
trying the above expression. But no success yet.
I get the error saying its not a proper boolean value.|||finally Got it going.
Thought may help someone.
Here is the expr i am using for the Visibility.hidden
=iif((Parameters!param1.Value + Parameters!param2.Value +
Parameters!param3.Value +
Parameters!4.Value)="", TRUE, FALSE)
Rgds
Bofo|||finally Got it going.
Thought may help someone.
Here is the expr i am using for the Visibility.hidden
=iif((Parameters!param1.Value + Parameters!param2.Value +
Parameters!param3.Value +
Parameters!4.Value)="", TRUE, FALSE)
Rgds
Bofo
No comments:
Post a Comment