Publish a report
You can publish a report to a variety of different outputs using the Report Designer Preview As and Export functions in the File menu. However, if you have a Pentaho Server in production, you can publish directly to it instead. Additionally, you can link two reports together so that they share selected resources.
Instructions in this section assume that the Pentaho Server is accessible from the machine where you are using Report Designer. For information about configuring the server, see the section called Configure the Pentaho Server.
Publish to the Pentaho Server
If your administrator has enabled row-level security and the report you are publishing includes data from restricted data sources, it is possible that you may not have permission to run the selected report.
Procedure
Open the report you want to publish.
Click
The . Repository Login window appears.Enter your Pentaho Server connection information, then click OK.
If you do not know what should go in any field in this dialog box, contact your system administrator or IT manager.
Results
Edit Interactive Reports
You can use Report Designer to edit a report created with Pentaho Interactive Reports.
Before you begin
Perform the following steps to edit an Interactive Report:
Procedure
Copy the .prpti file from the solution in the Pentaho Server's pentaho-solutions/ directory to the workstation that has Report Designer.
If you have the Pentaho Server and Report Designer on the same machine, this step may not be necessary. However, you may need to create a copy of the .prpti file if you want to continue using the original in Interactive Reports.Copy the .xmi data source file from the solution in the Pentaho Server's pentaho-solutions/ directory to the workstation that has Report Designer.
Start Report Designer and open the .prpti file.
Edit the report's data source definition and replace the URL to the XMI file with the one you copied from the Pentaho Server.
Report Designer is unable to connect to XMI files on remote Pentaho Server machines. If you have the Pentaho Server on the same system with Report Designer, you can continue using that XMI file, but you still have to provide the local file system location in place of the server's URL.Establish a data source connection to the database referenced in the XMI file.
The XMI file defines a metadata model, which can be used as a data source so long as the database it provides metadata for is available to Report Designer.Copy the appropriate JDBC driver for the XMI database connection to the report-designer/lib/jdbc/ directory.
You may already have an appropriate database driver; if so, skip this step.
Results
Hide reports
Use this feature in instances in which you want to prevent users from viewing an unfinished report in the Pentaho User Console, but want to ensure that the report publishes successfully. You can also use this feature to make the report exclusively accessible from another report through linking.
Before you begin
Procedure
Go to the Structure pane and select Master Report.
Under Attributes, scroll down to the visible attribute.
Right-click the visible attribute and choose False.
Save and publish your report.
Results
Link reports
Just as you can create a hyperlink to a Web address, you can also create a hyperlink from one report to another, as long as the report you're linking to is published on the Pentaho Server.
Perform the following steps to link to a published report.
Procedure
Log into the Pentaho User Console.
Run the report you want to link to.
When the report is generated, copy its URL from your browser's address bar.
Start Report Designer and open the report you want to link from.
Follow the process of adding a hyperlink as explained in Create a Link to a Report on a Chart, using the URL you copied from the User Console as the Hyperlink-Target value.
Save and publish the report as you normally would.
Results
Link in tabs
You must define the parameters described in the table below to open a link to a report, Analyzer report, or action sequence in a Pentaho User Console tab.
::TabActive
Defaults to FALSE.
When set to TRUE, this parameter opens the target report in the Pentaho User Console report tab.
::TabName
Allows you to assign a name to the report tab either using static text, data field, parameter or a function.
For .prpt reports, the TabActive and TabName parameters can be found under System Parameters. You must define other file types under Custom.