BusinessObjects Board

Date not showing when using Sections.

building reports desktopintelligence
#1

Hi all,

I’m sure many of you have come across this, but didn’t find a good keyword to search on hence this posting.

Lets say you have this dataset:

Date         Item    #sold
10/01/05    Car      1
10/02/05    Car      2
10/03/05    Car      3
10/01/05    Boat     4
10/03/05    Boat     5

Now you attempt to create Section by Items you get this display:


Car
  10/01/05         1
  10/02/05         2
  10/03/05         3
Boat
  10/01/05         4
  10/03/05         5

Problem is that I want 10/02/05 to be displayed under Boat as well something like this:


Boat
  10/01/05         4
  10/02/05
  10/03/05         5

How do I get a null-value displayed for Boat on 10/02/05, even though I know there is no relation between 10/02/05 and Boat in the database records? Any workarounds?

Any input is greatly appreciated.

Thanks,
plexi 8)

pleximax :norway: (BOB member since 2004-08-20)

#2

This is a frequent requirement for a crosstab format but the same technique can be used for your report. This discribes the technique.

Michele Pinti (BOB member since 2002-06-17)

#3

Thanks for your reply, Michele.

…but as Dave points out…

One solution could have been to apply a break, but because we need to put Sum for that section on top of each table, I’m not able to use Breaks.

Any other suggestion greatly appreciated.

Thanks,
plexi 8)

pleximax :norway: (BOB member since 2004-08-20)