Ordering a report on Family Name and not Family ID

[jammin140900]

Hi all,

Just need to know how to order a report which is currently grouped on Family ID (Number) so that it prints in ascending order according to Family Surname. I have tried putting
[ttmpAllCancellation].[FamilyName] ASCENDING

in the Order By field but this does nothing. Do I need code?

Thanks,
J

 

[boblarson]

I'm thinking you probably don't have the family name in the underlying query for the report, do you. You probably are using Lookups at table level, so it LOOKS like you have the name available when you look at the table, but since it is a lookup, it is actually the ID which you have.

You need to include that name field in the underlying query for the report. If you are just using the table, change to using a query instead. if not sure how - check out my "quick tutorial" on that.
http://www.btabdevelopment.com/main...dsourcefromtabletoquery/tabid/75/Default.aspx

And/or removing lookups:
http://www.btabdevelopment.com/main...oveLookupsatTableLevel/tabid/141/Default.aspx

 

[jammin140900]

Thanks Bob. Yeah, you're right. I was linking it directly to a table. I've changed it so it queries the data and ordered it according to your tutorial. When running it, it still doesn't order by family name though...

Anything else I'm doing wrong?

 

[gemma-the-husky]

reports carry their own sorting independent of the query

look at sorting and grouping, for the report

 

[boblarson]

reports carry their own sorting independent of the query

look at sorting and grouping, for the report

What he said...