Skip to Content
0
Former Member
Mar 17, 2009 at 03:12 PM

Conditional Parameter problem

22 Views

Hi,

I have two parameters coming from Stored Procedure using if-else condition. (if param1 selected show A,B,C,D fields or if param2 selected show C,D fields - both parameters cannot be selected at same time).

But, when adding Data source(Procedure) to the report i have to enter either of the parameters (I entered P1)which results in filtering of the records at that time. And, when i run the report afterwards with 2nd parameter(P2) it is not showing any records for the fields(C,D). I also tried giving both NULL values while adding data source but, the result is same.

Is there a method to resolve this either in procedure level or in report level.

Thanks in advance.