Hard coded null values

[system]

Hi All,

I have column called STATUS

Status column as two values “Open” and “Done” . Like below

STATUS

Open
Done

I did section on Status column but i dont any data for Open because of that i dont see that Open in the report but my end used what to see Open with 0 values.

How i can i hard coded .

Using Deski 3.1.

Thank you all,
Rav.

---

ravek (BOB member since 2006-08-03)

[system]

Hi,

Check this Reporter’s FAQ, it can help:

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…

The idea is that you create another query / data provider that brings all possible values of a dimension, link/merge it to the main query and use it in a table.

---

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