Report Statements

Question

Report Statements

brunm

SSCommitted

Points: 1792
More actions
October 30, 2007 at 9:47 am

#183487

I have a report that is basically a statement (invoice) The report has a list which is based on the main dataset. Each list item has a subreport which contains the items for the statement.
i am trying to get each statement to start on a new page. When one of my statements runs over one page (which can happen), it starts the next statement on the same page.
i have ticked the option 'insert a page break after list' and tried playing around with the page size settings but to no avail.
i have used lists which do not have a subreport on them and they work fine
Does anyone know how i can achieve this, the page break after list option obviously does not work correctly.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

robin-533029 SSC Enthusiast Points: 135 More actions · Answer 1

Your problem is basically the same as mine 'controlling page breaks' posted earlier yesterday. I have also tried using 'lists' and 'rectangles' which as you say have options for page breaks before or after, however it seems to me that if you include list/rectangle within a group then only the group page break works.

I find it difficult to believe it is not possible (cf Crystal where you can insert page breaks virtually anywhere) so I am trying to find someone who knows how to do it.

brunm SSCommitted Points: 1792 More actions · Answer 2

Robin,

Thanks for the reply

I would not hold my breath this is Microsoft dont forget.

i have used other reporting tools such as crystal, access and active reports and page breaks were as you said a very simple operation.

i have been only using SQL Server Reporting for 6 months and this is the first of this type of report i have attempted to do, having done similar ones in other technologies with ease.

i will continue to scour the web and play around with my report and if i find a solution i will post it here for you.

Thanks again.

Glen Harland SSC Enthusiast Points: 153 More actions · Answer 3

Try putting a detail group on the list and then a page break on the detail group. Group on the data that identifies a statement e.g. the client key or invoice number.

Hope that helps.

brunm SSCommitted Points: 1792 More actions · Answer 4

I have tried this and it works to some extent, the problem now is the list of records in the subreport, If they can not be fitted on a page, the table is started on a new page.

i need this to look like any standard invoice would look. if the items must run to a second page, then it needs to split the table accross two pages.

There does not seem to be a setting on a table to do this. This is a bulk invoice print i am trying to produce. On some of the statements it works fine, but for some it starts the subreport on a new page even if there is 3/4 of a page left on the first page of the statement

brunm SSCommitted Points: 1792 More actions · Answer 5

This is now working. When i checked how it was rendering on my report server it is working fine. In VS it is doing the extra page breaks, but not through report Manager

What a chew-on

Thanks for all your help

Robert O'Byrne SSCrazy Points: 2017 More actions · Answer 6

If I understand this process, you're ending up with one large report with every invoice. If you don't need everything in report you may be able to set up a data driven subscription which would loop through each company and create one report for each. The page break issue would then be lessened.

brunm SSCommitted Points: 1792 More actions · Answer 7

Robert,

Thanks for the reply but i am happy with the solution i have now.

i also feel that by doing it the way you suggest it may very well put a serious load on the report server as it tries to render each one as an individual report.

For my particular instance, there could be thousands of individual invoices to be generated at once.