Print Page | Close Window

Grouping

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=21336
Printed Date: 02 May 2024 at 6:33am


Topic: Grouping
Posted By: brockloch
Subject: Grouping
Date Posted: 13 Feb 2015 at 1:00am
I wonder if someone can help please.

I have a field in a database which contains data as follows:
"AB1235/AB1234"
"AB1235"
"AB1233/AB1235"
"AB1234"

I want to be able to group by each instance of ABxxxx.

I know I can split them at the "/" but can I then group as
"AB1233" = 1
"AB1234" = 2
"AB1235" = 3

Any help would be much appreciated.

Ed



-------------
brockloch


Replies:
Posted By: DBlank
Date Posted: 17 Feb 2015 at 4:02am
you would not be able to group on them because the data only existsw on one row and would only appear in the first group it matches to.
You could split it in a command or stored proc and union the data to create multiple rows.

Posted By: brockloch
Date Posted: 17 Feb 2015 at 11:06pm
Thanks again for your help I will try the command/union.


-------------
brockloch


Print Page | Close Window