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.