Print Page | Close Window

Can you override a Group Sort?

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=20103
Printed Date: 02 May 2024 at 1:47am


Topic: Can you override a Group Sort?
Posted By: Ariel
Subject: Can you override a Group Sort?
Date Posted: 09 Oct 2013 at 3:46am
I have a complex report that is grouped by ID and therefore sorted by ID.  We would like it to be sorted by Company name so we can match them up with invoices (that are sorted by company).  Is there a way to do this?  Someone mentioned a staging table, but I'm not sure what that means.
Thanks!
Ariel


Replies:
Posted By: DBlank
Date Posted: 09 Oct 2013 at 4:17am
i assume that each invoice ID is only related to one company.
either add another group above the ID level using the company name and group on that and suppress it.
Or you could possible change your ID grouping to use a concantenated combination of the comapany name and then the ID
table.companyname + "-" + totext(table.ID,0,"")
 
Keep a copy of your origianl report in case the grouping changes causes calculation issues

Posted By: lockwelle
Date Posted: 09 Oct 2013 at 4:53am
Twisting what DBlank said, I would assume that in the record that there is a company as well as the Invoice ID.

You can easily create a formula like:
{table.company} + "-" + {table.invoiceID} (adjusting for converting to string if needed) and group on that, which will sort as you desire...

Depending on how it adds to the complexity, you could just add a group above the invoice that is based on Company...then you would see the company and could run totals etc.

And we all know that sometimes, something that souunds as simple as adding another group, is way more complex and undoable.

HTH

Posted By: Ariel
Date Posted: 09 Oct 2013 at 4:56am
Thank you so much!  I think DBlank's solution will work, I just need to have the user compare the data and make sure everything is there.


Print Page | Close Window