All values of filter "In List"

[system]

Hi guys,

I have report like this:

[DIM1]
[Metric1]

I’m putting in DIM1 a report filter: DIM1 in list (1,2,3,4,5)
The data retreived from database only bring [metric1] for 1,2.
I’d like to put value 0 in metric1 for the ones which doesn’t come from database. So in this case the result will look like:

1 | 2 | 3 | 4 | 5
2 | 7 | 0 | 0 | 0

Any suggestion would be very appreciated.
Thanks in advance.
A.S.

---

as2010 (BOB member since 2012-01-30)

[system]

Hi,

Check this Reporter’s FAQ. That should help you:

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]

SO you mean, I need to bring [DIM1] with no filters ( in another query)
And then put Metrics below.
BO will by itself join the values [DIM1] for two Queries.
Then i use a formula like If(IsNull([Metric1]; 0; [Metric1])

Thanks for your help.
A.S.

---

as2010 (BOB member since 2012-01-30)