Eclipse Community Forums: BIRT » hiding cross-tab level

Help

Home

Home » Archived » BIRT » hiding cross-tab level

Show: Today's Messages :: Show Polls :: Message Navigator

hiding cross-tab level [message #1384693]

Fri, 30 May 2014 13:15

osuwariboy Mising name

Messages: 24
Registered: December 2010

Junior Member

Hey there, I have a cross-tab with two dimensions: The first are the years and is used for columns and the second is used for the lines and is specified as such:

Employee category --> Age bracket --> Employee

So that's three levels and it works like a charm... but the higher ups went ahead and did what they do best: throw a monkey wrench in the report. They want to be able to give a parameter that would essentially "hide" the employee level.

Now I could create two cross-tabs and essentially show/hide the one I want, but I wanted to know first if there wouldn't be a way to avoid needless duplication by toggling a group-level's visibility programmatically.

Thanks in advancce,

Tobbi

Report message to a moderator

Re: hiding cross-tab level [message #1384743 is a reply to message #1384693]

Sat, 31 May 2014 06:23

Colin Sutton

Messages: 121
Registered: July 2009

Senior Member

osuwariboy Mising name <forums-noreply@xxxxxxxx> wrote:
> Hey there, I have a cross-tab with two dimensions: The first are the
> years and is used for columns and the second is used for the lines and is
> specified as such:
>
> Employee category --> Age bracket --> Employee
>
> So that's three levels and it works like a charm... but the higher ups
> went ahead and did what they do best: throw a monkey wrench in the
> report. They want to be able to give a parameter that would essentially
> "hide" the employee level.
>
> Now I could create two cross-tabs and essentially show/hide the one I
> want, but I wanted to know first if there wouldn't be a way to avoid
> needless duplication by toggling a group-level's visibility programmatically.
>
> Thanks in advancce,
>
> Tobbi
Me too. I have a similar requirement, I'd like to be able to hide the
equivalent of the age bracket in the above example too; it's easy enough to
create multiple cross-tabs from one data-cube, but maybe it would be
possible to add a filter in the cube?
--
Colin

Report message to a moderator

Re: hiding cross-tab level [message #1385198 is a reply to message #1384743]

Wed, 04 June 2014 23:56

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

With open source BIRT, you'd have to have multiple crosstabs and hide/show them based on the user's selection, reload the report to create the crosstab with different dimensions based on the user clicking, or build the functionality into the viewer or your own custom viewer.

With BIRT iHub, you could do something with the interactive crosstab viewer and the JavaScript API, like this:

http://developer.actuate.com/be/documentation/ihub3-dev/AIG-main/index.html#page/aig/JSAPICrosstabs.10.08.html

Michael

Developer Evangelist, Silanis

Report message to a moderator

Previous Topic:	Wrap text in a cell
Next Topic:	How to use month as a parameter?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 15:57:56 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter