Issue in report contacts grouping city wise

I found a issue in report created for contacts grouped city wise in sugarcrm 6.5,

I have created a report for contact list city wise, have added city in group "Group By: City" have also added same field in display column(Display Columns: Name, Email Address, Account Name, Designation, City),

Same city field is used in grouping and display columns, any suggestions ?

In result I found

City = None, Count = 8

and in entries under this None group have city names in few and empty in few, same for City = Mumbai, some entries have city name as Mumbai and for some it is blank.

0 Alan Apter over 7 years ago

Are you sure that the 'City' field is filled in for those records and it's not another city (e.g. street) that's filled in with City? Also, have you checked whether billing_address/shipping_address might account for the difference?
If you could do an export of the problematic rows and attach them to a comment, it would help in trying to diagnose the problem.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Hemant Patil over 7 years ago in reply to Alan Apter

Alan Apter, Thank you for the reply.
I found the issue, In my report I have set Ascending Order on Name Field in display columns, due to which report was giving incorrect output.
I think this may be the bug in report, need to check on this in documentation, as of now my issue is resolved, I have removed sorting.
Alex Nassi Ramana Raju Santhana Mehul Bhandari Tevfik Tümer Is that a known issue?
Cancel
Vote Up +3 Vote Down

Sign in to reply

Reject Answer

Cancel
0 Alan Apter over 7 years ago in reply to Hemant Patil

It seems to be this issue - https://web.sugarcrm.com/support/issues/8cb8b10d-6a1b-db19-0849-519e851aa25e - which version of Sugar are you on/
Glad you found a workaround. If you want to open up a case you can at https://web.sugarcrm.com/support/cases . If you want to check known issues you can search here - SugarCRM, Inc. .
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Katie Liesmann over 7 years ago in reply to Alan Apter

Hi Hermant! So glad the Sugar community is able to support you. If you're looking for other ways to improve your Sugar instance we've got the event for you. We'll cover user adoption, security and optimization and give attendees worksheets to complete their own CRM assessment. More on our free, online workshop: http://ow.ly/ZpD4305yCzO
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel