Body section over 2 pages

Hi
How can I set the body section of a report to flow over multiple pages, similar to when writing a letter?

With an overall page height of : objReport.PageHeight = 842

.AddLabel "Doors / Windows", 150, 800, 100, 11,, DPDF_Font_Helvetica, 8

The above line intrudes into the footer.

Many thanks.

Hello,

In DynamicPDF ReportWriter v1.6 you cannot have the body section of the report flow over multiple pages. This is a limitation of DynamicPDF ReportWriter for COM/ActiveX v1.6. This limitation will be addressed in the next version of DynamicPDF ReportWriter for COM/ActiveX.

Thanks,
ceTe Software Support Team

Thanks for that.
Kindly advise when the next version is due for release.

Thanks.

Hello,

We are currently not sure on the exact dates for the release of the next version but a rought estimate would be sometime within 6 to 9 months.

Thanks,
ceTe Software Support Team

Hi
Do you have another product in your range that will allow this functionality? Specifically when using SQL SP?

Thanks.

Hello,

Yes, the Generator product would work well for this using its overflow functionality. You would need to handle the pagination yourself, so there would be more coding, but the overflow functionality is designed for this type of situation.

Take a look at the following help topic for more information:
  Text Continuation

This will be a good starting point. For your exact situation, you will need to start the text area at your current y position and make it as tall the the area left on your page. If it has overflow text, you can then move to the next page and loop.

Thanks,
ceTe Software Support Team

Hi
Is it possible to create physical multiple pages, ie (pg1, pg2), this way I could seperate the report.

Thanks.

Using the Generator product recommended above yes you are able to define pages as needed while building the document (in fact the document in Generator is just made up of pages that are created and then added to the Document.  ReportWriter however does not have the ability to specify and define a page within a report.

Thanks,
ceTe Software Support Team

Hi,
A little confused. I'm using ReportWriter (to use with Stored Procedures), but I thought this included Generator 2.6??

Given our requirements, which product would be best?

Thanks.

You can use either ReportWriter or Generator to create PDF reports from stored procedures.  Because ReportWriter handles pagination as well as headers and footers of the report automatically the coding that it takes to create a PDF report using ReportWriter can usually be simpler, but at the same time ReportWriter has its limitations.  One of those limitations that ReportWriter has is that it will not split any of the records (as you mentioned in your original post that you had a record that was spilling off the page because it was so long).  This is just a current limitation. 

Because of this limitation of ReportWriter, we suggested that you use or Generator product.  With Generator no pagination or section handling is built into the product, so the coding will be a little more extensive, but using the Generator product you have complete control over every element in your report.  This means that if as you are building your report (using Generator) you come to a record that does not fit on a page you can place the text that will fit on the first page and overflow the rest on the to next and continue this for all the overflow as needed.

As you mentioned before, yes Generator is included with ReportWriter.  But you see that there is no way to interrupt a PDF while it is being created with ReportWriter to use some logic from Generator.  In other words you need to either create the entire report with ReportWriter (knowing certain limitations) or create the entire report with Generator (knowing you have control over all the coding).

Because your records, in some cases, may contain data that is too long to fit on an entire page you will need to use Generator not ReportWriter.  ReportWriter is very useful when you when you know that there will never be any one record in your stored procedure that will take up more than one entire page.

Thanks,
ceTe Software Support Team

Hi
Can you please advise if a new version of ReportWriter is going to be released that will overcome this limitation?

Hello,

We will be releasing new version of ReportWriter but it will be atleast another 6 to 9 months. Again this is just an estimated time frame and we do not have any exact dates for the next version release.

Thanks,
ceTe Software Support Team