|Who:||Dependent on Role and permissions|
|Why:||When the Report portal has been used to run a report in the background or schedule it for a specific date/time, the report can be accessed from the report output area when it is ready for viewing.|
Before you begin
- NOTE: What you can see and do within the Report portal is dependent on your role, permissions and which Invoiced Entities and Workgroups you belong to.
|Report Portal: Overview & Search||View Report Properties & Permissions|
|Report Portal: View/Export Reports||Schedule a Report /Run in Background|
|Create Basic Reports||Import CSV Format Reports into Microsoft Excel|
- Open the Reports Portal.
The reports are stored in the folder you specified when defining the Parameters for the Scheduled or Background report.
- Navigate to the folder where the exported report is stored.
- Select “Report outputs” from the Report type drop down list.
The Report Output section opens with the list of available export reports displayed.
- Click the report that you wish to open.
The File Open window appears.
- Select whether to Open with or Save File, then click the OK button.
The report will open or be saved depending on the option you selected. In the example above the output format was specified as CSV. So this file would open in your default spreadsheet program (typically Microsoft Excel).
If you specified Email Notification when defining the parameters for the Scheduled or Background report, an email will be sent to the address you specified (N2) with the Subject header that you specified (N3).
- IMPORTANT: If your CSV format report has data with leading zeros (e.g. Account numbers) it is important to read the topic . Do not open the file as described above. Instead you need to import the CSV into your spreadsheet program.
- Open the notification email.
- NOTE: There is a hyperlink in the email to open the report. Before you click the hyperlink make sure the ConSol Report portal is open. The hyperlink will not work if ConSol Report portal is not open.
- Click the link in the email.
The File Open window appears. Save and open the file as described in the steps above.See topicfor steps to view the report once it is available.
- REMINDER: If your CSV format report has data with leading zeros (e.g. Account numbers) it is important to read the topic . Instead of opening it, you need to import the CSV into your spreadsheet program.