CreateCustomReportSchema
Generates a schema file for a custom report, enabling tailored reporting layouts and data export.
Stored Procedure-Specific Information
To execute this procedure, enter:EXEC CreateCustomReportSchema ReportName='MyReport', FileName='my_file.rsd'
Input
| Name | Type | Accepts Output Streams | Description |
| ReportName | String | False | The name of the custom report for which the schema file is being generated. |
| FileName | String | False | The name of the schema file to be created. If left blank, the output will be a base64-encoded binary file. If no file path is included, the file will be generated in the Location property (e.g., Location='C:\\Users\\User\\Desktop\\SageIntacct\\CustomSchemaDirectory\\'). |
| InteractiveType | String | False | Indicates whether the report was created using the Interactive Custom Report Writer. Defaults to false. |
| FileStream | String | True | The output stream where the generated schema will be written. This is a stream output. |
| ReportLocationEntity | String | False | Some custom reports require location entity arguments when running reports. This input parameter can be used to enter a valid location entity value. |
Result Set Columns
| Name | Type | Description |
| Result | String | Indicates whether the schema creation was successful or failed. |
| FileData | String | The generated schema file encoded in base64, returned only if FileName is not specified. |