how to show or hide group levels on birt cross tab by parameters?

Hi.
I need to modify (show or hide) group levels by some parameter from url, and even more interesting if i can do it on fly.
I can hide the column, but the group information is still showing.
I can't find more information about this.
Is this possible in BIRT?
Thanks

Reinaldo

Find more posts tagged with

Comments

evgeny

I'm not sure if this is what you mean, but to hide columns depending on a parameter you can do the following:
1.Mark the column in your table
2.Go to visibility
3. Check "Hide Element"
4. In the expression go to the function button
5. Type in some expression, like:

if ( row["DATAROW"] != params["Parameter"].value){
true
}
else{
false
}

This will hide your column depending on the condition.

Regards

Evgeny

Rexduran

Thanks but i already try it, this just hide the column, but the program continues bearing it in mind in the query, it means that it continues grouping for this value.
For example:

Company | Department | Chief | product1 | product2 | product3
General | Lux | Goerge | 23 | 1 | 44
General | Lux | Jhon | 4 | 6 | 33

Then in Designer view i click in the right button and select show and hide group level and then i hide the Chief level on this dimension. Then the report must show.

Company | Department | product1 | product2 | product3
General | Lux | 27| 7 | 77

With your suggestion BIRT's showing

Company | Department | product1 | product2 | product3
General | Lux | 23 | 1 | 44
General | Lux | 4 | 6 | 33

I'm trying to do it with scripts, but i don't know what are the methods or events where can do it.
Thanks and regards.

Reinaldo

evgeny

Hi Reinaldo,

not sure this would work, but what if you would do an aggregation on the Department group, this would show you the 27|7|77 you want. Then you hide this Aggregation on the condition that the Chief group is shown and the other way around?
This should work, I think.

Cheers

Evgeny