work around for value based break

building reports webintelligence
1

hi,

I have category and sub category to be displayed in the report.
Some categories do not have sub category in that case in the table we have category name itself for sub -category. there is break on category in the cross tab report

---------------------------Q1------------Q2
Category-------------- Amount-------amount
CAtegoryA
-----ABC----------------10000---------50000
-----XYZ----------------20000----------10000
CategoryA Total-------30000----------60000
CategoryB
----CategoryB----------20000---------20000
CategoryB Total--------20000---------20000

In DESKI there is feature called value based break where I can unselect categoryB and break header and footer will not display.

This not possible in WEBI, is there any work around to acheive the below.
report layout.

---------------------------Q1------------Q2
Category-------------- Amount-------amount
CAtegoryA
-----ABC----------------10000---------50000
-----XYZ----------------20000----------10000
CategoryA Total-------30000----------60000
----CategoryB----------20000---------20000

thanks

ThanksForHelp (BOB member since 2006-09-25)

2

Good Day,

Havent tried this workaround coz our server is down. but please do give it a shot. create separate table for each category and add a sum to each table. then after that you can connect each table (lets say category B table below category A table) by using relative position. that way i think you can achive your goal…

Kindly tell me if im missing something.

Regards,

John Vincent

jvmauricio :philippines: (BOB member since 2009-08-03)