Hi

Yes, a suggestion would be the following:

• Follow along with the tutorial How do I customize a filter? in the AyaNova 4 Help file http://www.ayanova.com/AyaNova4webHelp/create_a_custom_filter.htm for an overview of creating a custom filter using dates
• once you have reviewed, view the Items grid in the Service navigation pane
• drop down the filter image on the Serial Number column
• select [NonBlanks] so that workorder item records only show where a specific unit was selected in the workorder item.
• drop down the filter image on the Service Date column
• select the [Custom] filter
• create a custom filter similar to that in the How do I...? for the time range you want to display workorder records
• workorder item records will now only display for the time range you set in your custom filter
• select a report template that you have made that lists all units. Your custom report template might display the Service Date, workorder number, unit or whatever data from the workorder you want.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

Yes - as a report can only use data from the records that are showing in the grid.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

One more question, I got a report together that list over 10 pages of model numbers for whole year of 2008. I am now trying to just have it list the model numbers once with a count. I created a group header, inside that a detail section, and a group footer. What do I do to make this work?

JOE

Using as an example the forum topic http://forum.ayanova.com/Topic3028-103-1.aspx?Highlight=count I've made a quick example report template for the Items grid.

Take a look at my example, and then try different things as you want - but this should point you in the direction.

1. I filtered the Items grid to only show records where a unit was selected for a specific time range

2. Created a new summary report template from the Items grid

3.  used the Wizard to create a report template grouped by the Serial Number showing the workorder number and Service Date

4. I added a GroupFooter (right-clicked on the detailBand1 -> Insert band -> GroupFooter), and dragged over the Serial Number datafield into the GroupFooter band, and then edited its Summary property so that it counted for that group (and brought over that label that has the text "Number of services performed for this unit"

5. Print Preview shows the report listing each serial number once, and then under it the workorder and its service date (so some serial numbers of units had 1 workorder, and some had mulitple)

6. Back to the design panel - I clicked on the detailBand1 to select it, and then edited its Visible property to False.

7. Print Preview again, now the report only shows the unit once (from the GroupHeader), and the count of that serial for each record showing in the grid (GroupFooter)

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

	Post Attachments
	exampleUnitsserviced.zip (1 view, 11.72 KB)