Before adding Reports to Virtual Ticket, they first must be created or "authored". The result of authoring a report is an RDL file that can be added to Virtual Ticket (this process is described in the Adding and Configuring Reports section of this guide).

When authoring reports, a wide variety of applications are available to help you generate RDL files. As of now, the only tools that have been tested for authoring reports for use with Virtual Ticket are Microsoft Business Intelligence Development Studio (BIDS) 2008\2005.

One concept to keep in mind is that if you are going to bind a report to a specific folder type, you must use only one parameter in your report and that parameter must be of the same type as the ID Field for the Folder Type to which you intend to bind the report. Conversely, reports containing multiple parameters cannot be bound to Folder Types.

Parameter Type Mapping

The table below describes how parameter types used in your RDL file can be mapped to field types used in your Virtual Ticket database.

Parameter Values

SRS Parameters with an "Allow Null Value" property set as False will be treated as required.

SRS String Parameters with an "Allow Blank" property set as False will be treated as required.

Associating Reports with Folder and Document Types

The user interface allows you to associate reports with Folder and Document Types in the database. This allows the report to be printed from any location in the user interface that allows printing of objects of the associated type.

If you want to associate a report with a Folder or Document Type, you will need to include in the report one and only one report parameter with a type matching the ID Field type that the report will be associated with. For example:

Related Topics

• Working With Reports
• Setting Up Reporting Services Access
• Creating Reports from Forms
• Adding and Configuring Externally Authored Reports
• Editing and Updating Reports