Print Page | Close Window

crystal report single display

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=15674
Printed Date: 07 May 2024 at 6:51am


Topic: crystal report single display
Posted By: asdfg
Subject: crystal report single display
Date Posted: 20 Feb 2012 at 2:56pm
my report show this way:

surname 1 firstname1 middlename1
surname 1 firstname1 middlename1
surname 1 firstname1 middlename1
surname 1 firstname1 middlename1
surname 1 firstname1 middlename1
surname 2 firstname2 middlename2
surname 2 firstname2 middlename2

i want to display my those records this way

surname 1 firstname1 middlename1
surname 2 firstname2 middlename2

since the 5 surname 1 firstname1 middlename1 have different values in other columns (and so as the surname 2 firstname2 middlename2)... in my crystal report I want to display only the surname, firstname, and middlename...

how can I display the records the way I want?
any help is appreciated... thanks



Replies:
Posted By: rkrowland
Date Posted: 20 Feb 2012 at 11:50pm
You could create a formula like the following then group by it (put the formula field in your group header rather than the details section);
 
{table.surname} & " " & {table.firstname} & " " & {table.middlename}
 
Regards,
Ryan.



Print Page | Close Window