Non - standard SQL data model bind to different templates

Summary

Non - standard SQL data model bind to different templates

Content

Hi there

I was wondering if it was possible to bind a non-standard SQL query parameter to a Report template with BI Publisher.

So for example based on the SQL below. If user chooses 'Consolidation' from the list of parameter values use report template A

and if user chooses 'Detail' from the list of parameter values use report template B.

Hope this makes sense.

Thanks

Mark

 

 

 

$if{ (:p_type == Consolidation)}$

SELECT
    apaa.PAY_GROUP_LOOKUP_CODE,
    SUM(airtp.GROSS_AMOUNT) as Total_By_Currency,
    airtp.CURRENCY_CODE
    

FROM