Report Wizard

Report Wizard is used to set up a Crystal Report to be used in Track. With the Report Wizard, user can perform the following tasks.

 

In order to access the Report Wizard, the profile rule that includes the ability to add a report must be assigned to the user. Contact Track Coordinator for more information.

 

During the new report setup, click Cancel to close the Report Wizard without saving the setup or the modifications.

Open the Report Wizard

  1. Hover a mouse pointer over the Settings menu link to display its drop-down menu.

  2. Slide a mouse pointer over the Utilities option to display its menu.

  3. Click Report Wizard to open the Report Wizard, displaying the Welcome to the Track Report Wizard screen.

 

Add a new report to Track

  1. From the Report Wizard, click Next to open the Report Actions screen.

      

  2. The Add a new report to Track option is selected by default. Click Next to open the Report Information screen.

  3. Enter a new report name into the Report Name text box.

  4. Enter its description into the Description text box.

  5. Click the Select File button, located next to the New Report File text box, to open the File Explorer.

  6. Locate and select a report file. The selected report's file path is displayed in the New Report File text box.

  7. Click Next to open the Control Select screen.

      

  8. Click one or more checkboxes to enable the data filters for the new report.

  9. Click Next to open the Data Selection Filter screen. Refer to Examples of Data Selection Filter Criteria for information and examples of data selections.

      

  10. Enter the table and field name of the report filter which are related to the enable checkboxes from previous screen. Ensure the table and field names are within the braces and are separated by a period.

  11. Type in an equal sign or an appropriate comparison symbol at the end of the brace.

  12. Select a placeholder option from the Insert Placeholder For drop-down list. The selected placeholder appears after the equal sign.
    For example, if the Enable Select of Organization checkbox is selected, then the Data Selection Filter should be {Personal.company_code}=%c

      

  13. Type in the word and after the first filter then repeat the steps to enter another table and field names.
    For example, if another data filter is added, then the Data Selection Filter should be {Personal.company_code}=%c and {Skll_Type_Assignments.contract_id}=%n

      

  14. Click Next to open the Reports Page Controls Text screen.

      

  15. Select a text box option for the new report setup from the Insert Placeholder For drop-down list.
    For example: Organization=?|

  16. Replace the question mark with a new text box name, such as Company.
    For example, Organization=Company|

      

  17. Click Next to open the Update Track Database screen.

      

  18. Click Next to open the Next Step screen.

      

  19. The Yes option is selected by default. Click Next to add or modify another report. The new report is saved and the Welcome to the Track Report Wizard screen opens. Otherwise, click the No button then click Next to open the Complete Track Report Wizard screen.

      

  20. Click Finish to save the new report and return to the Welcome to the Track Report Wizard screen. Refer to Report Categories in the Track Admin v6.3 user documentation to add the report to the appropriate report category.

 

Modify existing report in Track

  1. From the Report Wizard, click Next to open the Report Actions screen.

  2. Select the Change an existing report in Track button.

  3. Click Next to open the Select Report screen.

  4. Select a report from the drop-down list.

  5. Click Next to open the Report Information screen, displaying the selected report information.

  6. Make changes to the report name, description, and/or select a report file.

  7. Click Next to open the Control Selection screen.

  8. Select or deselect the checkboxes to enable or disable the data filters for the selected report.

  9. Click Next to open the Data Selection Filter screen.

  10. Edit the table and field names according to the selected enable data filters.

  11. Click Next to open the Report Page Controls Text screen.

  12. Make the changes accordingly.

  13. Click Next to open the Update Track Database screen.

  14. Click Next to open the Next Step screen.

  15. The Yes option is selected by default. Click Next to add or modify another report. The modifications of the selected report are saved and the Welcome to the Track Report Wizard screen opens.  Otherwise, click the No button then click Next to open the Complete Track Report Wizard screen.

  16. Click Finish to save the modifications and return to the Welcome to the Track Report Wizard screen.

 

Remove a report from Track

Once the selected report is removed from Track and Track Admin, the Crystal Report still exists at the original saved location.

  1. From the Report Wizard, click Next to open the Report Actions screen.

  2. Select the Remove a report from Track button.

  3. Click Next to open the Select Report screen.

  4. Select a report from the drop-down list.

  5. Click Next to open the Report Information screen.

  6. Click Next to open the Update Track Database screen.

  7. Click Next to open the Next Step screen.

  8. The Yes option is selected by default. Click Next to add or modify another report. The selected report is deleted and the Welcome to the Track Report Wizard screen opens. Otherwise, click the No button then click Next to open the Complete Track Report Wizard screen.

  9. Click Finish to delete the selected report and return to the Welcome to the Track Report Wizard screen.

 

Related Topics

Report Tables and Columns

Selection Controls

Data Selection Filters