Skip to content

Report list

Utility of the function

A Report list allows you to create a set of forms in Excel format that can be exported, printed and sent by email. These forms contain relevant financial data extracted from the CCH Tagetik application database and can be shared within the company with users who do not have the Excel add-in installed. A Report list can also be inserted into ad hoc forms, empty sheets and Excel sheets not generated by CCH Tagetik.

Types of report list

There are two types of Report list:

  • Ad hoc: allows you to run a set of forms quickly. It is created on-the-fly and cannot be saved for future use.
  • Shared: once set, the settings are saved in a special form that allows you and other users to call up and rerun the same Report list subsequently. The Report list is run simultaneous to the form containing it. Some of Report list run parameters can be set to run when the form containing the Report list is run. This makes the Report list configurable. Forms containing shared Report lists may have a single template and do not support tab filters.

Creating a Report list

Report lists are created via the Action List Wizard window. This window can be opened from the CCH® Tagetik toolbar or the Design toolbar. It has the following distinctive features:

  • Ad hoc and shared Report lists can be created from the CCH® Tagetik toolbar.
  • From the Design toolbar, a shared report list can be created and saved on the open form or, alternatively, the settings of a Report list that is already present can be changed. In fact, there can be just one Report list in a form.

Note: a Report list’s Office colour palate must be consistent with the one used in the forms.

When the Report list is being created, it is also possible to customise the initially assigned default settings for each individual form.

Publication and saving

The system asks you to set the publication method and, if the Disk or portal publication method is chosen, to specify the type of file to be generated (Excel or PDF). If the user decides to generate separate files, by default the system will name the file with the code of the form being exported, i.e. ${Report.code}. If there is just one file, by default the system will name the file with the Report list code, i.e. ${ReportList.code}.

By default, the system saves the various files in the Tagetik subfolder in the user’s Documents folder, with the syntax ${getEnv()}\Documents\Tagetik\My Report List\${report.path}. The Tagetik folder is organised into subfolders corresponding to the form grouping structure.

The following functions are available to allow the publication path to be set:

  • getEnv() which returns the value of a client environment variable.

For example, ${getEnv("USERPROFILE")}\Documents returns the current user’s Documents folder.

  • report.path which returns the path of the report within the hierarchy. The nodes are indicated by the code and separated by '\'.

The system creates a single file or one file for each of the Report list’s forms, depending on the settings in use, and saves it in the specified folder. Those files are visible to everyone.

If the user has the rights to load documents to SharePoint, the generated files can be published in shared folders in a SharePoint portal using the syntax \server\share.

Role settings

Functionalities related to Report lists are only available to users who, in the role with which they are accessing the application database, have the following functions enabled:

  • 0002761 - Reporting .NET - Report List - Report List. If enabled in read/write mode, this allows the user to insert/edit/delete Report lists. If enabled in read only mode, this allows the user to access the wizard in view only mode on existing Report lists.
  • 0002762 - Reporting .NET - Report List - Output to Printer. This function allows you to print the output of a Report list.
  • 0002763 - Reporting .NET - Report List - Output to mail. This function allows you to send the output of a Report list via email.
  • 0002764 - Reporting .NET - Report List - Output to system file. This function allows you to save the output of a Report list on the disk.
  • 0002765 - Reporting .NET - Report List - Store Report list in Reports. This function allows you to save a Report list on a report to be used later.
  • 0003692 - Client. NET - Design - Report list - Password protection. This function allows you to set a security password.
  • 0004158 - Reporting - Generate a Form from the Form Navigation tree and save on a default End Point This function allows you to add the Report List tile to the home page.

Report Lists from the web

A dedicated tile for managing report lists can be added to the CCH Tagetik web interface (User Home page). Excel and PDF files required by report lists created by the Excel add-in can also be generated from this page. Depending on how the Report List has been configured from the Excel add-in, the system will generate a single Excel file or a single PDF with as many sheets as there are forms included in the Report List, or the same number of individual Excel or PDF files.