How to display columns with null values in deski6.5 crosstab

[system]

Hi,
I have a requirement to display column with null values in crosstab. I tried creating a left outer join in the universe and i m getting all the columns. But i m getting a extra row down with value 0 for all the columns with no values. I dont want that extra row. Please help me out with this issue.

---

Steffi (BOB member since 2011-11-27)

[system]

Welcome to B:bob:B!

Try this technique if it helps:

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)