Previous Topic
Creating Reports
You can use URL to create reports directly. When creating a web report via URL, you can choose whether to take the traditional wizard way or quick start way of Web Report Studio (see Web Report Studio for details about the differences between the two ways).
Below is a list of the sections covered in this topic:
- Creating a Page Report
- Creating a Web Report in the Traditional Wizard Way
- Creating a Web Report in the Quick Start Way
Creating a Page Report
URL entry: /dhtmljsp/newreport.jsp
Properties:
- jrs.catalog
The catalog name with full path. - FromServer
Optional. The value is true and it cannot be changed. - Authentication properties (optional)
- jrs.ds_name
Optional. The data source name in the specified catalog. If the data source is given (not null), only the business views in the data source will be shown. - jrs.query_name
Optional. The query name in the specified catalog. If the query name is given (not null), the step of selecting business views in the report wizard will be skipped and will not be shown as a step. The business view based on the query will be used, and the jrs.cube_name property should be ignored. - jrs.cube_name
Optional. The business view name in the specified catalog, that is the Name property value of the business view in the Catalog Manager of Logi JReport Designer. If the business view name is given (not null), the step of selecting business views in the report wizard will be skipped and will not be shown as a step. If there are some business views with the same name, one of them will be used. - jrs.param$ (optional)
- jrs.param_page (optional)
Examples:
http://localhost:8888/dhtmljsp/newreport.jsp?FromServer=true&jrs.catalog=/SampleReports/SampleReports.cathttp://localhost:8888/dhtmljsp/newreport.jsp?FromServer=true&jrs.catalog=%2fSampleReports%2fSampleReports.cat
You will then be directed to the New Page Report dialog which leads you to create a page report in the specified catalog.
Creating a Web Report in the Traditional Wizard Way
URL entry: webos/app/webstudio/run.jsp?jrd_wizard=1&
The properties are encapsulated as JSON (JavaScript Object Notation) objects:
- jrd_catalog={
"name":"xxx", // The catalog name with full path.
"ver":-1, // Optional. The catalog version. -1 means the latest version. Default value is "-1".
"real":false, // Optional. If you use absolute resource path, you need to add the property "real":true for the path. Default value is "false".
"dsName":"xxx", // Optional. The data source name in the catalog. If the data source is given (not null), only the business views in this data source are shown in the report wizard.
"QueryName":"xxx", // Optional. The query name in the catalog. If the query name is given (not null), the selecting business view drop-down list in the report wizard will be disabled. The business view based on the query will be used, and the BVName property below should be ignored.
"BVName":"xxx", // Optional. The business view name in the catalog, that is the display name in the Catalog Browser of Logi JReport Designer. If the business view name is given (not null), the selecting business view drop-down list in the report wizard will be disabled. If there are some business views with the same name, one of them will be used.
"param_page":true // Optional. Value: true/false. Default value: true. It controls whether to show the parameter dialog displayed during report running for specifying parameter values that are not provided by jrd.param$ in the URL. The Parameters panel in Web Report Studio is not affected by this property, because the dialog is to display all the parameters of the report. When it is true and the value of a middle level cascading parameter (including old style cascading parameter) is provided, the parameter dialog only shows the lower level parameters. When it is false, no parameter dialog will pop up and the given parameter values and the default values of the other parameters will be used to run the report.
}
- jrd_param$={
"p1":"value1", // p1 is parameter name, and value1 is p1's value.
"p2":["value1","value2","value3"] // For multiple values.
} - Authentication properties: jrs.authorization, jrs.auth_uid, and jrs.auth_pwd // Optional.
Examples:
http://localhost:8888/webos/app/webstudio/run.jsp?jrd_wizard=1&jrd_catalog={"name":"/SampleReports/SampleReports.cat","ver":-1}- Real path example:
http://localhost:8888/webos/app/webstudio/run.jsp?jrd_wizard=1&jrd_catalog={"name":"E:\\JReport\\Server\\jreports\\SampleReports\\SampleReports.cat","real":true}
You will then be directed to the Web Report Wizard which guides you through creating a web report in the specified catalog.
Creating a Web Report in the Quick Start Way
URL entry: webos/app/webstudio/run.jsp?
The properties are encapsulated as JSON (JavaScript Object Notation) objects:
- jrd_studio_mode // Specifies which Web Report Studio mode is available.
- jrd_catalog // Optional. Specifies the catalog path or the catalog name with full path.
Examples:
http://localhost:8888/webos/app/webstudio/run.jsp?jrd_studio_mode=edithttp://localhost:8888/webos/app/webstudio/run.jsp?jrd_studio_mode=edit&jrd_catalog={"name":"/"}http://localhost:8888/webos/app/webstudio/run.jsp?jrd_studio_mode=edit&jrd_catalog={"name":"/SampleReports/SampleReports.cat"}
You will then be prompted to select data fields from a business view and a table report will be created based on the fields. However when Web Report Studio is in the traditional way, a blank web report will be created instead.