Sort order in report

M

Melissa

I have a report that is based from a table that I have sorted Ascending.
When I run the report, for some reason it is not generating with that
Ascending order. I am using Sorting and Grouping in the report;
Field/Expression =Left([Label2],1) Sort Order, Ascending; Group Properties
Header Yes; Footer Yes; Group on Prefix Characters; Group interval 1, keep
together, no.

Any suggestions or ideas why my data isn't sorting correctly is appreciated!
Thanks.
Melissa
 
M

Melissa

I figured it out. I had to make another entry in my Sorting and Grouping
dialog with just Owner/Ascending.
 
J

Jerry Whittle

The first thing to know is that the sort order in either a table or query
means nothing to a report. In fact you can speed up some complex reports by
removing the sort order in its query.

It looks like you are sorting on just one character as you are using the
Left function. Then you are grouping on prefix characters of just one. Seem
redundent to me.

Also you are sorting on a field called Label2. Is the the field that you
wish to sort on? Often something named 'Label' is just that, a label and not
the actual data.

Could you show use some of the data in question and how it is being sorted.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top