BusinessObjects Board

Displaying future quarters in chart

Hi,

I have a report like to show quarter wise orders placed in a chart .

Currently we are having data for the first two quarters only (i.e 2010).

So the chart shows me like Q1,Q2 and the corresponding orders placed in the chart.I need to show Q3 and Q4 also in the chart and show it as 0.
But there are no date values for future analysis.How to show all the quarters of this year and the corresponding orders in the chart.
The chart is a simple bar chart.

Q1- 100
Q2- 200
Q3 - 0
Q4 -0

To be shown in chart.


ajitha :india: (BOB member since 2008-07-28)

Hi,

This reporter’s FAQ describes pretty much the same, instead of your quarters, months are described in FAQ:


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

Thanks,One more question i need to show it for future years too,will it work for it too.Say like for years after 2010,i.e 2011 and so on.


ajitha :india: (BOB member since 2008-07-28)

If you have a date calendar where these future months/quarters/years are available then I see no problem.


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

I dont have.This is like future analysis report.I need to show the chart begining from this year and later years say up to 2014 to be shown as 0.


ajitha :india: (BOB member since 2008-07-28)

Do you have access to the universe?


jemstar :ireland: (BOB member since 2006-03-30)

Then create one. Should not be that difficult. And it will be useful not only for this one particular report.


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

I dont have access to the universe.


ajitha :india: (BOB member since 2008-07-28)