Combine Data
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=23044
Printed Date: 18 May 2024 at 2:11pm
Topic: Combine Data
Posted By: bjfils
Subject: Combine Data
Date Posted: 27 Jul 2023 at 7:48am
I have a report created by someone no longer with the company, whose CR skills FAR exceed my extremely basic knowledge. He wrote a daily report that sums job tickets by day by customer, except for one category of customer that is listed by individual job. His formula field that does this is below.
Shared MiscTotal as Number
formula = GroupName ({Ticket.CustomerName})
if left({Ticket.CustomerNum},1)="W" then
formula="!Misc! - "+GroupName ({Ticket.CustomerName})
MiscTotal=MiscTotal+Sum ({@Ticket Total}, {Ticket.CustomerName})
end if
Any ideas how I can tweak this so that all orders from customers whose customer # begins with W are added together as one total, instead of each order listed separately?
Thanks!
|
Replies:
Posted By: lockwelle
Date Posted: 07 Sep 2023 at 11:55am
I realize that I am really late to this...
Would you just remove the IF clause to accomplish this?
HTH
|
Posted By: bjfils
Date Posted: 08 Sep 2023 at 3:52am
|
I'll give that a try. Probably be next week before I get a chance to look at it. I'll let you know. Thanks.
|
Posted By: bjfils
Date Posted: 15 Sep 2023 at 10:18am
|
All that does is remove some text the prepends the customer name so instead of showing !Misc! - ABC Co, it just shows ABC Co.
|
|