I have developed a report, that is group by Practice/Clinic. Under this group I have added a bar chart that displays total patient count for a Provider/Doctor. I have added DynamicHeight property of the chart to (1 + (CountDistinct(Fields!ProviderUid.Value)/3)) & " in" so that it can scale up depending upon the number of providers in that practice. All works fine If I run the report for a single Practice. When I run the same report for multiple practices, the report viewer adjust the height of the chart properly depending upon number of provider for each group of practice, but when I try to export the report to PDF the problem starts. The height of the chart is same in all the group irrespective of the number of providers in that group, the size of the chart is decided by the number of providers in first group. I am using Visual Studio 2010 to develop and execute the report for now. SKR

Hi SKR, It is a known issue, and was first fixed in Cumulative Update(CU) 8 SQL Server 2008 SP1. I would suggest you applying the latest hotfix for SQL Server 2008 to solve the issue. The latest hotfix for SQL Server 2008 is SP2, it is available in: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8fbfc1de-d25e-4790-88b5-7dda1f1d4e17 For more information about this issue, please see: http://support.microsoft.com/kb/981928/ If you have any more questions, please feel free to ask. Thanks, Jin Chen Jin Chen - MSFT

Hi Jin Chen, I am displaying only one Range Bar (GANTT) Chart in my report with DynamicHeight property set accordingly. It is rendered properly, but when I export to PDF, half of the total pages are coming as Blank pages. Suppose the exported PDF document has 12 pages, the last 6 pages are blank pages. Chart height is properly scaling up as per the expression, but generating many blank pages after chart in the exported PDF document. Please let me know if the above mentioned hot fix addressed this issue as well. I am using SSRS 2008 (SQL Server 2008) and using Visual Studio 2008 for developing the reports. Thanks & Regards, Swamy

Jin, I am not using Report Server to generate reports, I am using a Win Form Report Viewer to generate and export the report, I am not sure where do I install SQL Server 2008 SP2, I dont even have SQL server 2008 installed on my machine. SKR

Hi Swamy, For the blank page issue, it is due to page size setting. Please see the following article for more information about this issue: http://blogs.msdn.com/b/chrisbal/archive/2006/08/10/694892.aspx http://dataerror.blogspot.com/2008/12/extra-blank-page-when-save-to-pdf-from.html Thanks, Jin ChenJin Chen - MSFT

Hi SKR, It seems you are using ReportViewer with local processing mode. If so, please try to up the ReportViewer to date to check if the issue is solved. The hotfix I mentioned is used to fix the similar issue that occurs in the SQL Server Reporting Services report server. If you are using Report Viewer 2010, it seems this known issue hasn't been fixed. I would suggest you submitting a feedback at https://connect.microsoft.com/sql Appreciate your understanding. Thanks, Jin ChenJin Chen - MSFT