473,404 Members | 2,137 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,404 software developers and data experts.

HowTo have 2 tabular detail lines on Single report ?

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
1 1361
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Guy Mahieu | last post by:
All, Is there a simple way to manipulate the details section of a Crystal Report at runtime on a per-record basis? The reason I want to do this is that my database table contains an image url...
1
by: Melissa | last post by:
I created a report that is grouped and I set it to go to a new page after each section. Each page will have a different number of records. I have a function that looks at the number of records and...
4
by: Robert | last post by:
Is there some way to suppress the automatic line feed in the detail section of a report in Access? I would like the detail to print out to the right of the existing one. The next line would be...
1
by: khalsaiskingraajkaregakhalsa | last post by:
hello all, i m using vb.net.i want to make a crytal report which contains a subreport in the header .the subreport in the header will display class info like class ,class teacher,class monitor...
2
by: Ray | last post by:
Dear all, I would like to ask if the crystal Report can remove if blank in Detail just like Report in Foxpro? Thanks a lot, Ray
0
by: BerkshireGuy | last post by:
I have a report that list when an employee has been warned - by month and year: So something like Jan 2007 Warned Feb 2007 Warned April 2007 Warned In the summary of the report, I...
4
by: Karl | last post by:
How do you set the width of a control in the detail section of a report using the On Format event for the detail section?
3
by: Ly Cao | last post by:
Please shine the light, how do you place the total on the last page of the invoice? how do you find out the it is a last page of the detail lines then place the total of the invoice into that last...
2
by: KD5588 | last post by:
I'm trying to create a report that displays the following information: Physician Name Company Name Address City, State, Zip The physician name OR the Company name could be blank OR both...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.