Page History
...
Info |
---|
These two features are supported by Report Manager FocalPoint, but are not supported by the Report Manager User Interface. |
Anchor | ||||
---|---|---|---|---|
|
...
When you complete the filter condition settings for all the new properties, execute the customized report and then save it. Report Manager creates two files, the report's Microsoft Excel file and .xml file. See Creating customized reports on page 23.
Anchor | ||||
---|---|---|---|---|
|
...
The following table describes the properties that can be added to the Report Parameters table.
Table A- 1 Additional properties that can be added to the Report Parameters table
Column | Description |
---|---|
FSRA_ID | Specifies the property identifier. Set a unique and consecutive number, starting from 100000 (enables you to easily distinguish between the new properties you added and the existing pre-defined properties). |
FSRA_NAME | Specifies a unique property name. |
FSRA_IS_DISPLAYABLE | Specifies whether or not to display the property through the Properties dialog box. Valid values are:
Set this value to 'T.' |
FSRA_IS_CONVERTIBLE | Specifies whether or not to convert the % (wildcard sign) to * in the Properties dialog box. The valid values include:
If the property value contains wildcards, set this value to 'T.' |
FSRA_DEFAULT_VALUE | Specifies the default value of the property. Set this value to NULL, since you will later define the default value when you associate the new property to the customized report. |
FSRA_PROMPT_TEXT | Specifies the text that is displayed with the property box in the Properties dialog box. Enter a description. |
FSRA_TAB_ID | Specifies the tab ID - of the report Properties dialog box - in which this property is displayed. Set to one of the following valid values according to your property:
|
FSRA_INDEX | Specifies the property index in the tab, indicating its order. |
If you use a database tool such as Microsoft SQL Server Enterprise Manager, you can use the following INSERT statement as an example, to add a new parameter to the PS_FSRA_REPORT_PARAMETERS
table.INSERT INTO PS_FSRA_REPORT_PARAMETERS
(FSRA_ID, FSRA_NAME, FSRA_IS_DISPLAYABLE,
FSRA_IS_CONVERTABLE, FSRA_DEFAULT_VALUE,
FSRA_PROMPT_TEXT, FSRA_TAB_ID, FSRA_INDEX)
VALUES (100000, 'ProgramFilter', 'T', 'T', NULL, '
Analyze only the following programs:', 'F', 10)
...
The following table describes the parameters values which can be customized.
Table A- 2 Parameter Values
Column | Description |
---|---|
FSPV_FSRA_ID | Specifies the property identifier. Set the number as you specified in the See About adding a new property to the Report Parameters table |
. | |
FSPV_FSPG_ID | Specifies the group identifier. Set to NULL. |
FSPV_FSRP_ID | Specifies the report identifier. Set the number that you found in the Reports Table. See About locating the report identifier |
. | |
FSPV_CTX_ID | Specifies the context identifier. To find the context identifier of the new property, run the following query:
Where |
. The query result includes the required value for | |
FSPV_VALUE | Specifies the default value of the new property. |
FSPV_PROMPT_TEXT | Specifies the text that is displayed with the property box in the Properties dialog box. You can set to NULL to apply the text that you already set in the |
. |
If you use a database tool such as Microsoft SQL Server Enterprise Manager, you can use the following example to add a new parameter to the PS_FSPV_PARAMETER_VALUES
Table:
...
When you create a Customized report, Report Manager creates two files: a Microsoft Excel file that contains the report details, and a .xml file that contains the report definition. This procedure provides step-by-step instructions for updating the definitions of the query tag in the .xml file. See About creating a customized report on page 57 and About adding a new property to the Report Parameters table on page 55.
The following example shows the query tag before modification:
...
After completing report settings, execute the customized report and then save it. Report Manager creates two files, the report's Microsoft Excel file and .xml file. See Creating customized reports on page 23.
Modifying the .xml file with the report
...
Info |
---|
To copy a Cross-Tier report, you should use the "Cross-Tier" string for both "source-apptier" and "destination-apptier" parameters. |
...