Print Page | Close Window

Grouping Problem

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=6211
Printed Date: 03 May 2024 at 2:29am


Topic: Grouping Problem
Posted By: vesperka
Subject: Grouping Problem
Date Posted: 29 Apr 2009 at 6:49am

I'm trying to create a report that gives an application name along with each of it's dependencies. I'm running into a snag though because most applications have more than 1 dependency. Here's what my situation looks like:

 
App Name                     Dependency
 
App1                             App2
App1                             App3
App1                             App4
 
 
Simply put, I'd like the report to only list App1 once (possibly in a header) and then list all of its dependencies. What's the most efficient way to do this?
 
*EDIT* Nevermind, I figured it out. I setup a group by AppName, and then removed the AppName field from details. In case you couldn't tell I'm a little new to Crystal LOL



Replies:
Posted By: DBlank
Date Posted: 29 Apr 2009 at 7:01am
As long as you have one ow per app per dependency you have 2 basic options.
1. create a group on App Name field and only put the Dependency field in your details.
2. Primary sort set on App Name field, optional secondary sort on Dependeny field. Put Both on details section, no grouping.
Right click on the App Name field.
Select "Format Field".
Select the Common tab.
Check the "Suppress if Duplicated" box. (this will suppress this field if the previos row of has the same data in this field.


Posted By: vesperka
Date Posted: 29 Apr 2009 at 7:27am
Thanks man, that's a pretty neat feature that will definitely come in handy in the future :)



Print Page | Close Window