Prev: getting sql report 2005 web service to work
Next: Multiple rendering after one action
From: obiron via SQLMonster.com on 28 Jan 2010 11:32
hi guys,

using SQL2005 and SSRS2005.
I have an aggregated chart that has volume on the X axis and weeks on the Y
axis. I also want to produce in the same report some supporting charts for
the unaggregated data, however if there is no activity for a particular
business unit for a particular week then that data point is dropped from the
chart which means you cannot compare charts easily as the weeks do not line
up. I don't really want to go back to the data source to force null data
points as the data source is also used for other things.

does anyone know if it possible to force these missing data points into the
chart.

for reference the chart is currently a line chart, but this may change to a
bar chart or even a stacked bar chart.

Obiron

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/201001/1

 | 
Pages: 1
Prev: getting sql report 2005 web service to work
Next: Multiple rendering after one action