Get the value of a section header

building reports webintelligence
1

Hello,

I have a report with sections like:


section 1
-----------
table

Total Section 1: xxx

section 2
----------
table

Total Section 2: xxx
.
.
.

section X
----------
table

Total Section X: xxx

I want the “Total section label” to be Concatenation("total " , [value of section header]).

How did I get this [value of section header] ?

The problem is that I am using drill-down when clicking on section header

I did not find the expression to do that.

Thanks in advance

jlinho (BOB member since 2009-05-12)

2

Hi,
Do you want to create a variable that shows the section header label. Is it that want you wanted then

Total Section Label= "Total" + [Object]

Here object would be that on which section is created

For example:
We have a section on Fund and also section total on it. So, we created this variables


Fund Label= [Fund]+ " - "+[Fund Name]
Fund Total Label= "Total for Fund "+[Fund Label]

Try this and let us know if it worked.

GNK_BO (BOB member since 2007-07-17)

3

I had already tried that but the problem is when I drill down, the “Dimension” of the section changes, but not the variable…

I want to know if there is a way to point to the “section object” and not directly to a dimension variable…

IF there is not , I will have to go with an ugly combination of DrillFilters…

Thanks

jlinho (BOB member since 2009-05-12)

4

There is no elegant way to do this. I’ve played with it for a while, and have found nothing. :cry:

MichaelWelter :vatican_city: (BOB member since 2002-08-08)