I have and issue which I cant fix for prolonged time period. I have a report which prints results saved in temp table. The code which inserts entries in temp table is simple while select
statement.
while select inventQualityOrderLineResults where
inventQualityOrderLineResults.QualityOrderId == ebGateEntry.InventQualityOrderId
{
if(inventQualityOrderLineResults)
{
this.insertAcceptanceReportTmpDetails(inventQualityOrderLineResults);
}
The problem persists as long as I have this variable lenght table in my report. Have you experienced similar problems. What could be the solution? Would be nice if could help me.
Most often than not, an extra page is appearing when one of the fields are out of the margins… take a closer look at the report width, body width, or any other section that may go out of page size. See what detail you can see on that extra page - header, footers, page num, and it will help
No need to go deep into your coding here since its not at all related to your design(Although use Query instead of while loops of insert_recordset )
Talking about Design what Page size your are all looking for?
If its A4 make sure all your Design(Header + Body + Footer) should fit in this section. Since you have table structure make sure you have row limit accordingly for since page.
Preferred method is using rectangle and put everything under it.This will help you in achieving right format.
I know this looks sounds very basic but this is how i fixed it in my machine…
Thanks for the suggestions guys. I added rectangle and put everything in it. From the screenshot you can see that the rectangle size is smaller than the A4 page size. However, as you can see from the second screeshot it keeps adding the new blank page anyway. Is there any way to fix report size on max one page?
)
