Print out Filter values

• Tom_Sacramento

  SSCertifiable

  Points: 6213

  More actions

  April 30, 2015 at 9:25 am

  #307537

  Is there a way to capture the filter criteria to a text field (not Parameters-those are well documented)

  There are two ways of selecting report data, parameters and filters. The parameters are easily transferred to a text field on a report but I have not figured out how to get to the Filter criteria to print on the report.

  It is important that the report recipient know what criteria was applied to the report and since the recipient is not necessarily the person running the report I like to show it on the report to cut down on questions and assumptions.

  Thanks in advance

  Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/