2006 IR Open Dicussion Posted August 26, 2006 Share Posted August 26, 2006 By: LeeBar - leebar Crosstab hide certain columns 2006-01-18 14:34 Hi Is it possible to hide certain columns in a crosstab (as in PrintWhenExpression)? In my case my dataset contains machines that can either be turned on or off (with boolean isPowered field). I use the isPowered field ad bucket expression, and a crosstab with two columns, one with counts for the "on" machines and one with the counts for the "off" machines. I only need to display the "on" machines column and would like to hide the "off" column - is there a way to achieve that? Thanks a lot! Lee By: Lucian Chirita - lucianc RE: Crosstab hide certain columns 2006-01-19 00:49 Hi Hiding crosstab rows/columns is not yet supported. I don't think I fully understood your scenario, but maybe you can try not using isPowered as bucket expression and for the count measure use as expression something like $F{isPowered}.equals(ON) ? "count me" : null Also, do you have a crosstab with only two columns (or only one, since you want to hide one of them)? You can design such a report without using crosstabs. Regards, Lucian By: LeeBar - leebar RE: Crosstab hide certain columns 2006-01-19 13:04 I think that should work - that's what I will do: create a bucket expression that is always true and therefore only shows one column and change the measure expression to only count the ON power entries. thank you so much for the tip! I think I still need a crosstab, since I have a Row-bucket expression that can result in any amount of rows: e.g. For each owner of machines stored in a lot I want to display the amount of his machines that are plugged in (and I just don't care about the ones that are not plugged in)... Lee Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now