Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: How to add Headers for detail Section? Post Reply Post New Topic
Author Message
nrusa
Newbie
Newbie


Joined: 03 Mar 2008
Location: United States
Online Status: Offline
Posts: 5
Quote nrusa Replybullet Topic: How to add Headers for detail Section?
    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
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet 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
IP IP Logged
nrusa
Newbie
Newbie


Joined: 03 Mar 2008
Location: United States
Online Status: Offline
Posts: 5
Quote nrusa Replybullet 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
NR
 
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet 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
IP IP Logged
nrusa
Newbie
Newbie


Joined: 03 Mar 2008
Location: United States
Online Status: Offline
Posts: 5
Quote nrusa Replybullet 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
NR
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.