if statement in ssrs Report (1 Viewer)

ielamrani

Registered User.
Local time
Today, 01:48
Joined
May 6, 2008
Messages
51
Hi all,

I am new in ssrs report.

I created a report with a drop down and so far that worked. I want to put a code that say something like this,

if drop down is equal to FFS I want another column to equal only certain data (for example ddM, ssq)

I am also not sure where the code goes. thanks in advance

hope this is clear.
 
  • Like
Reactions: Rx_

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 13:48
Joined
May 7, 2009
Messages
19,169
i cannot simulate dropdown, either in report or print view.
 

ielamrani

Registered User.
Local time
Today, 01:48
Joined
May 6, 2008
Messages
51
instead of if statement. I created another drop down box but did not work until I modified with the following.

my where statement in the dataset query was missing IN operator

WHERE (TST_PRFM_DTTM BETWEEN @StartDate AND @EndDate) AND (CUST_PROD_GRP = @CustGroup) AND (TST_CD @TestCode)

Now

WHERE (TST_PRFM_DTTM BETWEEN @StartDate AND @EndDate) AND (CUST_PROD_GRP = @CustGroup) AND (TST_CD in ( @TestCode))
 

Users who are viewing this thread

Top Bottom