Adding Notification Reports

Vector HelpDesk can use reports to format information included in e-mail notifications. For example, the Detailed and Summary items are formatted by reports. You can define new reports and add them to the list of items that can be included in an e-mail notification message.

To add a new report for notifications:

1    In HelpDesk Admin, use the Report Editor to define a new listing report.

2    Save and preview the report.

3    Exit HelpDesk Admin.

4    Open the project definitions database.

5    Open the tblSystemCustomReports table, find the record for the report you just created, and get the nID value.

6    Open the tblMailContents table and create a new record.

 

Field

Description

 

nID

Next available ID number for a record in the tblMailContents table.

 

tName

Name displayed in the Include list of the Notification Editor.

 

nType

2 = include in message body
3 = attachment

 

tFunction

The GenerateReport function takes care of generating the report for the notification message.

 

tArguments

<nID>.10, where <nID> is the ID of the report in tblSystemCustomReports.

 

nFormatType

4 = rtf
8 = text
14 = word
31 = pdf
32 = html40

See Changing the Format of Attachments for more format type values.

When nType = 2, nFormatType must be 8 (text).

 

The report is now available in the Include list of the Notifications Editor.

If you’re using Crystal Reports for your listing reports, you’ll have to create a Crystal Report report file (.rpt) for the new notification report.

To create an .rpt file for your notification report:

1    View the report in a Web view.

This creates an .rpt file in the CensusWebVD\<project>_<view>\Reports folder. For example:

\Program Files\Vector\HelpDeskServer\CensusWeb\Views\CensusWebVD\helpdesk_helpdesk\Reports

2    Copy the .rpt file to the HelpDeskServer\<project>\Reports folder. For example:

\Program Files\Vector\HelpDeskServer\helpdesk\Reports

3    Rename the file by removing portrait (or landscape) from the .rpt file name.

Related Topics

Defining Listing Reports

Specifying Notification Contents

Changing the Format of Attachments

Attaching Information

Adding Custom Mail Contents

Example Macros

Editing Databases