BusinessObjects Board

Day needs to display when there is no data

building reports desktopintelligence
#1

Hello to All BusinessObjects Professionals,

as i am new to BOB board,

we are using XIR2,our Database is Sql Server
in deski we have a monthly Equity Report

currently Report results as below

here Date is first column and Equity is second column
Date Equity Value
----------- -----------
2/2/2008 12000
2/4/2008 -562333
2/10/2008 -265636
2/13/2008 823774
2/14/2008 -873744
2/17/2008 989333
2/27/2008 -9394994
2/29/2008 23343

can we add all other remain days in the Date column and Equity Value as zero
for example

Date Equity Value----------- -----------
2/1/2008 0
2/2/2008 12000
2/3/2008 0
2/4/2008 -562333
2/5/2008 0
2/6/2008 0
2/7/2008 0
2/8/2008 0
2/9/2008 0
2/10/2008 -265636
2/11/2008 0
2/12/2008 0
2/13/2008 823774
2/14/2008 -873744

2/29/2008 23343

any way to do this
actually i worked on it, but i need some help

Thanks for your participation
chinni

anandi (BOB member since 2007-08-01)

#2

Welcome to B:bob:B!

Please have a look at this Reporter’s FAQ:

The Reportes’s FAQ is a sticky topic in the BusinessObjects Classic forum.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#3

You can do it with another dataprovider that forces it open. It needs to be the cartesian product of everything that you are grouping and pivoting on. If you can get it created inside a derived table it won’t give a warning otherwise you have to acknowledge that it is a cartesian product everytime you refresh.

BDeLong (BOB member since 2008-01-15)