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



Sorting the Dispatch Report in order of... Expand / Collapse
Author
Message
Posted 1/12/2010 12:19:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 1/12/2010 12:43:39 PM
Posts: 7, Visits: 16
We have been using a customized version of the dispatch report to print a scheduled user's jobs for the day.  The problem is that the order in which they are printed is not the same as shown on the scheduling screen.  If the user has workorders scheduled on 1pm, 2pm, 3pm, 4pm,  they may be printed 4, 2, 1, 3.  Since our customized dispatch report tries to save paper it does not use page breaks between workorders, and the user cannot manually shuffle the papers to get them in the right order.

Basically we need the workorders sorted by the Scheduled Users Start Date and Time.

We have noticed the Sample Dispatch Report also does not sort properly and so if you can solve the problem with that one, then we can apply the same change to our custom one.  If needed I can export our report template and post it here for you to look at.

Thanks

Post #4972
Posted 1/12/2010 12:52:08 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: Yesterday @ 7:34:22 AM
Posts: 2,190, Visits: 5,029
Hi Blye

The Sample Dispatch Report was not designed to print out based on the Scheduled Users Start Date & Time. As with most reports in AyaNova, report order is based on the sort order of the grid printing from. (i.e. if printing from the Service Workorders grid, the order of workorder records in the grid is the same order the report will print out the records for).

But if printing from the Schedule screen itself, a suggestion to have the dispatching report print out based on the Scheduled Users start date and time is to add a GroupHeader for the DetailReport band, and edit its Group Fields Collection property to sort ascending by the Scheduled Users start date & time.

I have an example below:

1. Right-click on the DetailReport band -> Insert band -> Groupheader


2. With this GroupHeader band selected, view its Properties
3. View the Group Fields property's Collection


4. Add a new member


5. For the Field Name, drop down and coninue expanding and select the Start Date & Time from the WorkorderItemWorkorderItemScheduledUser dataset


6. Now Print Preview and you will see that the workorder items previewed will be in the order based on the Scheduled Users start date and time.

Do try out the above. If further customization is needed, we are happy to provide cusotmization as outlined in the topic http://forum.ayanova.com/Topic3447-100-1.aspx

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #4973
« 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 3:34pm

Powered by InstantForum.NET v4.1.4 © 2010
Execution: 0.031. 9 queries. Compression Disabled.