BusinessObjects Board

Reporting issue

building reports desktopintelligence
#1

Hi ALL,

The issue is to produce NO SALES report.

That is for example:

let us consider years :2001,2002,2003

Let us consider products a,b,c,d

in datawarehouse the data is loaded like this:

product a for 2001,2002,2003

product b for 2002,2003.

product c for 2001,2002,2003.

product d for 2003.

Now i am putting this products as section.
so for product a data will be displayed for 2001,2002,2003.

for product b data will be displayed for 2002,2003.

for prodcuct c data will be displayed for 2003.

But in report i want to display for all years for all products…

that is for product b data will be displayed for 2002,2003 and for 2001 atleast blank should be displayed.

like that for product c data will be displayed for 2003 but for 2001 and 2002 atleast blank should be displayed…

why is this because we are saving this in excel format and there we get alignment problem…so to avoid that if data is not loaded for a product for particular year atleast blank should be displayed…

can anyone please Suggest a solution…

Thanks and Regards,

Rajesh.

rajesh9999 (BOB member since 2006-04-18)

#2

this has been discussed in many threads here…start with reporter faq!!

Mahi (BOB member since 2004-07-22)

#3

Hi Rajesh,

Welcome to B :mrgreen: B.

Check these links it might be helpful.

You can create additional dataprovider using text/excel file which contains all the years and then link this dataprovider.

Raja Saripalli :us: (BOB member since 2005-12-14)

#4

Just put a decode statement with where it is null
This would help you get the excell alignment fixed whcih i believe is your first and foremost problem

ripumakar :india: (BOB member since 2005-09-15)