Open your daily report. I'm assuming you're using the standard VDN report: Report (Skill) Daily
Select Report | Design
Select Report | Save As and rename it something like: Multiple VDN Daily Report (You DO NOT want to write over the standard report! Saving it as a different name is important)
If you only want administrators of the system and yourself to see the report, select Only Me. If you need others to see it select Everyone and then click OK.
Select Edit | Queries...
Select QUERY0 and click Edit
In the Query Assistant window, in the Database Items list, find VDN and click Add so it shows up in the Query Items. For clean reference, move the VDN item up to the top of the list, just under Row Date and before Vector by clicking the Move Up button.
Click Save
The system will warn you to change the query total as well, click OK.
Select total in the Query Select window and click Edit.
In the Query Assistant window, click in the Other: section and enter '-' then click Add, move this up to be between the 'Totals' and the other '-' entry in the Query Items list.
The system will warn you to change the query QUERY0, click OK. (we already did that)
Click Close on the Query Select window.
Select Edit | Inputs... from the report window.
Under Inputs: click the Multi-Vaule check box on the VDN data item row, then click OK.
In the report window, right click on the table that will house the data and select Format Table.
Select the Data tab and find VDN in the Available Data: list and click Add to move it to the Data on Table: list. Move it up by clicking the Up button so it's after the ROW_DATE and before VECTOR data items.
Click on the Format tab. Change the VDN "Show Value As" to number if you want to display it as the VDN number and not the CMS dictionary name. Click OK.
Right Click on the VDN: data item at the top of the report window (NOT the VDN column in the table) If you don't want it there anymore, click on Delete, or if you want it to list the VDNs you ran the report on leave it, but if you want it to list the numbers instead of the name, right click and select Format and uncheck the Show Value as Name checkbox and click OK.
Select Report | Save in the report window.
Run your report. Separate non-contiguous numbers by using a semi-colon ie: (12345;23456) and contigous nubers with a dash (ie 12345-12400), you can combine them like this as well (12345-12400;13400;14500) They don't even have to be in order they can be (14500;12345-12400;14500). Sorting is controlled by the report under Format | Sort by menu selection.
That should do it. Let me know if you run into any issues.
- Stinney
"Scire ubi aliquid invenire possis, ea demum maxima pars eruditionis est"
"To know where to find anything is, after all, the greatest part of education"
