E-mail
- Click System Setup in the Administration menu and navigate to Reports and Custom Queries.
- Click New-> Report. The New Report interface will appear in the display pane of the System Setup window.
- Click Create a new report in the Report Definition tab. A selection menu will open displaying available forms in the database.
- Browse to and select the form on which you want to base your report. Microsoft Business Intelligence Development Studio (BIDS) 2005 will open in the background and generate the report. You can view, edit and save the report in BIDS if you want to make any modifications.
You can select the "Blank report" option to create an empty report that you intend to author in BIDS. If Microsoft BIDS 2005 is not currently installed on your workstation, Virtual Ticket will prompt you to install it. Follow the prompts as necessary. - Click Import in the Report Definition tab of Virtual Ticket. Virtual Ticket will upload the report RDL file to the database.
- Select an output type for the report. You can choose from PDF, Excel, and CSV formats.
- OPTIONAL: You may preview your report now by clicking Preview (
). You will be prompted to add any required information necessary to run the report. - Type a name for the report. By default, it uses a name based on the name of the imported .rdl file.
- Select a location in the Custom Application Menu bar for the report to appear in.
This is one way users will access the report. If you do not choose a location, users will only be able to access the report through associated types (see below) or, if no associated types are defined, users will no means to access the report. This effectively means the report is hidden from all but Administrative users. - Select an Associated Folder Type for the Report in the Associated Type field. When a Report is associated with a Folder Type, the Report can be printed from any form associated with that folder type by clicking File-> Print and selecting View Report. Only reports that use one parameter based on the ID field of the folder type can be associated with Folder Types.
- Review the execution timeout settings in the Execution tab. Make any changes necessary.
- Specify the user access permissions for the report in the Access tab.
- Click Save when done. The report definition file will be uploaded to the Virtual Ticket database and the report will be available to the specified users.