system
January 31, 2013, 4:11pm
#1
Hi,
I have a query which returns all events within the last 8 weeks. This data is displayed on a bar chart. If one week has no records it is automatically not shown on the chart. Is there anyway of showing this week and having the data value show as 0. Basically, I always want to see 8 weeks on the chart.
Regards
Chris
chris_nunn (BOB member since 2013-01-11)
system
January 31, 2013, 4:21pm
#2
You can try creating a report variable that will display a “0” if the record has no data. Similar to this:
=If(IsNull([Object])) Then "0" Else [Object]
Use this variable for the graph.
mwinchel (BOB member since 2011-12-13)
system
January 31, 2013, 4:42pm
#3
Hi,
Check also this Reporter’s FAQ:
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)