ITGOD (6/13/2006)
When i build a work order or quote i put many different items into the work order and usualy the represent the different stages of a large project. The problem i run into is that when i try to print the detailed report of the work order or the quote (the prebuild report) it seems to sort the items in random order. I have tried numbering my items as well as putin letters in them in different orders but i can not seem to get it to sort. I have also gone to the report editor and can not find any options to sort the report based on a particular field in the report. Is this functionality not available or am i just blind??? Thanks David Hi David The Collection of the GroupFields property for the GroupHeader of a band is where you could set the sort order. For example, if you were referring to the Detailed Quote sample report template that comes with AyaNova v3 and you wanted to sort the order of workorder items based on the Item Summary data field: 1. Add a GroupHeader band to the DetailReportItem - WorkorderHeader.WorkorderHeaderWorkorderItem (right-click on the DetailReportItem - WorkorderHeader.WorkorderHeaderWorkorderItem , select Insert Band -> GroupHeader) 2. Select the GroupHeader band created. In the properties of the GroupHeader band for this DetailReportItem, select to open the (Collection) for the property GroupFields 3. Select Add in the GroupField Collection Editor 4. Drop down the FieldName property and scroll to select the data field for Item Summary and select it. 5. Set the SortOrder to either Ascending or Descending as you want it. 6. Select OK 7. Now Preview the report template to see how it is sorting by the Item Summary. Also take a look in the AyaNova v3 Report Templates area of this forum for the tutorial on creating a detailed service workorder report template - which includes screenshots in steps 17 through 24 on using the GroupFields property of a GroupHeader band - which will make it easier to understand where to select in a report template etc. I will also move this topic to the AyaNova v3 Report Templates area of this forum shortly as the topic is more appropriate to that forum. - Joyce
- AyaNova Sales & Technical Support
- http://www.ayanova.com
|
Posted 6/13/2006 3:49:55 PM
