Reports

From each of the search windows, TabWare provides the ability to run an external report. The report itself must be written outside of TabWare and can be in any of several formats. TabWare supports DOS/Windows executable files, DOS batch files, Crystal Reports files, non-visual user objects written in PowerBuilder, and any PowerBuilder windows. The External Reports setup window allows you to define the parameters that are passed to the external report and to assign security groups to each report.

Information provided by the user on this tab tells TabWare from which search screen the report is to be run and provides the information TabWare needs to liaison with the external report.

Select the search window from which to run the report from the list of search windows displayed on the left side of this window. To modify an existing report, click on the report name; to add a new report, click the New button. The pointing finger icon indicates the selected window or report. To delete a report, highlight that report and click the Delete button.

Provide the title of the report as it should appear on the window accessed by the GoTo button of the search window.

Click the dropdown button to specify the type of report being called. External Reports can be of the following types:

EXE’s - Dos/Windows EXE files. The system invokes them and passes parameters. No preview is supported except what is natively coded within the EXE.
BAT-DOS Batch files - The system invokes them and passes parameters. No Preview is supported except what is natively coded within the BAT file.
RPT - Crystal Reports files. The system calls the API and sets the parameters before executing the job. Preview is supported.
NVO - Non Visual User Objects written in PowerBuilder. The UserObjects must start with either uo_ or nv_. Preview is supported if the code is in the userobject to support preview. The structure passed from the query is passed to the userobject as a parameter.
WIN - Any Powerbuilder window. This will always be opened as sheet.

Click the dropdown button to indicate the location of the external report. The path to the external report must use UNC names.

Selecting this option tells TabWare to call the report program for each row selected on the search window. If you select 10 rows on the search window, the report program will be called 10 times, passing the arguments for each row.

Selecting this option tells TabWare to call the report program only once and pass the parameters as a list of values to the report program. If there are 10 rows selected, the report program will only be called once, but the values from all 10 selected rows are passed as a list to the report program.

Note: Run Report for each row and List of values are mutually exclusive. If both boxes are checked, the system automatically removes the check from the first box checked.

You can enter the parameters for TabWare to pass to the source file by clicking the dropdown button and selecting parameters from the provided list. The system does not insert quotes. If you need quotes around parameters, you must type them in.

Use this tab to grant access to the report. If access is not granted, the report will not be listed in the search window.

1.	Click the Setup icon on the TabWare Power Panel.
2.	Click the Customizing TabWare button on the Setup Power Panel.
3.	Click the Setup Options button in the Customizing TabWare window.
4.	Scroll down the Modules block and highlight Reports in the System Setup window.
5.	Click the Setup Options button to open the External Reports window.
6.	Enter values for the appropriate blocks.
7.	Click OK.

1.	Click the Security tab.
2.	From the User Group list, highlight the appropriate security groups. Only members of the selected groups will have the option to run this report.
3.	Click OK.