MS SQL Server Reporting Services - Multiple pages problem -

Author

Multiple pages problem -

sillygiu

2005-08-05, 8:24 pm

The bug fix No.883647 - you render a report to a PDF file, the page breaks
are incorrect in SQL Server 2000 Reporting Services. - Didn't help me. I
still have page breaks problem after I install SP2 and hotfix. I have include
a subreport (with table on it), it has proper page break if table returns
less rows and be able to fit in the same page. If the subreport tabe return
more rows, sometimes it displays across pages (which is correct), but
sometimes it just displays the return rows on to next page and leave blank
spaces on the previous page.
Please help. I do need the fix to decide to go with MS Sql Server Reporting
Services or Crystal reports

Kevin S

2005-08-08, 8:24 pm

Great. I have the same problem, a header row in my table, two columns only.
1st column is the label, 2nd column is the data. If the data gets lengthy,
RS wants to shove it to the top of the next page instead of filling the
available space on the current page. I'm currently downloading the SP2 in
hopes it would fix it. I'm sorry to hear it doesn't fix our problem.

"sillygiu" wrote:

> The bug fix No.883647 - you render a report to a PDF file, the page breaks
> are incorrect in SQL Server 2000 Reporting Services. - Didn't help me. I
> still have page breaks problem after I install SP2 and hotfix. I have include
> a subreport (with table on it), it has proper page break if table returns
> less rows and be able to fit in the same page. If the subreport tabe return
> more rows, sometimes it displays across pages (which is correct), but
> sometimes it just displays the return rows on to next page and leave blank
> spaces on the previous page.
> Please help. I do need the fix to decide to go with MS Sql Server Reporting
> Services or Crystal reports
>

Carl99

2005-10-27, 7:57 am

I also have this problem - looks fine in html but when rendered to a pdf I
have white space and page break when page not filled.

My setup is a table on the main report and each row containing a subreport -
7 rows/subreports. The first three have none or a few rows and the fourth
almost lots of rows. When a subreport dont have data I hide that row in the
main table. The result is data (sub1-3) on top of page 1 and then white space
down and then a page break and lots of data (sub4) on page 2. The result I
want is that the data (sub4) on page 2 starts on page 1 and then continuing
on page 2 if there no room on page 1. Could this be soled in some way???

BR //Peter

"Kevin S" wrote:
[color=darkred]
> Great. I have the same problem, a header row in my table, two columns only.
> 1st column is the label, 2nd column is the data. If the data gets lengthy,
> RS wants to shove it to the top of the next page instead of filling the
> available space on the current page. I'm currently downloading the SP2 in
> hopes it would fix it. I'm sorry to hear it doesn't fix our problem.
>
> "sillygiu" wrote:
>

eyalsaRSX

2005-10-30, 7:24 am

Carl99 wrote:[color=darkred
]
> I also have this problem - looks fine in html but when rendered to a pdf I
> have white space and page break when page not filled.
>
> My setup is a table on the main report and each row containing a subreport -
> 7 rows/subreports. The first three have none or a few rows and the fourth
> almost lots of rows. When a subreport dont have data I hide that row in the
> main table. The result is data (sub1-3) on top of page 1 and then white space
> down and then a page break and lots of data (sub4) on page 2. The result I
> want is that the data (sub4) on page 2 starts on page 1 and then continuing
> on page 2 if there no room on page 1. Could this be soled in some way???
>
> BR //Peter
>
> "Kevin S" wrote:
>

Sponsored Links