Working with Paginated Reports

Some Web views and all Smart Client grid views include the ability to generate the view as a paginated report that is output to a Word DOCX file.These reports include headers, footers, page numbers, multi-level parent report bands, multiple data report bands, memos, and logos.

You are able to change the appearance of the report by changing the paper, table, or paragraph styles in Word. You can also save your own style sheets and apply them in one step to the generated report. Your System Integrator can change the default style sheet for the report by replacing the default style sheet with your own.

You can use paginated reports to:

Present information offline, such as when sharing information with those that do not have access to ARCHIBUS Smart Client or Web Central, or when performing reviews of equipment in the field.
Generate complete listings of your data that meet a certain restriction.
Archive information for a specific time period that serves as an easily-accessed reference of that data.
Edit your data in Excel or Word before presenting it.
Generate reports that include both text and drawings.

Paginated reports are in Word 2007 DOCX format, and can be viewed using Open Office or Word. There is a free viewer for those who do not have Word, and a free plug-in for those who are not running Word 2007.

Your Business Process Owner can create paginated reports and place them on the Process Navigator using Web Central's View Definition Wizard. These reports can include highlighted drawings that use a restriction to show one value highlighted (such as a drawing showing rooms assigned to a particular department), or thematically highlighted drawings that show many values color-coded to distinguish them (such as Rooms by Room Standard).

Note: To print drawing highlights, you must set your browser options to enable printing of background colors and images. See Printing Drawings

The following shows a report generated from the Rooms by Building and Floor view. This report includes two parent data bands that organize the data by building and by floor, and a child data band that shows the room data.

View sample paginated report.

Generating Reports

You can generate reports in the following ways:

From Web Central Views that can be output to Word include a DOCX button in the upper right corner. Once you load the view from the Process Navigator or Dashboard, click the DOCX button to generate the report.
From Smart Client. Open any grid view and run the Report command from the View group on the Ribbon toolbar.

These actions open a view that enables you to preview the status of the report generation and to view partial results. Viewing partial results enables you to ensure that the report is generating correctly. When the report generation is completed, you are able to click a link to load the report.

Previewing Report Generation and Accessing the Results

Paginated reports are a batch job for which you are able to view the progress of the job as it generates. For example, you can view the percentage of the job that has completed, and the estimated time remaining to complete the job.

The batch job gives access to previews of partial results if the report is very long. As each section of the report is completed, the report job adds the link for the partial result file to the list of files that the job has available. You can click the link to see the partial results. When all sections are completed, the report assembles all of the results into one file, and makes this file available in the Results section.

You can stop a job from the preview screen at any time until the job completes. See Stopping Jobs.

By default, you must click the link (the report title in the Result View or File section) to load the report. For smaller reports, such as a print out of a single work request or invoice, your System Integrator can change this so that the report automatically loads in a new browser tab when generation is complete.

Viewing a Single Job:

You can view the progress of the report generation for a single report from the Paginated Report View that is shown while the report generates.When you click the Paginated Report or DOC button, this action initiates the report generation, and provides information as the report is generated and a link to the finished report.

screen shot of the Paginated Report view that shows the progress of the report job and includes a Stop button

Viewing All Jobs

You can view the progress for all your jobs from the My Long Running Jobs screen accessed by clicking the My Jobs button from the Web Central main toolbar. These jobs can include reports and other actions that run as batch processes. You do not generate the reports from this view.

The first part of the screen lists the jobs, with the most recent jobs listed at the top. Information on completed jobs remains on the server for the duration of your user session.

Viewing Restrictions Used to Generate a Report

Many views include the ability to restrict data so that you can target the specific data you want to work with. To aid your data analysis, some paginated reports generated from a restricted view include a panel at the top of the report that provides details for the restriction used. This feature is not included in a view by default, but can be added. Search the System Management Help for the topic "Display Restrictions in Paginated Reports".

The restriction is printed as a formatted table placed at the top of the reports, as shown below:

Report Location

For Web Central. you should create a folder for paginated reports called "pagereports" anywhere in the schema subfolder. ARCHIBUS searches for the .AXVW file first in the application subfolder, and then in the rest of the schema subfolders. The "pagereports" subfolder ensures that ARCHIBUS loads the report as a paginated report.

For example, to load a report from the browser address bar, you must include the reports subfolder. A sample address would be:

http://localhost:8080/archibus/pagereports/ab-rm-by-fl-and-dp.axvw

About Report Deletion from the Server

Files, such as paginated reports, data transfer files, and data transfer log files (Comparison reports) remain on the server until they are deleted by the PerUserFileExpirations application parameter edited via the System Administration / ARCHIBUS System Administration / Business Process Owner / Edit Application Parameters view. The application parameter is:

AbSystemAdministration>perUserFileExpirations.

By default, files are deleted every 6 hours. Files are available in later Web Central sessions only if Web Central is not running on a clustered environment.

To save your reports to your local machine, see Saving Reports.

Note: If you generate the same report on the same day, the previous report is overwritten.

Saving Reports

If you want to archive a report or to work further with it, save the report to your local workstation. When you click the link to open the report, you are given the option to save the report. You can also save a report by right-clicking the report's link in the Result View or File section, and select Save Target As to save the file to your local workstation.