|
|
|
Forum 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
|
|
|
|
|
AyaNova 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
|
|
|
|