PlSql Filter code for SSRS Report

Filter code SSRS

where TO_DATE(COL_Date, 'mm/dd/yyyy') = :Date_VAR
AND TO_CHAR(NVL(COL_CHAR,'*')) = REPLACE( :CHAR_VAR,'ALL',NVL(COL_CHAR,'*'))
And  NVL(TO_CHAR((COL_NUMERIC)),'*') = REPLACE( :COL_NUMERIC,'ALL',NVL(TO_CHAR((COL_NUMERIC)),'*'))
PlSql Filter code for SSRS Report was last modified: October 1st, 2017 by Justin Antony

About Justin Antony

https://forum.sqlpublic.com

Leave a Reply