Column Display

[system]

I need to create a report even if the value does not exist in the reporting period.
I have a query which has filter : Type in (a,b,c)
But in user entered reporting period, some times one of the value does not exist. But still i want to display “c” in the column based on below example. And if there is no data, i would like to display Zero under C (Based on below example)

I have a horizontal table

Type      a    b    c
Count    10  2

Help please

---

nammu (BOB member since 2011-12-02)

[system]

Hi,

Please have a look at this Reporter FAQ, it will get you started:

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]

Hi nammu

select block and go to properties …check show rows/columns when empty and then use the formula like

=if isnull(count(Type)) then 0

---

sunil kumar (BOB member since 2011-10-03)

[system]

Hi Nammu,

Check the below post:

Display Ranges in barchart

Hi All, Error Range: =If(x<-1;"-100%"; If(x>-1 And x]<= -0.7;"-100% to -70%"; If(x>-0.7 And x]<= -0.5;"-70% to -50%"; If(x>-0.5 And x]<= -0.2;"-50% to -20%"; If(x>-0.2 And x]<= 0.2;"-100% to -70%"; If(x>0.2 And x<= 0.5;“20% to 50%”; If(x>0.5 And x]<= 0.7;“50% to 70%”; If(x>0.7 And x<=1;“70% to 100%”; If(x>1;">100%"))))))))) Count of records: =Count(y;All) When i was turning into barchart,its displaying those who has the values in the bar chart. Remaining ranges are not coming into …

Sunil - I am not sure if simply checking the block and properties --> check show rows/ columns would work.

---

praveenmaddi (BOB member since 2011-05-10)

[system]

Thanks. I need to use Formula and Check those boxes to show all the values.

---

nammu (BOB member since 2011-12-02)