GroupSort Problem 1

[jcl5]

Please help - I think I'm going mad!

I have a report which is grouped (GH3) by COMPANYID (unique key) but I want to display the records by COMPANYNAME.

It should be so simple but I can't seem to get it to work.


What is the (simple) answer?

Thanks

jcl

 

[vidru]

Right click on GH3>Change Group. In the Group Options section, check 'Customize Group Name Field', use 'Choose from existing field', and select your Company Name field.

In GH3, if you've got Group #3 Name in there, it should now print the Company Name that corresponds to the ID instead of just the ID.

Or, you could just get rid of the Group #3 Name field, and replace it with Company Name.

-dave

 

[jcl5]

Thanks for the quick response Dave!

I already have the group name customised to company name but it isn't sorting them alphabetically.

I need to keep the companyid as the group header because there are duplicate company names (different branches) in the database.

Thanks

jcl

 

[vidru]

Sorry, even though the thread says 'Group Sort', I missed it...

How about this... create a formula to use for Group 3:

//@Group3
{Table.CompanyName} + totext({Table.CompanyID},0,"")

Then instead of grouping on {Table.CompanyID}, group on @Group3, then show your CompanyID field in the header.

-dave