Solved

Crystal Reports XI max

Posted on 2014-04-14
4
288 Views
Last Modified: 2014-04-14
So I have a field that I am attempting to sort based on max but it gets a little tricky so asking for some input...

The field data looks like -
17p123e234-401
17p123e234-401A
17p123e234-401M
17p122f4321-505
17p122f4321-505B
17p122f4321-505R

What I am attempting to do is group by the digits before the hyphen then find the max based on the max digits to the right of the hyphen... so I end up with

17p123e234-401M
17p122f4321-505R

as the groups....

I did maximum but it took the max for the total and left me with 1 item lol

Help :)
0
Comment
Question by:mebaby333
  • 3
4 Comments
 
LVL 22

Accepted Solution

by:
Ido Millet earned 500 total points
ID: 39999528
Group_By formula: Split({your_field}, "-")[1]

Formula to find Max of: Split({your_field}, "-")[2]
0
 
LVL 5

Author Comment

by:mebaby333
ID: 39999557
When I attempt to put the split into the Group Expert like this
Split({FS_CustomerItem.CustomerItemNumber}, "-")[1]

it tells me there must be a constant in the place of

{FS_CustomerItem.CustomerItemNumber}
0
 
LVL 5

Author Comment

by:mebaby333
ID: 39999655
lol formula... okay
I have a serious case of Monday brain apparently today...
0
 
LVL 5

Author Closing Comment

by:mebaby333
ID: 39999758
Thanks
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question