space between foot and detail

[adaniele]

Hi guys, here is my problem.
i created a report which shows a form. This form works like a receipt. It has a header, details (variable quantity of records) and a footer.
my problem is the space between the details section and the footer section. i need to join both sections.

i am attaching a db as an example. To see how it is working, open the issue list form. Then select issue number 454545, and press the button next to the exit.
also, i am attaching a word doc to show you how the report should looks like.

i hope you could give me any suggestion. thx, Max.

 

[mhartman]

Hello Adaniele
I quickly looked at your report. First, try setting your subforms Can Shrink property to YES. Then I would put the footer section in with the details section. That way the whole section would adjust. I did not have time to test.
Regards
Mark

 

[mhartman]

Hello:
I have attached an adjust report as I stated above. It seems to work. Otherwise, more information desired.
Regards
Mark

 

[adaniele]

Hello:
I have attached an adjust report as I stated above. It seems to work. Otherwise, more information desired.
Regards
Mark

mark, thx 4 your time and hlp.
more info:
when you open the issue list form, in the sample db, and then select issue number 454545, u will see 2 records appearing.
The only thing with your suggestion is that instead of 1 form with 2 records, i get 2 forms. One with 1 record only and a second one without any record.

Could be possible to have a report with 1 form and both records on it?

thx, again, Max.

 

[Chisamba]

Hi,

Instead of using the page footer use the report footer, and set the page footer visible property to no. Obviously if your report is more than 1 page long the info in the footer will only appear on the last page, also if the last page only has one record on it the footer will come halfway down the page. You could write code to insert blank records into the report to fill the page.

Dave

 

[Chisamba]

Hi,

I have attached a report that may work for you. I have added code to your on click event on the report preview button on the issue form. The code adds blank records to your tempmergepermit table when you view the report, I have not been able to prevent the carton quantity field from displaying 0 but I'm sure a bit of work will sort that out. You may want to tidy the code up a bit as well but it seems to work as it is.

Cheers

 

[adaniele]

chisamba.
thx, vey much for your hlp. Max.