August 23, 2012 at 8:43 pm
I have a SSRS report . I need to implement the logic below ..
When the daily inventory does not have data for a day the inventory line should break and not drop to zero and then back up. Instead of dropping to a zero it needs to simply show a blank space in the line when data is not available.
Is this possible in SSRS 2008 ?
Thanks,
PSB
August 28, 2012 at 4:04 am
Its fairly easy in SSRS 2008 R2.
You can set the X axis as a date range and get it to display all dates regardless of any data.
BUT...in SSRS 2008 its messy I'm afraid.
I had the same problem when showing weekend dates when no data existed - so the graph at least looked sensible.
In the past Ive simply had to do a left join on the dataset with either a function (that simply lists all dates in a range) or static table (set by parameters maybe?).
You'd then get a dataset with dates where the actual data is null.
its not clean but its the easiest way to achieve what you want in SSRS 2008.
I can look out the function I created for it if you want, but a quick google will likely find you something similar - wont be that hard to piece together
Hope that helps
Ta
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply