NoteThis version of the .NET API documentation is deprecated. A new version can be found at https://www.exagoaccess.com/api-docs/.
Filter Class
The Filter class is used to modify filters at runtime. New Filter objects should be created by the NewFilter method of ReportFilterCollection.
Properties
A Filter object has the following properties:
- AndOrWithNext – Value indicates to use an ‘and’ or ‘or’ with the next filter added.
- Uses the enumeration wrFilterAndOrWithNext: (And, Or).
- DbName - The fully qualified database (not mnemonic) name of the filter (i.e. ‘vw_optionee.Last Name’).
- GroupWithNext – Boolean indicating if the filter should be grouped with the next filter.
- Operator – The comparison operator, using the enumeration wrFilterOperator
- Prompt – Boolean indicating whether to prompt user for the value of this filter at time of execution.
- Value – value of the filter if it uses an Operator that only takes a single value. Dates must be in the following format YYYY-MM-DD.
- DataValues – values of the filter using an Operator that takes multiple values, such as One Of or Between.
Methods
A Filter object has no available methods.
Report Class
The Report class allows Advanced and Express Reports to be executed directly from the host application. This class does not need to be instantiated, it should be retrieved using methods defined in ReportObjectFactory. The Report class is derived from the ReportObject abstract class.
Properties
A Report object has the following properties:
- Filters — Filters collection. See ReportFilterCollection class below.
- Sorts — Sorts collection. See ReportSortCollection class below.
- ShowStatus — Boolean value. This value indicates whether to show status window during execution. Default is True.
Methods
A Report Object has the following methods:
GetExecuteHtml()
Description |
Executes the report and returns HTML. |
Remarks |
The raw HTML can be used to populate a container in the host application. Does not include Exago paging HTML viewer. |
GetExecuteData()
Description |
Executes the report and returns data as a byte array. |
Remarks |
Any export type can be executed in this way; use the ExportType property prior to calling this method to set the export type. |
GetExecuteSql()
Description |
Returns all SQL statements that would be generated as a result of executing the report. |
Remarks |
There may be more than one SQL statement generated if the report uses more than one SQL data source. |
ReportFilterCollection Class
This collection should not be instantiated; there is a single ReportFilterCollection object that is accessed through the Filters property of the Report object.
Methods
The Filters property of a Report object has one available method:
NewFilter()
Description |
Returns a new Filter object and adds it to the collection. |
Remarks |
The returned Filter object needs to have all of its properties filled or an error will occur. |
ReportSortCollection Class
This collection should not be instantiated; there is a single ReportSortCollection object that is accessed through the Sorts property of the Report object.
Methods
The Sorts property of a Report object has one available method:
NewSort()
Description |
Returns a new Sort object and adds it to the collection. |
Remarks |
The returned Sort object needs to have all of its properties filled or an error will occur. |
Sort Class
The Sort class is used to modify sorts at runtime. New Sort objects should be created by the NewSort method of ReportSortCollection.
Properties
A Sort object has the following properties:
- SortText – The fully qualified database (not mnemonic) name of the sort (i.e. ‘vw_optionee.Last Name’).
- Direction – Direction of the sort.
- Uses the enumeration wrSortDirection (Ascending, Descending)
Methods
A Sort object has no available methods.
ReportProperties Class v2020.1.5
A ReportProperties object allows retrieving report properties programmatically (e.g. report entities) without needing to create a WebReports.Api.Common.ReportObject, which will fail for invalid reports and is heavier than necessary.
It is intended for use with the IStorageManagement interface in custom Storage Management implementations.
Properties
A ReportProperties object has the following properties:
Name | Type | Writable | Description |
---|---|---|---|
AssociatedReports | List<Guid> | no | A list of content_ids for each report that is associated with this one. Reports become associated with others when they are components in a Composite Report such as Chained Report or Dashboard, or if an Advanced Report contains linked reports.
|
EntityIds | IEnumerable<String> | no | An enumerable list of strings representing the data object IDs on the report. (e.g. Customers_0) For ExpressViews, the column name will be included. (e.g. Categories_0.CategoryName) For Dashboard visualizations, the column name or the formula on the column will be included (e.g. ={OrderDetails_0.Quantity}*{OrderDetails_0.UnitPrice}) |
ReportType | wrReportType | no | the type of report that this item is |
ReportId | GUID | no | the content ID for this report |
ReportDescription | string | no | the description field of this report |
ReportTreeShortcut | TreeShortcut | no | the description field of this report |
UseCacheExecution | boolean | no | true if this report uses Execution Caching, or false if it does not |
AllowOutputHtml | boolean | no | true if this report will run in the Report Viewer, or false if it does not (exporting allowed only) |
AllowOutputPdf | boolean | no | true if this report can be exported as PDF, or false if not |
AllowOutputCsv | boolean | no | true if this report can be exported as CSV, or false if not |
AllowOutputExcel | boolean | no | true if this report can be exported as a Microsoft Excel workbook, or false if not |
AllowOutputRtf | boolean | no | true if this report can be exported as RTF, or false if not |
DefaultExportType | wrExportType | no | the report's default export type |
DefaultExportFlag | ExportFlag | no | the value of this report's default export flag from the Storage Management database |
Methods
The ReportProperties class has no methods.