Executing A Report
There are several ways to execute reports from both inside and outside of the BI Platform.
Ad-hoc Reports
You can create a new Ad-hoc Report by clicking on the New Report icon in the Toolbar or selecting it from the Menu bar. Ad-hoc Reports can be executed on the fly and/or be stored as a report into the Solution Repository). The Ad-hoc Report framework in the User Console have very limited functionality and is targeted only when a quick look is required. It will also require TraceTracker to create Metadata views (Predefined database access) to be used as data input to the reports. For more detailed and advanced reports, it’s recommended to use the Pentaho Report Designer (PRD).
Solution Repository Reports
Reports stored in the Solution Repository can be opened and executed by either opening the report from Open… icon in Toolbar or from the Menu Bar. The report will open in the Main page and the user simply modifies the Report parameters (if any) and clicks “Run Report”.
Executing reports from legacy application
The BI Platform supports executing reports from outside the BI Platform (ie another web application or legacy system). This is done by calling the BI Platforms’ Report Viewer. There are two ways to use the Report Viewer:
- Input mode: In input mode (typically included in an html iframe etc) the server will return a full html page with report parameter input form etc included. This is the same page as you will see when opening the report in the User Console => http://bi.tracetracker.com/pentaho/content/reporting/reportviewer/report.html?solution=client1&path=/reports&name=MyReport.prpt’
- Run mode: In run mode, you execute the report on the fly, submitting report parameters etc as part of the url => http://bi.tracetracker.com/pentaho/content/reporting?renderMode=REPORT&output-target=pageable/pdf&locale=en&solution=client1&path=/reports&name=MyReport.prpt&reportParam1=something’
NOTE: The server address http://bi.tracetracker.com is only for example purposes!
Have a look at the Report Viewer Docs for available parameters etc.