Hide column in CrossTab

Hi and thank you for reading,

I am working on improving the interactivity of a report. In a CrossTab I would like to hide one of several column while running a report, with the help of a JavaScript function. However the columns of a CrossTab don't have a Bookmark possibility. Is it still possible to hide a column on the fly and have the values as if the column would not be there. I would also like to implement a functionality, where I can hide just the subcolumn of a column. Say I have a list of Countries and I would like to hide the column which lists the Cities in the US.

Thank you for your help

Evgeny

Find more posts tagged with

Comments

mwilliams

Hi Evgeny,

Can you set up a similar report to what you're looking for with the sample database? Then explain off of it what you'd like to see? Thanks.

evgeny

Hi mwilliams,

thank you for your reply.

I'm am attaching a sample report. You will find a crosstab with the Groups "STATE" and "year". I would like to have a possibility to hide the Group year, so that the crosstab would look like the group wouldn't be there at all. I would like to realize this without using several crosstabs or reports, that means by using some javascript to hide the column and unhide it when a button is clicked.
More important I would like to hide the year sub groups of just one STATE group. e.g. the state is CA and i would click the button and the years of CA would not show, instead the line would show the results for the CA state. However all other states would still show the year group.

Basically I would like to have an expand/collapse function on the sub-groups by unhiding/hiding the sub groups. Do you see a way to realize this?

Thank you for your support

Evgeny

mwilliams

Evgeny,<br />
<br />
I don't know of a way that this would be possible. Any change in a report element would require that the report be rerun to show it, so creating multiple crosstabs in one report and dropping them based on the user's preference would be the easiest as far as the levels of grouping. As for expanding and collapsing individual states/groups in a crosstab, I can't think of a way to achieve this off the top of my head. In a single crosstab, the results of one line can't have different grouping than another line, I don't believe.<br />
<br />
You may try requesting an enhancement of a feature like this by going to <a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/reportabug.php'>BIRT: Reporting Bugs and Requesting Enhancements</a> and putting in the request and seeing what they say.