April 24, 2012 at 12:29 pm
Hi everyone,
I have a normal distribution chart in my report .That works perfectly fine for any date range but when I try to run it for one full year, it runs empty. what could be the reason?
Thanks for your help !!
April 25, 2012 at 2:36 am
So if I understand correctly you have a date parameter and for example if you select 01-03-2012 - 31-03-2012 the chart displays correctly however if you select 01-01-2011 - 31-12-2011 no data is displayed?
Have you tried running the SQL outside of SSRS with the same parameters and checked the dataset?
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 25, 2012 at 9:36 am
thanks for your reply. I corrected the proc to show the data but now when run for a full year, report throws an error
"Object xxxxxxxxx has been disconnected or does not exist on server. but the report runs fine for smaller time ranges." ?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply