Waspman
Posts: 948
|
| Posted: 01/31/2011, 12:50 PM |
|
Since ordering doesn't work on reports has anyone found a way round it?
_________________
http://www.waspmedia.co.uk |
 |
 |
andrewi
Posts: 162
|
| Posted: 01/31/2011, 3:35 PM |
|
Sorting in the query or SQL of the report has no effect - that seems normal in report designers, I think it's the same in Access.
But you can sort by using groups: select the report, click the "..." button on the Groups line in the report property sheet, and you can choose the sort column and sort order.
Is that what you meant? Or were you thinking about sorters on column headings in reports?
|
|
|
|
Waspman
Posts: 948
|
| Posted: 02/01/2011, 5:22 AM |
|
No good really, I wana group by cart and order by the date of the cart. Doesn't work?
_________________
http://www.waspmedia.co.uk |
|
|
|
andrewi
Posts: 162
|
| Posted: 02/01/2011, 2:31 PM |
|
You're right - you can only select one field for each header to group & sort by.
- you could create two groupings - outer one by date, inner one by cartID. You'll get an additional header and footer for the Date group, but you don't have to have any HTML in it. (the tags can just sit next to each other: e.g. <!-- BEGIN Section LandlordCode_Header --><!-- END Section LandlordCode_Header -->, and you might be able to delete them altogether) That would get you two nested sorting opportunities. Since each cartID will have only one date, grouping by date behind the scenes won't change the visible grouping in the report (apart from the sorting effect)
- or you could create a special sort field in the query as a combination of date + cartid. If you format the date yyyymmdd and add leading zeros to the cartid - e.g. "20110201 0001" you could use this as your group and sort-by field for the report. Sorted as a text field you'll get date order, plus a new group for each cart id.
|
|
|
|
Waspman
Posts: 948
|
| Posted: 02/02/2011, 12:52 AM |
|
2 groupings never worked for me either. I've given it up as a bad job:))
Just shown the data as a table and ordered by cartid and date. It's better less confusing for the client, no repeat column headings, more space etc,:)
_________________
http://www.waspmedia.co.uk |
|
|
|
|
