sql server reporting services:
Hi all, I'm trying to resolve a problem with my report. I am using a Table element, and I'm using fixed width columns. When I preview the report in my development environment, I get a normal looking report... 4 pages with all the proper headers and columns in their correct locations. When I run the report through my ASP.NET application and stream the rendered PDF through my web application, the report rendering is wrong. On the 1st page, where the final column on the right should be visible on the first page, spills onto a 2nd page, where it's all by itself. The 3rd page of the report shows all of the columns, but no header, and then the 4th and 5th pages resemble the 1st and 2nd page, and the 6th and 7th pages render like the 1st and 2nd pages. I have tried to reasonably squish the columns, to no avail, and the only way I could have all the columns show on one page would be to squish the first column very small so it's unusable. My report is 8" wide, and I have 0.25" margins on the left and right hand sides. My main table is 8" wide, and when I make it smaller, there's no change... I still get the problem. I have tried everything I can think of to try to make this work, but I am now officially stumped. I am using SQL Server 2000 Reporting Services. Can anyone help? Any thoughts? Here's the code I use to render the report: Private Function GetReport(ByVal strReportPath As String, ByVal strReportFormat As String, ByVal parameters As ParameterValue()) Dim data As Byte() rs = New ReportingService rs.Credentials = System.Net.CredentialCache.DefaultCredentials rs.Url = Convert.ToString(System.Configuration.ConfigurationSettings.AppSettings.Item("payerdirectories.ReportingServicesWS.ReportingService")) ' create parameters Dim encoding As String Dim mimeType As String Dim parametersUsed As ParameterValue() Dim warnings As Warning() Dim streamIDs As String() data = rs.Render(strReportPath, strReportFormat, Nothing, Nothing, parameters, Nothing, Nothing, encoding, mimeType, parametersUsed, warnings, streamIDs) Return data End Function I can upload my report design XML if need be. Thanks in advance,
Click on the page, Go into properties, size and make sure that it is less than 8 (8.5 - .25+.25), I think what happend is this, when you were making your report, at some point the page width became large than 8, although you squished everything back to your requirement of 8, this setting did not adjust. Unless you manually reset this it wont fix itself [quoted text, click to view] "Cory Koski" wrote: > Hi all, > > I'm trying to resolve a problem with my report. I am using a Table element, > and I'm using fixed width columns. When I preview the report in my > development environment, I get a normal looking report... 4 pages with all > the proper headers and columns in their correct locations. When I run the > report through my ASP.NET application and stream the rendered PDF through my > web application, the report rendering is wrong. On the 1st page, where the > final column on the right should be visible on the first page, spills onto a > 2nd page, where it's all by itself. The 3rd page of the report shows all of > the columns, but no header, and then the 4th and 5th pages resemble the 1st > and 2nd page, and the 6th and 7th pages render like the 1st and 2nd pages. > > I have tried to reasonably squish the columns, to no avail, and the only way > I could have all the columns show on one page would be to squish the first > column very small so it's unusable. My report is 8" wide, and I have 0.25" > margins on the left and right hand sides. My main table is 8" wide, and when > I make it smaller, there's no change... I still get the problem. I have > tried everything I can think of to try to make this work, but I am now > officially stumped. > > I am using SQL Server 2000 Reporting Services. > > Can anyone help? Any thoughts? > > Here's the code I use to render the report: > > Private Function GetReport(ByVal strReportPath As String, ByVal > strReportFormat As String, ByVal parameters As ParameterValue()) > > Dim data As Byte() > > rs = New ReportingService > rs.Credentials = System.Net.CredentialCache.DefaultCredentials > rs.Url = > Convert.ToString(System.Configuration.ConfigurationSettings.AppSettings.Item("payerdirectories.ReportingServicesWS.ReportingService")) > > ' create parameters > Dim encoding As String > Dim mimeType As String > Dim parametersUsed As ParameterValue() > Dim warnings As Warning() > Dim streamIDs As String() > > data = rs.Render(strReportPath, strReportFormat, Nothing, Nothing, > parameters, Nothing, Nothing, encoding, mimeType, parametersUsed, warnings, > streamIDs) > > Return data > > End Function > > I can upload my report design XML if need be. > > Thanks in advance, >
Ok this is strange. I did as you suggested, and no go. But I did notice something interesting that I'm not sure that was there before, but I'm betting it was. The Page Header and Footer are cut off on the right-hand side, so the text that I have there is not displaying completely. Is there some setting in the device settings for the renderer to tell it to use the entire 8.5" width instead of the default? What should I do to check? I'm in Canada, so is it possible that the server I am testing this report on is rendering it to A4 instead of Letter by accident? Any suggestions? [quoted text, click to view] "Seidel1" wrote: > Click on the page, Go into properties, size and make sure that it is less > than 8 (8.5 - .25+.25), I think what happend is this, when you were making > your report, at some point the page width became large than 8, although you > squished everything back to your requirement of 8, this setting did not > adjust. Unless you manually reset this it wont fix itself > > "Cory Koski" wrote: > > > Hi all, > > > > I'm trying to resolve a problem with my report. I am using a Table element, > > and I'm using fixed width columns. When I preview the report in my > > development environment, I get a normal looking report... 4 pages with all > > the proper headers and columns in their correct locations. When I run the > > report through my ASP.NET application and stream the rendered PDF through my > > web application, the report rendering is wrong. On the 1st page, where the > > final column on the right should be visible on the first page, spills onto a > > 2nd page, where it's all by itself. The 3rd page of the report shows all of > > the columns, but no header, and then the 4th and 5th pages resemble the 1st > > and 2nd page, and the 6th and 7th pages render like the 1st and 2nd pages. > > > > I have tried to reasonably squish the columns, to no avail, and the only way > > I could have all the columns show on one page would be to squish the first > > column very small so it's unusable. My report is 8" wide, and I have 0.25" > > margins on the left and right hand sides. My main table is 8" wide, and when > > I make it smaller, there's no change... I still get the problem. I have > > tried everything I can think of to try to make this work, but I am now > > officially stumped. > > > > I am using SQL Server 2000 Reporting Services. > > > > Can anyone help? Any thoughts? > > > > Here's the code I use to render the report: > > > > Private Function GetReport(ByVal strReportPath As String, ByVal > > strReportFormat As String, ByVal parameters As ParameterValue()) > > > > Dim data As Byte() > > > > rs = New ReportingService > > rs.Credentials = System.Net.CredentialCache.DefaultCredentials > > rs.Url = > > Convert.ToString(System.Configuration.ConfigurationSettings.AppSettings.Item("payerdirectories.ReportingServicesWS.ReportingService")) > > > > ' create parameters > > Dim encoding As String > > Dim mimeType As String > > Dim parametersUsed As ParameterValue() > > Dim warnings As Warning() > > Dim streamIDs As String() > > > > data = rs.Render(strReportPath, strReportFormat, Nothing, Nothing, > > parameters, Nothing, Nothing, encoding, mimeType, parametersUsed, warnings, > > streamIDs) > > > > Return data > > > > End Function > > > > I can upload my report design XML if need be. > > > > Thanks in advance, > >
Don't see what you're looking for? Try a search.
|