#DatabaseAdHocConfig
##Properties
| Datatype | Property name | Property description | Default Value |
|---|---|---|---|
| String | NewReportSetID | Gets a new unique ID that can be used to identify a Izenda.AdHoc.ReportSet when a new report is created. | 686fdc07-5b88-4d51-9740-db34346df857 |
| Driver | SavedReportsDriver | Gets or sets the Izenda.AdHoc.Database.Driver that will be used to store reports with. This can point to a different database than the one used as the primary reporting data source. | null |
| String | SavedReportsTable | Name of the database table where the reports are stored. | IzendaAdHocReports |
##Methods
###ArchiveReportOutput(Izenda.AdHoc.ReportSet,System.String[],System.String,System.Byte[]) Represents a method that can be used to save the Izenda.AdHoc.ReportSet to an archive location for backup purposes when the report is being exported.
Parameters:
- Izenda.AdHoc.ReportSet reportSet - The Izenda.AdHoc.ReportSet that contains the collection of Izenda.AdHoc.Report objects that are being exported.
- System.String[] emails - The collection of recipient addresses for the exported report.
- System.String extension - The Windows extension of the generated export.
- System.Byte[] data - The serialized data of the exported report object.
###ConfigureSettings() Represents a method that can be used to load global application settings. This method is run exactly once when the first request is made to the reporting pages. (deprecated)
###CustomizeChart(System.Object) Represents a method that can be used to modify a chart before it is rendered to the screen.
Parameters:
- System.Object chart - The chart object that was produced on the server. The Izenda.AdHoc.ChartingEngine being used determines what kind of object the chart can be cast to.
###CustomizeChart(System.Object,System.Collections.Hashtable) Represents a method that can be used to modify a chart before it is rendered to the screen.
Parameters:
- System.Object chart - The chart object that was produced on the server. The Izenda.AdHoc.ChartingEngine being used determines what kind of object the chart can be cast to.
- System.Collections.Hashtable properties - A list of properties that the chart contains and will be applied to the chart after customization. Some chart types do not have properties.
###CustomizeDundasChart(System.Object,System.Collections.Hashtable,System.Type) Represents a method that can be used to modify a Dundas chart before it is rendered to the screen.
Parameters:
- System.Object chart - The chart object that was produced on the server. The chart will always be an Izenda.AdHoc.DundasChart.
- System.Collections.Hashtable properties - A list of properties that the chart contains and will be applied to the chart after customization. Some chart types do not have properties.
- System.Type chartType - The System.Type representation of the type of chart being created.
###CustomizeGuage(System.Double,System.Double,System.Double,System.String,System.Drawing.Image) Represents a method that can be used to modify a gauge report before it is rendered to the screen.
Parameters:
- System.Double value - The gauge control's numeric value represented as a System.Double.
- System.Double min - The minimum value to display on the gauge control represented as a System.Double.
- System.Double max - The maximum value to display on the gauge control represented as a System.Double.
- System.String name - The System.String representation of the name that the gauge was given based on the type of gauge being used.
- System.Drawing.Image guageImage - The System.Drawing.Image for the gauge that is being used.
###DeleteReportSet(Izenda.AdHoc.ReportInfo) Deletes a report from the database with the specified parameters.
Parameters:
- Izenda.AdHoc.ReportInfo reportInfo - The Izenda.AdHoc.ReportInfo object containing information about the report to delete.
###DeleteReportSet(System.String) Represents a method to delete the report with the specified name and the current user's tenant ID from the location where reports are stored. This method must be overridden.
Parameters:
- System.String reportName - The name of the report to delete.
###DeleteTemplate(System.String) Deletes a form attached to a reporte with the specified name from the databas.
Parameters:
- System.String fullReportSetName
###DeleteThumbnail(Izenda.AdHoc.ReportInfo) Deletes the thumbnail image associated with the specified report from the database.
Parameters:
- Izenda.AdHoc.ReportInfo reportInfo - The Izenda.AdHoc.ReportInfo object that contains the information required to delete the thumbnail.
###Equals(System.Object) Determines whether the specified System.Object is equal to the current System.Object.
Parameters:
- System.Object obj - The System.Object to compare with the current System.Object.
Returns:
true if the specified System.Object is equal to the current System.Object; otherwise, false.
###FilteredListReports() Gets a list of Izenda.AdHoc.ReportInfo objects that are available to the current user based on the factors of report availability and privileges.
###FilteredListReportsDictionary() Gets a list of Izenda.AdHoc.ReportInfo objects for all loadable reports found that have been modified since the last time this method was called.
###GetAutoRefreshIntervals() Represents a method that gets the time the report viewer will wait before auto-refreshing the results on the page.
Returns:
A System.Collections.Generic.Dictionary of key value pairs that determine how long the report viewer will wait before auto-refreshing itself.
###GetCustomFooter(Izenda.AdHoc.ReportSet,Izenda.AdHoc.ReportSetResults,System.Boolean,out System.String) Represents a method that is used to add a footer to the generated Izenda.AdHoc.ReportSet that is being executed on the server. This method must be overridden.
Parameters:
- Izenda.AdHoc.ReportSet reportSet - The source Izenda.AdHoc.ReportSet that is being executed on the server.
- Izenda.AdHoc.ReportSetResults results - The Izenda.AdHoc.ReportSetResults that contains the results of executing the report.
- System.Boolean print - Determines whether this report is being exported or run normally.
- out System.String customFooter - The System.String HTML footer that will be added to the report output when it is displayed.
###GetCustomHeader(Izenda.AdHoc.ReportSet,Izenda.AdHoc.ReportSetResults,System.Boolean,out System.String) Represents a method that is used to add a header to the generated Izenda.AdHoc.ReportSet that is being executed on the server. This method must be overridden.
Parameters:
- Izenda.AdHoc.ReportSet reportSet - The source Izenda.AdHoc.ReportSet that is being executed on the server.
- Izenda.AdHoc.ReportSetResults results - The Izenda.AdHoc.ReportSetResults that contains the results of executing the report.
- System.Boolean print - Determines whether this report is being exported or run normally.
- out System.String customHeader - The System.String HTML header that will be added to the report output when it is displayed.
###GetHashCode() Serves as a hash function for a particular type.
Returns:
A hash code for the current System.Object.
###GetOperatorList(Izenda.AdHoc.Database.SqlType,System.Boolean) Represents a method that gets the list of different operators that can be used for the specified Izenda.AdHoc.Database.SqlType.
Parameters:
- Izenda.AdHoc.Database.SqlType type - The Izenda.AdHoc.Database.SqlType datatype to check.
- System.Boolean isStoredProcedureUsed - Whether the results should check for stored procedures. Certain valid operators only work conditionally with stored procedures.
Returns:
The System.String array of the different operators that can be applied to the Izenda.AdHoc.Database.SqlType.
###GetOperatorList(Izenda.AdHoc.Database.SqlType,System.Boolean,System.String) Represents a method that gets the list of different operators that can be used for the specified Izenda.AdHoc.Database.SqlType and the column name.
Parameters:
- Izenda.AdHoc.Database.SqlType type - The Izenda.AdHoc.Database.SqlType datatype to check.
- System.Boolean isStoredProcedureUsed - Whether the results should check for stored procedures. Certain valid operators only work conditionally with stored procedures.
- System.String columnFullName - The System.String representation of the name of the column that the operator list is for.
Returns:
The System.String array of the operators that can be applied.
###GetPossibleValuesAsTree(System.String,System.Int32,Izenda.AdHoc.ReportSet) Represents a method that gets the list of values for an equals(select) operator list in a tree structure, with the root node being on top and each subsequent node being a child of its parent.
Parameters:
- System.String fullColumnName - The fully-qualified name of the column with schema and table information.
- System.Int32 maxRowCount - The maximum number of items that the resulting list and sub-lists will contain.
- Izenda.AdHoc.ReportSet rs - The Izenda.AdHoc.ReportSet that the column is associated with.
Returns:
A System.Collections.Generic.IList containing the structure of the tree that can be used for the equals(select) operator.
###GetReportIDByName(System.String) Represents a method that returns the report ID given the corresponding report name.
Parameters:
- System.String fullReportName - The System.String representation of the name of the report.
Returns:
The System.String representation of the unique identifier for the report.
###GetReportNameById(System.String) Represents a method that returns the report name given the corresponding report ID.
Parameters:
- System.String id - The System.String representation of the unique identifier for the report.
Returns:
The System.String representation of the name of the report.
###GetReports() Gets a list of all loadable Izenda.AdHoc.ReportSet objects from the location where reports are stored.
###GetRichEditorContent(System.String) Represents a method that gets the contents of the forms editor when the forms editor is opened. The result is inserted into the forms editor.
Parameters:
- System.String requestData - The System.String representation of the HTML content of the forms editor.
Returns:
The System.String HTML representation of the form that will be output to the content window.
###GetType() Gets the System.Type of the current instance.
Returns:
The System.Type instance that represents the exact runtime type of the current instance.
###InvalidateFilteredCaches() Clears the application's in-memory cache of all reports.
###IsArchiveTableExists() Determines whether the database table used to store and archive reports is able to be found on the database.
Returns:
True when the database table to store and archive reports is found.
###IsFieldAllowedInFilters(System.String,System.String,System.String) Represents a method that checks whether a certain database column can be selected for a filter.
Parameters:
- System.String fullColumnName - The fully-qualified column name with schema and table information.
- System.String tableName - The name of the table the column is associated with.
- System.String columnName - The name of the column to check for.
Returns:
True when the column is allowed as a filter. Otherwise, false.
###ListReports() Gets a list of all reports since the last time the cache was updated or all reports if caching is not on.
Returns:
A collection of Izenda.AdHoc.ReportInfo objects that contain the information about the obtained reports.
###LoadFilteredReportSet(System.String) Loads a report from the storage media using current TenantID. Returns null if the report is not loadable.
Parameters:
- System.String reportName - Name of the report.
###LoadReportSet(Izenda.AdHoc.ReportInfo,Izenda.AdHoc.Database.DatabaseSchema) Loads a report's definition from the database using the specified parameters.
Parameters:
- Izenda.AdHoc.ReportInfo reportInfo - The Izenda.AdHoc.ReportInfo object containing information about the report to load.
- Izenda.AdHoc.Database.DatabaseSchema schema - The Izenda.AdHoc.Database.DatabaseSchema object that contains the schema information that the report metadata corresponds to.
###LoadReportSet(System.String) Represents a method that loads the report with the specified name and the current user's tenant ID from the location where reports are stored. This method must be overridden.
Parameters:
- System.String reportName - The name of the report to load.
###LoadTemplate(System.String)
Parameters:
- System.String fullReportSetName
###LoadThumbnail(Izenda.AdHoc.ReportInfo) Represents a method that loads the thumbnail image associated with the specified report from the database.
Parameters:
- Izenda.AdHoc.ReportInfo reportInfo - The Izenda.AdHoc.ReportInfo object that contains the information required to load the thumbnail.
Returns:
The raw System.Byte array that represents the thumbnail image loaded.
###PerformCustomRendering(Izenda.AdHoc.ReportSet,Izenda.AdHoc.ReportSetResults,System.Boolean,out System.String) Represents a method used to replace the regular report results with the results of an HTML form. (deprecated)
Parameters:
- Izenda.AdHoc.ReportSet reportSet - The source Izenda.AdHoc.ReportSet that is being executed on the server.
- Izenda.AdHoc.ReportSetResults results - The Izenda.AdHoc.ReportSetResults that contains the results of executing the report.
- System.Boolean print - Determines whether this report is being exported or run normally.
- out System.String resultFromCustomRenderer - The System.String representation of the HTML that comprises the content of the form.
Returns:
True when the form should be rendered and false when it should use the normal rendering method.
###PerformCustomRendering(Izenda.AdHoc.Report,Izenda.AdHoc.Database.ReportQueryExecuteResult,System.String,System.Boolean,out System.String) Represents a method used to replace the regular report results with the results of an HTML form.
Parameters:
- Izenda.AdHoc.Report report - The source Izenda.AdHoc.ReportSet that is being executed on the server.
- Izenda.AdHoc.Database.ReportQueryExecuteResult results - The Izenda.AdHoc.ReportSetResults that contains the results of executing the report.
- System.String appliedFilters - The System.String XML representation of the filters that will be applied to the report.
- System.Boolean print - Determines whether this report is being exported or run normally.
- out System.String resultFromCustomRenderer - The System.String representation of the HTML that comprises the content of the form.
Returns:
True when the form should be rendered and false when it should use the normal rendering method.
###PerformCustomRendering(Izenda.AdHoc.Report,Izenda.AdHoc.Database.ReportQueryExecuteResult,System.Boolean,out System.String) Represents a method used to replace the regular report results with the results of an HTML form. (deprecated)
Parameters:
- Izenda.AdHoc.Report report - The source Izenda.AdHoc.ReportSet that is being executed on the server.
- Izenda.AdHoc.Database.ReportQueryExecuteResult results - The AdHoc.ReportQueryExecuteResults that contains the results of executing the report.
- System.Boolean print - Determines whether this report is being exported or run normally.
- out System.String resultFromCustomRenderer - The System.String representation of the HTML that comprises the content of the form.
Returns:
True when the form should be rendered and false when it should use the normal rendering method.
###PerformCustomRendering(System.String) Represents a method used to replace the regular report results with the results of an HTML form.
Parameters:
- System.String initialHtml - The System.String representation of the HTML results of the report.
###PostExecuteReportSet(Izenda.AdHoc.ReportSet) Represents a method that allows operations to be performed after executing a Izenda.AdHoc.ReportSet and before displaying it to the screen.
Parameters:
- Izenda.AdHoc.ReportSet reportSet - The Izenda.AdHoc.ReportSet that was executed on the server.
###PostLoadReportSet(System.String,Izenda.AdHoc.ReportSet) Represents a method that allows operations to be performed after loading the specified report. This method must be overridden.
Parameters:
- System.String name - The System.String representation of the report name.
- Izenda.AdHoc.ReportSet reportSet - The source Izenda.AdHoc.ReportSet that was generated after loading it.
###PostLogin() Represents a method that can be used to load user-specific application settings. This method is run after the user logs in from your integrated login page. (deprecated)
###PostProcessEqualsSelectList(Izenda.AdHoc.Database.Column,System.Collections.Generic.List<System.String>,System.Collections.Generic.List<System.String>) Represents a method that can be used to edit the values of the equals(select) filter after the results have been obtained.
Parameters:
- Izenda.AdHoc.Database.Column column - The Izenda.AdHoc.Database.Column that the values will be obtained for.
- System.Collections.Generic.List<System.String> labels - The System.Collections.Generic.List of labels that will be used as the display text for the resulting dropdown list.
- System.Collections.Generic.List<System.String> values - The System.Collections.Generic.List of values that will be used as the underlying data for the resulting dropdown list.
###PostProcessHighChartLabels(Izenda.AdHoc.Report,System.String[])
Parameters:
- Izenda.AdHoc.Report report
- System.String[] labels
###PostSaveReportSet(System.String,Izenda.AdHoc.ReportSet) Represents a method that allows the Izenda.AdHoc.ReportSet to be processed after it is saved.(deprecated)
Parameters:
- System.String name - The System.String representation of the report name.
- Izenda.AdHoc.ReportSet reportSet - The Izenda.AdHoc.ReportSet that is going to be saved.
###PreExecuteReportSet(Izenda.AdHoc.ReportSet) Represents a method that allows operations to be performed before executing a Izenda.AdHoc.ReportSet and displaying it to the screen. This method must be overridden.
Parameters:
- Izenda.AdHoc.ReportSet reportSet - The source Izenda.AdHoc.ReportSet that was generated prior to executing it.
###PreLoadReportSet(System.String) Represents a method that allows operations to be performed before loading the specified report.
Parameters:
- System.String name - The System.String representation of the report name.
###PreSaveReportSet(System.String,Izenda.AdHoc.ReportSet) Represents a method that allows the Izenda.AdHoc.ReportSet to be processed before it goes to the server.(deprecated)
Parameters:
- System.String name - The System.String representation of the report name.
- Izenda.AdHoc.ReportSet reportSet - The Izenda.AdHoc.ReportSet that is going to be saved.
###ProcessDataRow(System.Data.DataRow,Izenda.AdHoc.Report,System.Boolean) Post-process DataRow for the streamed output (Bulk CSV). Use ProcessDataSet method to post-process data for other output types.
Parameters:
- System.Data.DataRow row
- Izenda.AdHoc.Report report
- System.Boolean isTotals
###ProcessDataSet(System.Data.DataSet,System.String) Represents a method that can be used to change the results from executing a query on the database via the System.Data.DataSet. This method must be overridden.
Parameters:
- System.Data.DataSet ds - The System.Data.DataSet that was obtained from executing the query on the database.
- System.String reportPart - The System.String representation of the part of the report that the query is running on, if any.
###ProcessDataSet(System.Data.DataSet) Represents a method that can be used to change the results from executing a query on the database via the System.Data.DataSet. This method must be overridden.(deprecated)
Parameters:
- System.Data.DataSet ds - The System.Data.DataSet that was obtained from executing the query on the database.
###ProcessEqualsSelectList(Izenda.AdHoc.Database.Column) Represents a method that gets the possible values of an equals(select) filter for the specified column. This method must be overridden.
Parameters:
- Izenda.AdHoc.Database.Column column - The Izenda.AdHoc.Database.Column that the values will be obtained for.
Returns:
A System.String array of the possible values that the column can have.
###ProcessFriendlyException(System.Exception) Represents a method that produces more user-friendly output when a report has errors than the usual method would.
Parameters:
- System.Exception exception - The System.Exception that was produced when the report being run encountered a non-trivial problem.
Returns:
A System.Web.UI.Control that contains the text of the exception for use on the reporting page.
###SaveReportRDL(System.String)
Parameters:
- System.String reportName
###SaveReportSet(Izenda.AdHoc.ReportInfo,Izenda.AdHoc.ReportSet) Saves a report to the database using the specified parameters.
Parameters:
- Izenda.AdHoc.ReportInfo reportInfo - The Izenda.AdHoc.ReportInfo object containing information about the report to save.
- Izenda.AdHoc.ReportSet reportSet - The Izenda.AdHoc.ReportSet definition of the report that will be saved.
###SaveReportSet(System.String,Izenda.AdHoc.ReportSet) Represents a method that saves the specified report and the current user's tenant ID to the location where reports are stored.
Parameters:
- System.String reportName - The name of the report being saved.
- Izenda.AdHoc.ReportSet reportSet - The Izenda.AdHoc.ReportSet object containing the report definition.
###SaveTemplate(System.String,System.String) Saves the form to the database using the specified name.
Parameters:
- System.String fullReportSetName
- System.String template
###SaveThumbnail(Izenda.AdHoc.ReportInfo,System.Drawing.Bitmap) Represents a method that stores a thumbnail image associated with the specified report to the database.
Parameters:
- Izenda.AdHoc.ReportInfo reportInfo - The Izenda.AdHoc.ReportInfo object that contains the information required to save the thumbnail.
- System.Drawing.Bitmap thumbnail - The System.Image.Bitmap representation of the image that will be saved to the filesystem.
###SetRichEditorContent(System.String,System.String) Represents a method that intercepts the form editor contents for modification after the editor has been closed.
Parameters:
- System.String requestData - The System.String representation of the web request data that was sent from the client to the server.
- System.String content - The System.String representation of the HTML form definition that was passed from the client to the server.
Returns:
The modified form content that will be returned to the client.
###ThumbnailExists(Izenda.AdHoc.ReportInfo) Represents a method that checks whether the thumbnail image associated with the specified report exists on the database.
Parameters:
- Izenda.AdHoc.ReportInfo reportInfo - The Izenda.AdHoc.ReportInfo object that contains the information about the report to check for a thumbnail image.
Returns:
True when the thumbnail image exists. False when the image is not found.
###ToString() Returns a System.String that represents the current System.Object.
Returns:
A System.String that represents the current System.Object.
###UpdateMetadata() Clears the schema to allow a refresh of the schema's metadata on the next request. (deprecated)