By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,760 Members | 1,137 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,760 IT Pros & Developers. It's quick & easy.

HowTo have 2 tabular detail lines on Single report ?

P: n/a
Hi all,

Is it possible to create as follow: page1
---------------------------------------
< Report Title >
Line1 item1 desc1 etc....
Line2 item2 desc2 etc....
Line3 item3 desc3 etc....
Line4 item4 desc4 etc....
Line5 item5 desc5 etc....

< Report Footer >
Bla Bla Bla
Line1 remark1 etc....
Line2 remark2 etc....
Line3 remark3 etc....
Line4 remark4 etc....
Line5 remark5 etc....
---------------------------------------

And subsequence pages were ... page2
---------------------------------------
< Report Title >
Line6 item6 desc6 etc....
Line7 item7 desc7 etc....
Line8 item8 desc8 etc....
Line9 item9 desc9 etc....
Line10 item10 desc10 etc....

< Report Footer >
Bla Bla Bla
Line6 remark6 etc....
Line7 remark7 etc....
Line8 remark8 etc....
Line9 remark9 etc....
Line10 remark10 etc....
---------------------------------------

Q: If I use subreport for report footer, I will get always the last
line no. of the report details. Appreciate any help.

Thanks
sean
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
sean wrote:
Hi all,

Is it possible to create as follow: page1
---------------------------------------
< Report Title >
Line1 item1 desc1 etc....
Line2 item2 desc2 etc....
Line3 item3 desc3 etc....
Line4 item4 desc4 etc....
Line5 item5 desc5 etc....

< Report Footer >
Bla Bla Bla
Line1 remark1 etc....
Line2 remark2 etc....
Line3 remark3 etc....
Line4 remark4 etc....
Line5 remark5 etc....
---------------------------------------

And subsequence pages were ... page2
---------------------------------------
< Report Title >
Line6 item6 desc6 etc....
Line7 item7 desc7 etc....
Line8 item8 desc8 etc....
Line9 item9 desc9 etc....
Line10 item10 desc10 etc....

< Report Footer >
Bla Bla Bla
Line6 remark6 etc....
Line7 remark7 etc....
Line8 remark8 etc....
Line9 remark9 etc....
Line10 remark10 etc....
---------------------------------------

Q: If I use subreport for report footer, I will get always the last
line no. of the report details. Appreciate any help.

Thanks
sean


I'm not sure you want to put it in a report footer. A report footer
always prints at the end of the report.

I'd recommend you look at MoveLayout in online help. It, along with
NextRecord, and PrintSection may help out. Also, OnRetreat may be worth
reading about. Do you print out 5 items per page?

A subreport would work fine but how to limit it to the records on each
page is the problem. See if you can create a column in your query that
can create group numbers that you can use to break on.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.