Print Page | Close Window

Made Numbers

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7560
Printed Date: 06 May 2024 at 9:16am


Topic: Made Numbers
Posted By: jokoo
Subject: Made Numbers
Date Posted: 01 Sep 2009 at 10:35pm
Hi,
I get trouble when i want to make numbers for my report in crystal report x.

unit: OTI
Number     Grade     Name   Site
1                1            Jane    192.168.1.2
2                1            Jane    192.168.1.7
3                3            Zent    192.168.3.4
4                3            Zent    192.168.9.2

from report above, I want to arrange  that report like below:
Number     Grade     Name   Site
1                1            Jane    192.168.1.2
                                           192.168.1.7
2                3            Zent    192.168.3.4
                                            192.168.9.2

Please, help me. Thanks before


Replies:
Posted By: hilfy
Date Posted: 02 Sep 2009 at 4:06pm
For your number field - do a Running Total that is a distinct count of whatever identifies what you want the number to represent.  In your example above, if you're translating name from some kind of ID number field, you can use that ID number.  I wouldn't necessarily use "Name" because you won't get the right counts for duplicate names.
 
To get the extra info to disappear, right-click on the field (Grade or Name in your example), Format Field, and turn on Suppress if Duplicated.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window