Drop down box with 1 Manual option

• Staggerlee

  SSCertifiable

  Points: 5272

  More actions

  March 2, 2012 at 8:02 am

  #269346

  Hi all,

  I would like to populate a drop down box from a query. and have one manually added option as well.

  I have written a tsql script that queries based on a Where column A = @result.

  If @result is 'discount' then it looks for discount in Column B

  For that i just created a IF statement. But im not sure how to impletment it in a report.

  In SSRS Parameters is based off a query

  select *

  from auditcategory

  thanks for any help.

  S

• Staggerlee

  SSCertifiable

  Points: 5272

  More actions

  March 2, 2012 at 8:35 am

  #1454230

  Hi anthony.greengave me a simple solution using

  select *

  from auditcategory

  UNION

  select 999, 'Discount'

  For the param query.

  Seems to get it working. Thanks Anthony again and apologies for ending up with double post on the same thing!

  S