PROBLEM: Report column is spilling over to another page

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,
Cory KoskiClick 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,
> Cory Koski|||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?
"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,
> >
> > Cory Koski