Problem to hide conditional column in Crosstab

[lorenmario]

Hello,

I am creating a report using a relational package, SQL database, I'm using Report Studio 10.2.1.

I have used a boolean variable to conditionally hide a crosstab column nested.

The problem i'm facing is when i set the box type as "none" for the hidden column , the crosstab's columns cells are getting misaligned with the column headers. Is this a bug with BoxType property ?
Is is there any other way that we can conditionally hide the columns via a prompt without using the "box type" property?

To make it easier to understand the problem, appends an image of the crosstab, with the conditional variable set to yes, and an image of the conditional variable set to no.

Appreciate your response!!!

[satishsure]

I am also facing same kind of issue.If you know any anwer ..please do reply here..Thank you

[BigChris]

Not a direct answer to your question, but it might give you a fix for now. Couldn't you create two versions of your crosstabs, one with the column and one without? Then render the crosstabs based on your boolean variable.

[TheFrenchGuy]

Hello all,

the other way is to bring the data item you want to hide out, and apply your variable to this.

so you will have 3 columns :

Code Select Expand

<Statuts>                     <Status>                                <Growth>
<Count>                   <Unidades>  <Net Sales>      <%Units>  <%Net sales>

Don't forget to apply the style variable on your measure too.

[Virgin]

BigChris has the best solution, copy your crosstab actual on the same page, now you have 2 crosstab, one with the column and the 2nd without the column, now you use your booleen variable to appear one crosstab in one case and the other crosstab in other case.

[BigChris]

BigChris has the best solution

8) that doesn't happen very often!

[TheFrenchGuy]

 :'(

ps : to render a crosstab you have to put it in a block.

[Robl]

Select the column you don't want to show.
Set the border as none, the padding as 0pts on the left and right.
Unlock the report, select the text item in the column and set it to box type none.

The column is still there - it's just not visible any more.

Unless you export it to excel.

[Arhinoa]

Select the column you don't want to show.
Set the border as none, the padding as 0pts on the left and right.
Unlock the report, select the text item in the column and set it to box type none.

The column is still there - it's just not visible any more.

Unless you export it to excel.

Hello,

I'm facing the same issue when trying to hide imbricated measures columns, and I don't know how to implement the solution shown above.
My Crosstab looks like this:
             A          B
      Qty Cost   Qty Cost
Row1
Row2
Row3

Result after hiding Cost Measure (conditional style BoxType None for header and fact cell) :

             A          B
      Qty Qty
Row1
Row2
Row3

Concerning the column header, there's no problem to hide it.
It's for the measure, how can I select only  the measure concerned by the header and hide it.

I'm aware that this question has been treated a year ago but I would appreciate a little help :) Thanks
Arhinoa

[adam_mc]

If you are forced to do it that way, set up the crosstab like:

               A    A        B     B
             Qty Cost   Qty Cost
Row1
Row2
Row3

Then do a box type None on BOTH the Column Header A/B (above cost) and the Cost Measure itselt.

That way when it slides, everything should align.

Hope that helps,
Adam.

[Arhinoa]

If you are forced to do it that way, set up the crosstab like:

               A    A        B     B
             Qty Cost   Qty Cost
Row1
Row2
Row3

Then do a box type None on BOTH the Column Header A/B (above cost) and the Cost Measure itselt.

That way when it slides, everything should align.

Hope that helps,
Adam.

Thank you for your answer adam_mc, it would have been the best workaround if I had only one cost column. But I have 4 types of cost, and users can choose to show the 4 columns at the same time. It will show the header (A or B) 4 times  :-[

I finally found a way to hide my columns without misaligning column headers.
I modified my crosstab so as to have void text instead of Data Item Label (for headers) / Cell value for columns that have to be hidden.
I created boolean variables (instead of conditional styles) and associated them as Style variable AND text source variable for each crosstab member and crosstab intersection to hide.
When my boolean variable = Yes, I show my column as Data Item Label (for headers) / Cell value for columns to hide
when my boolean variable = No, I put Border = None and Padding = 0px.

It really took long time to implement but it works.
I hope it will help someone, someday :)