(UTC)
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Report design (Read 942 times)
pineberry
Full Member
***
Offline


No personal text

Posts: 115
Location: Strawberry, AZ  USA
Joined: Nov 30th, 2002
Report design
Aug 15th, 2013 at 10:49pm
Print Post Print Post  
I have a report that lists customers and all items sold to that customer. Using no repeat with break on customer the report works but the header titles are repeated for each break. I would also like to suppress printing of other information that is duplicated for each item such as phone number and email address. How do I clean up this report? I do need the phone and email listed but only once.
Suggestions would be appreciated.

cust  item phone email
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Report design
Reply #1 - Aug 16th, 2013 at 2:35pm
Print Post Print Post  
Hello Harley,

This should give you what you are after,

Set up the report so that it is sorted by Customer and then by E-mail Address.
Remove the current break from Group Header 1 so that the header titles do not repeat.
Add a Group Header 2
Set it to break on Customer with No Repeat
Add a Group Header 3
Set it to break on Email with No Repeat
Add a Group Header 4
Set it to break on Phone Number with No Repeat
You do not want to place anything into the new Group Header 2, 3, or 4 or into the matching Group Footers.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
pineberry
Full Member
***
Offline


No personal text

Posts: 115
Location: Strawberry, AZ  USA
Joined: Nov 30th, 2002
Re: Report design
Reply #2 - Aug 16th, 2013 at 4:25pm
Print Post Print Post  
Thanks Ray,
That worked just great. The report cleaned up and looks very good.
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge