Page History
...
| Info |
|---|
These two features are supported by Report Manager FocalPoint, but are not supported by the Report Manager User Interface. |
| 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:
...
| Info |
|---|
To copy a Cross-Tier report, you should use the "Cross-Tier" string for both "source-apptier" and "destination-apptier" parameters. |
| Scroll Ignore | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
|
...