BI Publisher - help

2742936

Hello,

I'm stuck in one of the issue in BI publisher. Actually its not an issue, but trying to find solution not sure its possible or not, hence posting here for your inputs.

I have a BI publisher report (xls template) which generates report in xls. Users have option to run it for level 1 and level 2. There is one section in the report where I need minor layout changes for level 1.

For eg: when you run the report for level 2 then you see below results in one of the section.

Section 2.9

  

Description	Sale ($m)	movement
2.9.1 Sales figures counter party1	100	5
2.9.2 Sales figures counter party2	150	15
2.9.3 Sales figures counter party3	120	10
Total	370	30

2.9.1 Sales figures   counter party1

When you run the report for level 1, rest of the report sections are fine but users need a small change in the above section 2.9. They dont want to see row 2 related to counter party 2 as its always null for level 1. so they want to get rid off it. Description column is in template, only sales and movement figures comes from sql query.

One option I thought of was to split the report into 2, one template each for level1 and level 2 with row 2 deleted in template for level 1. However from maintenance perspective they didn't like this option. Also, just to get rid off one row for level 1 I thought its not a good option too.

So I'm looking for some inputs from experts here. Appreciate if anyone can throw your thoughts on this.

Thomas Dodds

Perhaps the following is what you might need:

XDO_SKIPROW_?Company_Name_ID12? <xsl:if test="string-length(Company_Name_ID12) = 0">TRUE</xsl:if>

2742936

Thanks Thomas, it works well.