AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Rate List Sorting Expand / Collapse
Author
Message
Posted 10/10/2006 10:51:56 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 10/1/2007 10:04:58 AM
Posts: 127, Visits: 569
How do I sort the Rates List in a report?

I need to be able to sort rates by any of the available fields; Name, Account Number, etc.

Regardless of how I sort them on the screen they always appear in in the same order on the Rates List report.  This happens with both the Rates List and Rates List - Summary templates.

Thanks,

Bob

Post #2132
Posted 10/10/2006 11:05:09 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 12:06:34 PM
Posts: 1,799, Visits: 4,172
Hello Bob

The Rates grid does only provide Summary Report Templates, and comes with a sample report called Rates List. Is this the report you are referring to?

To group a summary report by a specific field, select the detailBand, insert a GroupHeader band, select Properties tab for this GroupHeader band, select the GroupFields property to open the GroupField Collection Editor, Add a GroupField, select for the FieldName the field you wish to sort by, and set SortOrder by Ascending or Descending, than Preview from the bottom of the panel to see how your report is now sorting.

You can also refer to the AyaNova v3 Printing & Reports topic http://forum.ayanova.com/Topic844-100-1.aspx  which includes how to set the sort order of a report template

Also the following topics

 http://forum.ayanova.com/Topic1523-100-1.aspx

http://forum.ayanova.com/Topic1653-100-1.aspx

http://forum.ayanova.com/Topic2105-100-1.aspx

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2133
Posted 10/10/2006 11:22:47 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 12:06:34 PM
Posts: 1,799, Visits: 4,172



AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2134
Posted 10/10/2006 11:51:13 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 10/1/2007 10:04:58 AM
Posts: 127, Visits: 569
Thanks Joyce,

Yes that is the template I was referring to.  We created another template to rule out that the sample template wasn't the culprit.

Post #2135
Posted 10/10/2006 12:01:46 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 10/1/2007 10:04:58 AM
Posts: 127, Visits: 569
So this means if I want to be able to sort by any one of the 10 available fields I would have to create 10 separate templates?
Post #2136
Posted 10/10/2006 12:07:01 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 12:06:34 PM
Posts: 1,799, Visits: 4,172
Correct.

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2137
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 2:32pm

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.094. 12 queries. Compression Disabled.