Null Value also needed in Column

[system]

Hi All,

I have a WEBI BOXI V3 Crosstab report which contains period as column
…Jan09…Feb09…Apr09…Jun09
Object1…1000…1000…2000…1500
Object2…1000…1000…2000…1500

Requirement is like below:
…Jan09…Feb09…Mar09…Apr09…May09…Jun09
Object1…1000…1000…0000…2000…0000…1500
Object2…1000…1000…0000…2000…0000…1500

All the Periods needs to be displayed if there is no value also. Can anyone please help me on this.

---

SivakumarS (BOB member since 2006-08-10)

[system]

Read about this, on Daves blog, here:-

http://www.dagira.com/2009/11/09/making-up-data-part-i-personal-data-providers/2/

---

Mak 1 (BOB member since 2005-01-06)

[system]

And also this Reporter’s FAQ describes the same:

FAQ: Reporter

How can I include data for all months in a crosstab, even if a particular month has no data? One way to do this is to create a second data provider using only the months. Then link (or “merge”) the second data provider (query) with the first data provider. Use the month column from the second data provider in the cross tab. This should bring in all months even if there were no data for that month. However this technique does not work if you have sections in your report. Dave Rathb…

---

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

[system]

This is great. Thanks!!

---

SivakumarS (BOB member since 2006-08-10)