Hi all, I am using SSRS 2008, I am using stored procedure to retrieve my data in that stored procedure i am filtering data on date format i.e fromDate and toDate I am facing a weird issue while i am running my report its working fine with with fromDate '1/3/2011' and toDate '1/4/2011' but i am receiving an error message "An error occurred during local report processing. Cannot read the next row for the dataset dsData " for fromDate 1/3/2011' and toDate '1/6/2011' though there is no data between database for date 5 th and 6th Jan I have tried executing my stored procedure but tht also working fine............. plz help :(

check in the profiler again you might be getting this warning : Warning: Null value is eliminated by an aggregate or other SET operation." it might be the case that you need to apply isnull where you might get null values which might be just an warning in sql server but becomes an error in RS.

Hi vikram, thnx for your rply but i have chked tht its not giving any error !!! i dont give any error.......... :( what i noticed when the data gets duplicated Z361 224.00 154.00 70.00 45.4545 Z362 229.00 157.00 72.00 45.8598 Z363 224.00 154.00 70.00 45.4545 after the last record because first row and last row contains same data except first column it is giving me error !!!!! :( can ne body explain me why this is happening !!!

Hi vikram, thnx for your rply but i have chked tht its not giving any error !!! i dont give any error.......... :( what i noticed when the data gets duplicated Z361 224.00 154.00 70.00 45.4545 Z362 229.00 157.00 72.00 45.8598 Z363 224.00 154.00 70.00 45.4545 after the last record because first row and last row contains same data except first column it is giving me error !!!!! :( can ne body explain me why this is happening !!!

Hi, Which version of Reporting Services you are using? Based on my research, this is a known issue and might be caused by the date type parameter. Please refer to the discussion in the similar threads at: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/e86e614f-de46-48f3-b9a8-fbd1c8102b35/ http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/d1ddc142-1bc6-47d6-b9fe-c7f2f5420011/ Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.