Hide column/object in crosstab

building reports desktopintelligence
1

I have a crosstab with center and edition as dimesnsions and there are 2 kinds of measures for them

         edition1   edition2
        -------------------------
center   m1    m2   m1     m2

If there is no data for m2 for edition2 then I do’nt want to display the entire column.
So the report should look like :

         edition1   edition2
         -------------------------
center   m1    m2      m1

How can I do this in crosstab?

Akshay

akshay :india: (BOB member since 2004-02-05)

2

One way to do that would be to create a new variable which concatenates the two measures with a few spaces between them. So there will only be a single column but the way the information is displayed will make it look like two columns…you could include a pipe symbol in the middle of the concat, for example. Set it to align centrally…I’d like to think there is a better way though…

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Hi,
But they are measure objects and I cannot concanate tem because they are numbers and therefore there is data type problem. I did not find and function to convert to number to string.

Akshay

akshay :india: (BOB member since 2004-02-05)

4

Try FormatNumber() to convert a number to a string.

To answer your question, you should look at the report in Structure Mode. (Look on the View menu for this option.) You will see that there are only two columns. Those two columns are replicated for each column header value present in your data. You cannot adjust the format for one header value without affecting the next falue because there is really only one.

Dave Rathbun :us: (BOB member since 2002-06-06)

5

Akshay,
You can use a trick here.

  1. Take another report block for edition 2 having only the column which u know will come in any case
  2. Put this report block just above the existing report block.
  3. Go to the 5th tab ‘Apprearance’ of the report block and
    check Hide(bottom).
  4. Put the condition that if RecordCount = 0 the Hide the Original block or hide the new report block.

Note : You must have Business Object 5.1.8 version for this.

dgoswami :india: (BOB member since 2004-06-30)

6

Be very careful of tricks that require you to move blocks around. While they work well in the client, they do not work well when reports are published to WebI.

Steve Krandel :us: (BOB member since 2002-06-25)