Report Design: How to add Headers for detail Section?

Print Page | Close Window

How to add Headers for detail Section?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2524
Printed Date: 28 Apr 2024 at 9:15pm

Topic: How to add Headers for detail Section?

Posted By: nrusa
Subject: How to add Headers for detail Section?
Date Posted: 05 Mar 2008 at 9:44am

Hi,

I created report and it is having one group and it is working fine. But in my report I am using 2 details section. Detail A section followed by Group section for this added all headers in Group section this is fine.

I have another detail section in my report and it displays different field data. I am trying to add headers for this using formula field and text object it overlaping all fields.

Pls guide me any one have idea how to add headers for Headers for detail B section( second detail section ).

Thanks in advance

Regards

nrusa

Replies:

Posted By: rahulwalawalkar
Date Posted: 05 Mar 2008 at 11:31am

Hi,

Can you paste some data .....what excatly is overlapping.....

I tried this

Group Header Cust Id Address

Details 1 158 Sitio del Niño 8992

Details 2 Region Mendoza

Cust Id Address

157 Av. Cobre 1212

Region St. George

Cust Id Address

143 8004 Alton Drive

Region New South Wales

Text in red are Headers

Cheers

Rahul

Posted By: nrusa
Date Posted: 05 Mar 2008 at 5:36pm

Hi Rahul,

I appreciated your help.

I am looking for below format. Pls guide me is there any way to do below format.Thanks

Group Header: Cust_Id        Address
Details 1   :      158               Sitio del Niño 8992
                        213               Noel Rd
                        243               Springvally
                        1036             Beltline

Details 2           City              State     ZipCode
                         Irving           TX          75041
                         Wheeling      IL          65001
                         Frisco            TX         74002

Text in red are Headers.

Regards

Posted By: rahulwalawalkar
Date Posted: 06 Mar 2008 at 5:04am

Hi NR,

Create a Subreport for City State and Zipcode Fields same as your main report including the groups.

Link the subreport using the customerid field

Then create details b section and place the subreport in that section.

In the main report select groupfooter rightclick select section expert then

Click x+2 button next to New Page After and enter

NotOnLastRecord

Cheers

Rahul

Posted By: nrusa
Date Posted: 06 Mar 2008 at 5:37am

HI Rahul,

I did the same beore posting my query.. For 10 rows it takes about 10 min..

Creating report using Stored Procedure and SP is cotaining 3 params.

Pls guide me is there any other ways to do this.

Thanks

Print Page | Close Window