This discussion is archived
1 Reply Latest reply: Dec 5, 2013 12:23 AM by user607649 RSS

Convert this filter to SQL

user607649 Newbie
Currently Being Moderated


I have 2 prompt ID and BIC

both i set Presentation variable.I passed this values into my report filter.In report filter i set "Covert this filter to SQL" option.

But when i choose values into my both Prompt then i can able to see values in my report.But when i choose single prompt value then not able to display.

Please check my filter. When i set directly Credit_Bic like '%%' then working fine but when i put case condition then not display any records?

and"Case Header"."Credit Id" LIKE (CASE WHEN '3582020570001'='' THEN '%%' ELSE '3582020570001' END)
and"Case Header"."Credit Bic" LIKE (CASE WHEN ''='' THEN '%%' ELSE '@{ClientBIC}' END)






  • Correct Answers - 10 points
  • Helpful Answers - 5 points