Page History
...
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 | ||||
---|---|---|---|---|
|
...
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 on page 55. |
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 on page 56. |
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
...