Hi, we are facing strange problem where our reporting application is not showing report data if my report query has group by clause. If we export the report to excel, we are able to see proper data in exported file. This behavior we are observing since we moved to SQL2K8 R2 version however reportviewer control in our application is still 2005 version (8.0.0.0). Our application also publishes the report to SSRS and from there we are successfully able to render the report. Only difference is with SQL2K8 move, SSRS version is also 2008. Has anyone faced similar error?

Hi Abhishek-SumT, Thanks for your question, in order to reproduce your issue, could you pleaes give the detail design steps for your report? which is a big help for us to troubleshoot the issue. If possible, could you please give some sample data? Regards, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.