Skip to Content
0

Webi Section or Break

Dec 01, 2016 at 05:14 PM

207

avatar image
Former Member

Hello,

I want to section or break a report on a hierarchy, but I only want the sections to include what they entered on the prompt and not all of its children.

So if they enter rollup1,rollup 4 and leaf.

I want section/break

rollup1

report

rollup 4

report

leaf

report

Nothing else. is this possible?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Jyothirmayee A Dec 01, 2016 at 09:53 PM
1

Hi,

Did you tried creating a variable using Userresponse("Hierarchy Prompt Object name" or "Text of Hierarchy prompt"), Use this variable as a section or break.

Thanks,

Jothi

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 26, 2016 at 09:52 AM
1

Hi,


Please try using the same object in the section as you use for the prompt object

. For eg: Sector name object in the section and in the query filter the same object as prompt


SectionSector Name1BreakLevel 1Level 2Level 3SectionSector Name2BreakLevel 1Level 2Level 3
And if you select the Sector 1 and Sector 2 in the prompt obviously the same values will be filtered out in the section used too.


Regards,

Ramya

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 02, 2016 at 03:29 PM
0

I have not let me try this.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 02, 2016 at 05:59 PM
0

This did not work if users enters more than 1 value.

Share
10 |10000 characters needed characters left characters exceeded
Jyothirmayee A Dec 02, 2016 at 06:43 PM
0

Hi,

UserResponse() is always a delimited string like x;y;z

Try this

=Replace(UserResponse("Hierarchy name");";";Char(13)+Char(10)).

Thanks,

Jothi

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 12, 2016 at 02:31 PM
0

This did not work. It did parse the field, but the data in the report wasn't filtered on how it was parsed.

Share
10 |10000 characters needed characters left characters exceeded