select distinct CLASS_ID || '-' || CLASS_DESCR clsfrom S_DEPT_CLASS_SUBCLASwhere (least(:P_DEPT) is null or DEPARTMENT_ID || '-' || DEPT_NAME in (:P_DEPT))and BUSINESS_UNIT_ID = (:P_BU)ORDER BY TO_NUMBER(regexp_substr(CLS,'^[0-9]+')),LOWER(CLS) Is this a LOV or a Data Set query? In the first case the error could occure…

Take a look at http://www.jfree.org/jfreechart/ The default xml-charts are not that great

Ivalid Parameters occure when you refer to other parameters which are null inside of another LOV. Add NVLs or rework your parameter "hierachy"

I don't think that's what's planned for BI Publisher. But you can achieve this but "merging" your two data modells into a single one. Then you can gerenate your two reports as sub templates and a report which data source is the new data modell can call these sub templates conditionally

As Venkat already said... better use a rtf template because you can achieve much more with it

<?import:xdoxsl:////Components/Subtemplates/Subtemplate.xsb?> You've a slash too many It should be: <?import:xdoxsl:///Components/Subtemplates/Subtemplate.xsb?>

Do you recieve any error or is the output not like you've expected? Without that info it'll be hard to help you... But I'll take a guess to speed things up... Even if your code won't lead to a error the output should be something like 12345 12 345 when amount1 would be 12345. You've got two different and separate…

There are two different ways... ​Do it in the data model (more efficent ): <span class="kwd">select</span><span class="pln"> listagg</span><span class="pun">(</span>element<span class="pun">,</span><span class="str">', '</span><span class="pun">)</span><span class="pln"> </span><span class="kwd">within</span><span…

You should do that in the data model. Just use NVL in your query. It'll perform much quicker than it does inside the template.

Declare the format at the very start of your template: <xsl:decimal-format xdofo:ctx="begin" name="NL" decimal-separator="," grouping-separator="."/> Show the formatted number: <?format-number(NUM_COLUMN,'#.###.###.##0','NL')?>