Run query based on parameter

[roopurt18]

I'm trying to do something like:

 

select * from (
  case 1
  when 1 then (
    select distinct
      p.pro_code, p.project
    from 
      wsproj p, wsjob j, webopthd o
    where
      p.pro_code=j.pro_code AND
      j.job_code=o.job
    order by
      p.project
    )
  else (
    select pro_code, project from
    wsproj order by project
    )
  end case
) as t

 

Basically I need to run one of two queries based on a parameter.  This is done in a report writer so I can't use programming logic to choose one query or the other.

[Barand]

Can the report writer handle stored procedures?

[roopurt18]

Yes it can.