Report issue

  • 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 !!

  • 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

  • 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