I have the following SQL:

   select distinct inspectionid, stationid from
   StationInspection
   where stationid=2
   

that will give me a list of all inspectionid and stationid's where station id is 2. that works great. the problem is i want to surppress a "NOT FINIHSED" if a 2 doesn't exist with a certain inspectionid (which is the only parameter in the report). to surppress the text i am using the following code:
   
   {Command.stationid} = 2

Command is the SQL i inserted into the report, which is the SQL i pasted above.

the report is going from the actual SQL table to the SQL above.

the problem is i can check the SQL with an inspection id that DOESN'T have a stationid that is equal to 2, but the text stays suppressed when it should be showing.

any suggestions are gladly accepted

Edited by zach18 - 29 Apr 2011 at 6:57am

correct. if the station id is 2, i want the text to be suppressed.

when i excute the SQL
   select distinct inspectionid,stationid
   from StationInspection
   where stationid=2
in the sql server management studio it brings back a list of all the inspection numbers that are equal to 2. To verify i was right, i added WHERE inspectionid = 12345(which is the inspection id i want to check for station 2). The query came back blank, suggesting that the particular inspectionid did not have a stationid = 2. the suppressed text should then show up, but it doesnt.

Edited by zach18 - 29 Apr 2011 at 8:02am

that's what i was missing, i just needed to make sure the result wasn't null. it works now.