E-mail
Before adding Reports to Job Manager, they first must be created or "authored". The result of authoring a report is an RDL file that can be added to Job Manager (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 tool that has been tested for authoring reports for use with Job Manager is the Report Designer Plug-in for Microsoft Visual Studio 2003. This Plug-in is available for installation when installing the SQL Server 2000 or 2005 Reporting Services.
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.
The table below describes how parameter types used in your RDL file can be mapped to field types used in your Job Manager database.
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 Types
The user interface allows you to associate reports with Folder 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 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: