Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Grouping display string formula results Post Reply Post New Topic
Author Message
curt
Newbie
Newbie
Avatar

Joined: 15 Jul 2009
Location: United States
Online Status: Offline
Posts: 4
Quote curt Replybullet Topic: Grouping display string formula results
     Posted: 15 Jul 2009 at 9:34am
Hello... this is my first post on this forum and looking at some of the helpful posts i've read on here, I have to warn you that my expectations are through the roof! :) 
 
Get to the point, right? Okay, so I'm creating a report in crystal 10.  There are a couple of records in the db field i'm grouping on that are different but similar that I would like to group together.  For example: the records would be:
 
application_name.exe
application_name.exe1
 
Adjacent to the group name (application name) is a field that displays the usage time of this particular application.  As such, I need to combine the usage time for these two applications, not just suppress it as a duplicate. I've tried using a display string formula to make the two records display the same, but it leaves both records in the report. 
 
I apologize if my explanation is messy, but i appreciate any help you can provide. 
 
Thanks! Curt
 
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Jul 2009 at 10:57am

You can handle this in a few ways.

One would be to alter your data outside crystal (via Stored proc or a view)or to use a Command in crystal that would use a SQL case statement to and grouping to acually restructure your data to combine multiple rows into 1 rather than just adding the tables directly.
 
If those are not an option you can replicate the look and end results by doing what you started to.
Make a formula as a string that makes them the fields display the same.
 Add a new group using that formula field.
Insert a Summary of the Usage Time field as a SUM and place that on the group new group header.
Suppress the detail row.
IP IP Logged
curt
Newbie
Newbie
Avatar

Joined: 15 Jul 2009
Location: United States
Online Status: Offline
Posts: 4
Quote curt Replybullet Posted: 15 Jul 2009 at 12:13pm
Thanks DBlank!  Perfect!  I don't have access to modify the DB, but your solution of grouping the display formula worked like a champ. Big%20smile
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.