#AdHocSettings
The AdHocSettings class contains all the settings Izenda uses to control various aspects of the interface and flow of data. Many of the more useful settings are explained in detail in our Guide to Report Design and Developer Guides.
| Datatype | Setting name | Setting description | Default Value | |
|---|---|---|---|---|
| String | AddAllFilterRegex | Gets or sets the regular expression used for "Add All" filtering. If name of a column matches this expression then it will not be added on "Add All" click. | (id&124;guid)$ | |
Dictionary2|[[AdditionalTimeZones|/API/CodeSamples/AdditionalTimeZones]]|List of additional timezones.|System.Collections.Generic.Dictionary2[System.String,System.Double] |
||||
| AdHocConfig | AdHocConfig | Gets or sets the current - Ad Hoc configuration. | Izenda.AdHoc.FileSystemAdHocConfig | |
| String | AdHocUserKey | Gets or sets a single password limiting access to the report designer, report list and report viewer. | String.Empty | |
| AggregateFunctionCollection | AggregateFunctions | Izenda.AdHoc.AggregateFunctionCollection | ||
| Boolean | AllowAnalysisGrid | Gets or sets the value indicating whether it is allowed analysis grid | True | |
| Boolean | AllowArchivedReportTableCreation | Gets or sets the value indicating whether it is allowed to create the database table that contains archived reports if there is no such table in the database. | True | |
| Boolean | AllowClientSorting | True | ||
| Boolean | AllowComparativeArithmetic | Gets or sets the value indicating whether comparative arithmetic is allowed in arithmetic checkbox. | False | |
| Boolean | AllowCreateNewCategory | Gets or sets the value indicating the possibility to create new categories in Save As dialog. | True | |
| Boolean | AllowDataFieldsInDescription | Gets or sets the value indicating whether any column names (enclosed in square brackets) in the description of the report should be replaced to the value of Details report cell placed in the first row and the specified column. | True | |
| Boolean | AllowDeletingReports | Gets or sets the value indicating whether deleting reports is allowed. | True | |
| Boolean | AllowDeltas | Gets or sets the value indicating whether "Add Deltas" checkbox should be shown in fields. | False | |
| Boolean | AllowDomainJoin | Gets or set value indicating domain join should be shown at report designer. | False | |
| Boolean | AllowEqualsSelectForStoredProcedures | Gets or sets the value indicating is it allowed to use Equals(Select) or Equals(Multiple) for filters in case when stored procedure used. | False | |
| Boolean | AllowFieldsAsValue | Gets or sets the value indicating whether field name is allowed in filter value. | True | |
| Boolean | AllowGroupWithoutSelect | Gets or sets value indicating if it is possible to make invisible fields which are used for Visual Grouping. | False | |
| Boolean | AllowHorizontalBarChart | Gets or sets the value indicating whether Horizontal Bar Chart is allowed | True | |
| Boolean | AllowHtmlOutputsInScheduledReports | Get or set value indicating allowing formats for scheduling reports | True | |
| Boolean | AllowInvalidCharacters | Gets or sets the value indicating whether invalid characters in report namesare allowed if not striped. | False | |
| Boolean | AllowInvertedGrid | Gets or sets the value indicating whether "Invert" checkbox should be shown in the summary tab. | False | |
| Boolean | AllowLineOnBar | Gets or sets the value indicating whether is it allowed line on Bar chart. | True | |
| Boolean | AllowMultilineHeaders | Gets or sets if headers can be multiline. | False | |
| Boolean | AllowNewFiltersInReportViewer | Gets or sets the value indicating whether user can add new filters in the report viewer. | True | |
| Boolean | AllowOverwritingReports | Gets or sets the value indicating whether reports overwriting is allowed. | True | |
| Boolean | AllowSelfJoin | Gets or sets the value indicating whether is it allowed datasources self join. | True | |
| Boolean | AllowStackedBarChart | Gets or sets the value indicating whether Stacked Bar Chart is allowed | True | |
| Boolean | AllowSummaryDeltas | Gets or sets the value indicating whether "Show Summary Deltas" checkbox should be shown in the summary tab. | True | |
| Boolean | AllowVisualGroups | Gets or sets the value indicating whether visual groups are allowed. | True | |
| String | ApplicationHeaderImageUrl | Gets or sets the URL of the Header Logo. | String.Empty | |
| Boolean | AutoJoinOnRenderedRows | Gets or sets the value indicating whether auto-join function should work for server-rendered rows in | True | |
| Boolean | AutoPostBackOnFilterChange | Gets or sets the value indicating whether should be postback on filter change. | True | |
| Boolean | CacheEqualsSelect | Gets or sets the value indicating whether "Equals (Select)" value should be cached. | False | |
| Boolean | CacheQueries | Gets or sets the value indicating whether all queries for the should be cached. | True | |
| Boolean | CacheReports | Gets or sets the value indicating whether all loaded reports should be cached. | True | |
| Boolean | CacheSchema | Gets or sets the value indicating whether should be cached. | True | |
| Boolean | CacheStoredProcedureMetaDataToDisk | Gets or sets the value indicating is the information about the stored procedures will be cached on disk. | False | |
| Boolean | CascadeFilterValues | Gets or sets the value indicating whether filter values will be cascaded. For example, this will only show cities in the countries selected on the prior filter | True | |
| Char | CategoryCharacter | Get or set delimiter which is used to delimit category name and report name | | | |
| Boolean | ChangParentUrlWhenRedirect | False | ||
| ChartingEngine | ChartingEngine | Defines which ChartingEngine will be used (ZedGraph, ComponentArt, or Dundas) | DundasChart | |
| Int32 | ChartLimit | Gets or sets the value limiting chart items | 500 | |
| ChartCollection | Charts | Gets or sets the collection of available s. | Izenda.AdHoc.ChartCollection | |
| Point | ChartSize | Gets or sets the value indicating chart size. | {X=700,Y=300} | |
| String[] | ChartSortFields | Gets or sets the value indicating the fields which will be used for sorting in a chart case. | String.Empty | |
| Int32 | CheckBoxListColumns | Number of checkboxes columns in "Quick add" dialog in the report designer | 2 | |
| Boolean | CheckForUpdates | Gets or sets the value indicating whether AdHoc is check for updates. | False | |
| Boolean | CheckUserPermission | Get or set value indicating checking user permission | True | |
| Boolean | CollapsedFiltersInReportViewer | Gets or set value indicating whether filters should be initially collapsed in . | False | |
| Unit | ColumnDropDownWidth | Gets or sets the width of column dropdown. | 200px | |
| CultureInfo | Culture | Gets or sets the default culture for Ad Hoc. | en-US | |
| Boolean | CurrentUserIsAdmin | Gets or sets a value indicating whether current user is admin. | True | |
| Boolean | CurrentUserIsGlobalAdministrator | Defines if current user has global administrator rights | False | |
| String | CurrentUserName | Gets or sets the name of the current user. | DefaultAdministrator | |
| String[] | CurrentUserRoles | Gets or sets the the current user groups set. | System.String[] | |
| String | CurrentUserTenantId | This identifies what tenant the current user is associated with in a multi-tenant system. | String.Empty | |
| CustomizeChartDelegate | CustomizeChartDelegate | Represents a method that runs before chart reports get run. | String.Empty | |
| CustomTimePeriodCollection | CustomTimePeriods | Defines custom time periods, that can be used in 'In Time Period' filter. | Izenda.AdHoc.CustomTimePeriodCollection | |
| DashboardDateSliderMode | DashboardDateSliderMode | Gets or sets the value indicating the size of division for Dashborad date slider. | Auto | |
| String | DashboardDesignerUrl | Gets or sets the URL of a page used to design dashboards (). | DashboardDesigner.aspx | |
| String | DashboardDesignerUrlWithDelimiter | Gets the with "?" or "&" char at the end. | DashboardDesigner.aspx? | |
| Int32 | DashboardFieldsCount | Gets or sets the count of additional reports. | 3 | |
| Double | DashboardGaugeMax | Gets or sets the gauge max value for "Dashboard Gauge" format. | 1.79769313486232E+308 | |
| Double | DashboardGaugeMin | Gets or sets the guage min value for "Dashboard Gauge" format. | -1.79769313486232E+308 | |
| Int32 | DashboardGaugeWidth | Gets or sets value, indicating how long (minutes) reportSet output html will stay in cache. Zero means cache disabled. | 200 | |
| Int32 | DashboardMinimumWidth | Gets or set minimum dashboard width. | 1000 | |
| Boolean | DashboardMode | Gets or sets the value indicating whether dashboard mode is enabled. | False | |
| String | DashboardsCss | Gets or sets the css style for the . | @import url(rs.aspx?css=dashboard); | |
| String | DashboardsCssUrl | Gets or sets the css stylesheet URL for the . | rs.aspx?css=dashboard | |
| String | DashboardTabBackgroundImageUrl | Gets or sets the URL of the tabs background image for Dashboard. | String.Empty | |
| String | DashboardViewer | Gets or sets the URL of the dashboard viewer page. | ReportViewer.aspx | |
| String | DashboardViewerWithDelimiter | Gets the report viewer page with "?" or "&" char at the end. | ReportViewer.aspx? | |
| String | DatabaseDiagramImageUrl | Gets or sets the URL of image with database diagram. | String.Empty | |
| Int32 | DataCacheInterval | 0 | ||
| NameDistinctValueCollection | DataSourceAliases | Gets or sets the collection of key-value pairs where the key is the table name and the value is a table alias. | NameDistinctValueCollection | |
| NameStringsCollection | DataSourceCategories | This allows to assign sets of datasources to different categories. | Izenda.AdHoc.Collections.NameStringsCollection | |
| TimeSpan | DataSourceDropDownTimeout | Gets or sets the timeout between starting loading dropdown values from server and redicecting to About page. | 00:00:15 | |
| Unit | DataSourceDropDownWidth | Gets or sets the width of data source dropdown. | 190px | |
| String | DataSourceHeading | Renames the heading within the datasources tab of Izenda Reports. | Data Sources (Tables and Views) | |
| Int32 | DataSourceLimit | Limits the number of data sources Izenda Reports allows to be used as data sources in a single report. | 1000 | |
| Int32 | DateArithmeticDecimalPlaces | Gets or sets the value indicating how many decimal places dates show up when comparing dates. | 0 | |
| String | Db2ConnectionString | Gets or sets the connection string for DB2 | String.Empty | |
| String | DefaultAlternatingItemColor | Sets the default alternating item color. | Gainsboro | |
| String | DefaultHeaderForegroundColor | Sets the default header foreground color. | White | |
| String | DefaultItemForegroundColor | Sets the default item forground color. | Black | |
| Int32 | DefaultItemsPerPage | Changes the default items shown in the report viewer per page. | 10000 | |
| Int32 | DefaultLinesPerItem | Gets or sets the default count of lines per item for "Multi-Line" feature. | 1 | |
| String | DefaultLoadTab | Gets or sets the name of tab with is loaded by default. | Fields | |
| Int32 | DefaultPreviewResults | Changes the default number of results shown in the report designer preview tab. | 100 | |
| String | DefaultReportBorderColor | Sets the default border color for reports. | White | |
| String | DefaultReportHeaderColor | Sets the default report header color. | DarkSlateBlue | |
| String | DefaultReportItemColor | Sets the default report item color. | White | |
| StringCollection | DefaultReportOrder | Gets or sets the default report order. | System.Collections.Specialized.StringCollection | |
| String | DefaultSharingRights | Gets or sets the Default Sharing Rights | None | |
| String | DefaultTable | Gets or sets the default table which is automatically added to new report. | String.Empty | |
| String | DefaultUserName | This settings allows the user to set the default username for users logged into the Izenda Reports web application. | DefaultAdministrator | |
| String | DefaultVisibilityForNonAdmins | Gets or sets the default default visibility group for non admins. | OnlyMe | |
| Unit | DescriptionWidth | Gets or sets the width of description edit. | 100px | |
| NameValueCollection | DetailReportFormatString | Gets or sets the extended link formats for "Detail Link" format. | System.Collections.Specialized.NameValueCollection | |
| Boolean | Distinct | Gets or sets the initial value for field. | True | |
| Boolean | DistinctSubtotalInnerQuery | Gets or sets the value indicating whether DISTINCT option should be used in inner query for the subtotals calculating. | True | |
| FormatCollection | DrillDownStyle | Gets or sets the list of available drill-down report fields formats. | Izenda.AdHoc.FormatCollection | |
| AggregateFunctionCollection | DundasAggregateFunctions | Izenda.AdHoc.AggregateFunctionCollection | ||
| String | EmailFromAddress | Email from address for the automated scheduler. | adhoc@yourdomain.com | |
| String | EmailSubjectFormatString | Gets or set subject of the emailed report for scheduler. | {0} | |
| Boolean | EmbedReportInServerEmail | Gets or sets the value indicating whether report will be embedded in the server email. | False | |
| String | EmptyReportString | String.Empty | ||
| Int32 | EqualsDropDownLimit | Limits the number of (options) rows selectable through an equals (drop down) filter. | 2000 | |
| Int32 | EqualsDropDownTimeout | Gets or sets the wait time in seconds for "Equals (Select)" dropdown values loading. | 10 | |
Dictionary2|[[EqualsPopupDestinations|/API/CodeSamples/EqualsPopupDestinations]]|Gets or sets the value indicating which aspx page will be used for column in Equlas Popup filter.|System.Collections.Generic.Dictionary2[System.String,System.String[]] |
||||
| String | EqualsSelectDateFormat | Gets or sets default date format utilized by the equals select filters. | MM/dd/yyyy | |
| Int32 | EqualsSelectLimit | Limits the number of (options) rows selectable through an equals (drop down) filter. | 500 | |
| String | EqualsSelectText | Gets or sets the text of "Equals (Select)" operator. | Equals (Select) | |
| Int32 | EqualsSelectTimeout | Gets or sets the wait time in seconds for "Equals (Select)" dropdown values loading. | 60 | |
| String | ErrorIzendaReplacement | Gets or set value wich will replace "Izenda" word in StackTrace while exception | Izenda | |
| String[] | ExistingDatabaseConstraints | Gets database constraints. | String.Empty | |
| Boolean | ExpandCategorizedReports | Gets or sets the value indicating whether categorized reports should be expanded by default. | True | |
| Boolean | ExpandVisualGroupGrids | Gets or sets the value indicating visual groups are expanded by default. | True | |
| TextSharpFontWrapper | ExportFont | Gets or sets the font for the PDF and RTF outputs. | String.Empty | |
| Int32 | ExportLimit | Gets or set value indicating ReportSet max row count while export | 100000 | |
| NameValueCollection | ExtendedFormats | Gets or sets the collection of names and values of additional formats which should be displayed in "Formats" dropdown lists. | Izenda.AdHoc.ExtendedFormatsCollection | |
| String[] | ExtendedFunctions | Gets or sets the array of additional functions to display in every "Functions" dropdown lists. | System.String[] | |
| NameValueCollection | FieldAliases | Gets or sets the collection of key-value pairs where the key is the field name and the value is a field alias. | System.Collections.Specialized.NameValueCollection | |
| Unit | FieldDropDownWidth | Gets or sets the width of field dropdown. | 200px | |
| String | FieldFilterRegex | Gets or sets the regular expression used for column filtering. If name of a column matches this expression then it will not be shown. | MD5&124;^(Passw) | |
| Int32 | FieldLimit | Limits the number of fields Izenda Reports allows to be used in a single report. | 1000 | |
| FieldList | FieldList | Gets or sets the default control. | Izenda.Web.UI.FieldList | |
| String | FieldsRegex | Gets or sets the regular expression used for column filtering in Field tab. If name of a column matches this expression then it will not be shown in fields select in Field tab. | MD5&124;^(Passw) | |
| String | FieldValueCssUrl | Css file to be used on reports with Field | Value style. | rs.aspx?css=FieldValue |
| Unit | FilterParameterWidth | Gets or sets the width of filter parameter edit. | 300px | |
| String | FiltersCustomPagesPath | Gets or sets the relative path to the Equals(PopUp) custom pages. | String.Empty | |
| String | FiltersRegex | Gets or sets the regular expression used for column filtering in Filter tab. If name of a column matches this expression then it will not be shown in fields select in Filter tab. | MD5&124;^(Passw) | |
| Boolean | ForceNewNameOnSave | This feature always uses the save as function and requires the user to specify a report name when saving. | False | |
| Unit | FormatDropDownWidth | Gets or sets the width of format dropdown. | 190px | |
| FormatCollection | Formats | Gets or sets the list of available fields formats. | Izenda.AdHoc.FormatCollection | |
| String | FormDesignerUrl | ./Forms/FormDesigner.aspx | ||
| Unit | FunctionDropDownWidth | Gets or sets the width of function dropdown. | 182px | |
| Int32 | GaugeHeight | Gets or sets the gauge height for "Gauge" format. | 50 | |
| Double | GaugeMaximum | Gets or sets the maximum value of gauge. | 1 | |
| Double | GaugeMinimum | Gets or sets the minimum value of gauge. | 0 | |
| String[] | GaugeStyles | Gets or sets custom gauge types. | String.Empty | |
| Int32 | GaugeWidth | Gets or sets the gauge width for "Gauge" format. | 250 | |
| Boolean | GenerateParameterizedSql | Gets or sets the value indicating whether queries to the database should be parameterized. | True | |
| Boolean | GenerateThumbnails | Gets or sets the value indicating whether reports thumbnails should popup in the ReportList. | False | |
| String | GeoDataTable | Gets or sets the value indicating the table name wich contains geodata for maps. | String.Empty | |
| GetEqualsSelectValuesDelegate | GetEqualsSelectValues | Represents a method that returns values for operator. | String.Empty | |
| TableItemStyle | GridHeaderStyle | Gets or sets the OpenOffice output style for report results grid header. | System.Web.UI.WebControls.TableItemStyle | |
| TableItemStyle | GridItemStyle | Gets or sets the Excel output style for report results grid item. | System.Web.UI.WebControls.TableItemStyle | |
| Color | HeaderForegroundColor | Gets or sets the color of report header. | Color [White] | |
| String | HeaderStyle | Gets or sets the style for the , and headers. | font-family: verdana, arial, helvetica, sans-serif; font-size: 11px;color:blue; | |
| NameValueCollection | HelpText | Gets or sets the collection of key-value pairs where the key is the tab name and the value is a hint that will be shown when mouse is over the appropriate tab. | System.Collections.Specialized.NameValueCollection | |
| String[] | HiddenCategories | Sets which categories are hidden for the current user | String.Empty | |
| String[] | HiddenColumns | Gets or sets the array of Column names should be hidden in fileds dropdown. | String.Empty | |
| HiddenFilterCollection | HiddenFilters | This controls row-level security throughout the tool. This should be used in all multi-tenant systems and systems where users are restricted to certain records | Izenda.AdHoc.HiddenFilterCollection | |
List1|[[HiddenTimeZones|/API/CodeSamples/HiddenTimeZones]]|List of timezones to hide.|System.Collections.Generic.List1[System.Double] |
||||
| String | IdentifiersRegex | String.Empty | ||
| String | ImagesPath | Gets or sets the path of the folder which contains the images used by Ad Hoc. If the value is then built-in images will be used. | String.Empty | |
| Boolean | InheritFiltersInSubreports | Gets or sets the value indicating whether filters will be inherited in subreports. | True | |
| String | InstantReport | Gets or sets the URL of the report viewer page. | InstantReport.aspx | |
| String | InstantReportWithDelimiter | Gets the instant report page with "?" or "&" char at the end. | InstantReport.aspx? | |
| Boolean | InvalidateSchemaOnNew | Gets or sets the value indicating whether database schema is invalidated then user creates new report. | False | |
| Int32 | InvertedGridLimit | Gets or sets the maximum count of rows for inverted grid. | 36 | |
| Color | ItemForegroundColor | Gets or sets the color of report header. | Color [Black] | |
| Unit | JoinDropDownWidth | Gets or sets the width of join type dropdown. | 100px | |
| JoinedTablesList | JoinedTablesList | Gets or sets the default control. | Izenda.Web.UI.JoinedTablesList | |
| String | JoinFieldRegex | Gets or sets the regular expression used for table filtering. If name of a table or a column matches this expression then it will be excluded | String.Empty | |
| NameValueCollection | LabelAliases | Gets or sets the collection of key-value pairs where the key is the field name and the value is a field alias. | System.Collections.Specialized.NameValueCollection | |
| AdHocLanguage | Language | Friendly setter of the default culture for Ad Hoc. | English | |
| Char | LiteralComma | Gets or sets the delimiter separating items in the 'Equals' filter operator value. | , | |
| Boolean | LockViewer | Gets or sets the value indicating whether Report Viewer will be locked or not. | False | |
| String | LoginUrl | Gets or sets login page Url. | Login.aspx | |
| MapInfoCollection | MapInfoCollection | Gets or sets the registered maps data. | Izenda.AdHoc.Map.MapInfoCollection | |
| Size | MaxImageSize | Gets or sets the maximum image size of the report images. If the size of an image is larger than the specified value then the image will be scaled. | {Width=320, Height=240} | |
| Int32 | MaximumReportSizeForCache | 1048576 | ||
| Single | MaxVersion | Gets Max Version. | 6.7 | |
| Unit | MinPdfFontSize | Sets the minium font size that will be used when creating a PDF document. Default is 10 point. | 10pt | |
| Boolean | MultiLevelVisualGrouping | Gets or set value indicating whether Visual Groups should be multi-level. | True | |
| String | MySqlConnectionString | Gets or sets the connection string for MySQL. | String.Empty | |
| String | NoDataSourcePage | Gets or sets url of the page where user will be redirected if there is no tables in a data base | Settings.aspx | |
| Int32 | NumChartPerRow | Gets or set value indicating number of charts in one reports row | 2 | |
| Int32 | NumChartTabs | Gets or set value indicating maximum possibile charts for the report set. | 2 | |
| Int32 | NumSharedDropdowns | Gets or sets the maximum number of user/roles a report can be shared with. | 3 | |
| Boolean | OpenCustomUrlInNewWindow | Gets or sets the value indicating whether CustomUrl field links should open in a new window. | True | |
| Int32 | OracleCommandTimeout | Sets the time Izenda Reports will wait for an Oracle command to execute before timing out. | 3600 | |
| String | OracleConnectionString | Gets or sets the connection string for Oracle. | String.Empty | |
| ReportOutputGeneratorCollection | OutputTypes | Gets or sets the registered s. | Izenda.AdHoc.ReportOutputGeneratorCollection | |
| String | ParentReportDesignerUrl | String.Empty | ||
| String | ParentReportListUrl | String.Empty | ||
| String | ParentReportViewerUrl | String.Empty | ||
| String | ParentSettingsUrl | String.Empty | ||
| Boolean | PerUserCaching | Gets or sets the value indicating whether should be cached. | False | |
| Int32 | PivotFieldLimit | Limit for how many pivot columns are in a report. | 100 | |
| String | PostgreSQLConnectionString | Gets or sets the connection string for Postgres. | String.Empty | |
| Int32 | PreviewColumnLimit | Gets or set value indicating number of columns to show in preview | 100 | |
| String | PreviewColumnLimitMessage | Gets or set value indicating message displayed when PreviewColumnLimit is exceeded | Reports with more than 100 fields must be exported to CSV. Please check CSV Export to view data. | |
| Int32 | PreviewTimeout | Gets or sets the for SQL commands. | 0 | |
| PrintMode | PrintMode | Gets or sets the value indicating what print mode will be used, PDF or HTML. | PdfAndHtml | |
| ProcessFiltersDelegate | ProcessFiltersDelegate | Represents a method that handles execution. | String.Empty | |
| Int32 | QuickAddFieldWidth | Gets or set value indicating max length of string in one QuickAdd column | 20 | |
| Int32 | QuickAddMinElementsInColumn | Gets or set value indicating how many elements are in one QuickAdd column | 20 | |
| String | RDLFolder | Gets or sets path to Folder where RDL files whould be saved | RDLFiles | |
| Int32 | RecentlyUpdatedCountAtReportList | Gets or sets the value indicating how many reports will shown at recent list at ReportList | 0 | |
| Color | ReportAlternatingItemColor | Gets or sets the color of report alternating item. | Color [Gainsboro] | |
| Color | ReportBorderColor | Gets or sets the color of report border. | Color [White] | |
| String | ReportCss | Gets or sets the css style for the report HTML and Word output. | @import url(rs.aspx?css=Report); | |
| String | ReportCssUrl | Css file to be used on reports generated by Izenda Reports. | rs.aspx?css=Report | |
| String | ReportDesignerUrl | Gets or sets the URL of a page used to design reports ( page). | ReportDesigner.aspx | |
| String | ReportDesignerUrlWithDelimiter | Gets the with "?" or "&" char at the end. | ReportDesigner.aspx? | |
| Color | ReportHeaderColor | Gets or sets the color of report header. | Color [DarkSlateBlue] | |
| Image | ReportHeaderImage | String.Empty | ||
| String | ReportHeaderImageUrl | Gets or sets the image which will be shown at the top of the report. | String.Empty | |
| String | ReportingService2005Url | Gets or sets the base URL of the XML Web service. | http://localhost/ReportServer/ReportService2005.asmx | |
| Color | ReportItemColor | Gets or sets the color of report item. | Color [White] | |
| String | ReportList | Gets or sets the URL of the report list page. | ReportList.aspx | |
| ReportListSettings | ReportListSettings | Gets or sets the value indicating ReportList display | HideAll | |
| ReportSetEventWatcherCollection | ReportSetEventWatchers | Gets or sets the collection of registered which can do some actions on -related events. | Izenda.AdHoc.ReportSetEventWatcherCollection | |
| String | ReportsPath | Gets or sets the path of the folder where stores its reports. If the value is then reports will be stored in "Reports" subfolder of application folder. | C:\cygwin64\home\jadams\webforms-cs-2\Reports | |
| Boolean | ReportsSharedByDefault | True | ||
| StorageMode | ReportStorageMode | Defines how reports are stored - in the file system or in the database | Filesystem | |
| ReportTypeCollection | ReportTypes | Gets or sets the report types. | Izenda.AdHoc.ReportTypeCollection | |
| String | ReportViewer | Gets or sets the URL of the report viewer page. | ReportViewer.aspx | |
| Int32 | ReportViewerDefaultPreviewResults | Specifies the default number of results previewed in the report view page for all reports. | 100 | |
| String | ReportViewerPostHtml | Gets or sets the string contains html code that placing after the entire HtmlOutputReportResults section. | String.Empty | |
| String | ReportViewerPreHtml | Gets or sets the string contains html code that placing before the entire HtmlOutputReportResults section. | String.Empty | |
| Int32 | ReportViewerRefreshInterval | Gets or sets the milliseconds between preview auto-refresh. If 0 then there no auto-refresh. | 0 | |
| String | ReportViewerWithDelimiter | Gets the report viewer page with "?" or "&" char at the end. | ReportViewer.aspx? | |
| String | ReportViewPageTitle | Gets or sets the title of report view page. | String.Empty | |
| Boolean | RequireLogin | This setting tells Izenda Reports to use the login page specified above in the Login URL setting. | False | |
| String | ResponseServer | Gets or sets the URL of the page. | rs.aspx | |
| String | ResponseServerWithDelimiter | Gets the page with "?" or "&" char at the end. | rs.aspx? | |
| String | ResponseServerWithDelimiterFull | rs.aspx? | ||
| Int32[] | ResultsDropdownValues | Gets or sets the list of the values in the preview results dropdown dialog. | System.Int32[] | |
| String | SavedReportsTable | Gets or sets the table name for saved reports. | IzendaAdHocReports | |
| String | SaveReportSetNextUrl | Gets or sets the URL of the report viewer page. | String.Empty | |
| String | ScheduledReportsUrlFormatString | Gets or sets the url that is sent via email as the report web address. | http://localhost:56324/ReportViewer.aspx?{0} | |
| SchedulerOutputCollection | SchedulerExports | Izenda.AdHoc.SchedulerOutputCollection | ||
| SchedulerOutputCollection | SchedulerOutputTypes | Get or set value indicating allowed formats for scheduling reports | Izenda.AdHoc.SchedulerOutputCollection | |
| String | SchedulerTenantID | Gets or sets the tenantId for scheduler. | String.Empty | |
| TimeSpan | SchemaCacheTimeout | Gets or sets the time span for schema caching. | 1.00:00:00 | |
| String | ScriptDirectory | String.Empty | ||
| Unit | SelectValueDropDownWidth | Gets or sets the width of filter values dropdown. | 300px | |
| Boolean | ServiceMode | Gets or set value indication service mode | False | |
| String | SettingsKey | Gets or sets password to access Settings control | String.Empty | |
| String | SettingsPageUrl | Gets or sets the URL of the page. | Settings.aspx | |
| String[] | SharedWithValues | This sets the users or roles available in the Shared With dropdown of the Misc tab in the report designer. | String.Empty | |
| Boolean | ShowAddAll | Gets or sets the value indicating whether AddAll button and dropdown should be shown in the . | False | |
| Boolean | ShowAddFieldInReportViewer | True | ||
| Boolean | ShowAdminButton | Gets or sets the value indicating showing buttons for administration | True | |
| Boolean | ShowAdvancedChartingButton | Gets or sets the value indicating whether "Show Advanced" button should be shown in the . | True | |
| Boolean | ShowAllInPreview | Gets or sets the value indicating whether "CombinedTop Count" dropdown list should have the "All" item in preview. | True | |
| Boolean | ShowAllInResults | Gets or sets the value indicating whether "CombinedTop Count" dropdown list should have the "All" item in results. | True | |
| Boolean | ShowAllTables | Gets or sets the value indicating whether all tables should be shown in tables dropdown. | True | |
| Boolean | ShowArithmeticInSummary | Gets or sets the value indicating whether arithmetic operations are shown in the summary tab of . | False | |
| Boolean | ShowArithmeticOperations | Gets or sets the value indicating whether arithmetic operations are shown in . | True | |
| Boolean | ShowBackButton | Gets or sets the value indicating whether "Back" button should be shown in the . | False | |
| Boolean | ShowBetweenDateCalendar | True | ||
| Boolean | ShowBulkCSVButton | Gets or sets the value indicating possibility export to BulkCSV | False | |
| Boolean | ShowCategoryTextboxInSaveDialog | Gets or sets the value indicating whether category checkbox should be shown in the save dialog. | True | |
| Boolean | ShowChartLegend | Gets or sets the value indicating whether chart legend should be shown. | True | |
| Boolean | ShowChartTab | Gets or sets the value indicating whether chart tab should be shown. | True | |
| Boolean | ShowClientEmailButton | Gets or sets the value indicating whether the email from client icon should be shown in the toolbar. | True | |
| Boolean | ShowConstraintsSettings | Gets or sets the value indicating allows edit constraints settings. | False | |
| Boolean | ShowContinueLinks | This setting enables or disables the "Continue to" buttons in report designer that assist walking a user through the tabs in report designer. | True | |
| Boolean | ShowCSVButton | Gets or sets the value indicating possibility export to CSV | True | |
| Boolean | ShowCustomFormatType | Gets or sets the value indicating whether "Custom" format type should be shown in formats dropdown. | False | |
| Boolean | ShowDashboardAddDropDown | Gets or sets a value indicating whether "add dashboard subreport" should be shown as DropDownList control. | False | |
| Boolean | ShowDashboardFieldsTab | Gets or sets the value indicating whether tab with dashboard fields is shown. | False | |
| Boolean | ShowDashboardPartViewerLinks | Gets or sets the value indicating whether Dashboard Viewer will have edit links for it's reports | True | |
| Boolean | ShowDashboardSettings | Gets or sets the value indicating allows edit dashboard settings | False | |
| Boolean | ShowDatabaseDiagramIcon | Gets or sets the value indicating whether the Database Diagram icon should be shown in the toolbar. | True | |
| Boolean | ShowDatabaseTypes | Gets or set value indicating whether database types should be shown in the fields dropdown. | False | |
| Boolean | ShowDataSourcesAsCheckBoxes | Gets or sets the value indicating mode of data sources list is showed. | True | |
| Boolean | ShowDataSourcesTab | Gets or sets the value indicating whether tab with data sources list is showed. | True | |
| Boolean | ShowDataWhenParametersBlank | Gets or sets the value indicating whether data should be shown in report viewer if all parameters is blank. | True | |
| Boolean | ShowDescriptionsInReportsTab | Gets or sets the value indicating whether reports descriptions should be shown in the reports tab of . | False | |
| Boolean | ShowDesignDashboardLink | Gets or sets the value indicating whether design new dashboard link is shown | True | |
| Boolean | ShowDesignLinkInReportViewer | Gets or set value indicating whether design link should be shown in . | True | |
| Boolean | ShowDesignLinks | Gets or sets a value indicating whether design links should be shown in report list and in the toolbar. | True | |
| Boolean | ShowDetailFormat | Gets or sets the value indicating whether "Detail Link" format should be shown in formats dropdown. | True | |
| Boolean | ShowDistinct | Gets or set value indicating whether "Distinct" should be shown at the Data Source tab. | True | |
| Boolean | ShowDOCButton | Gets or sets the value indicating possibility export to DOC | True | |
| Boolean | ShowEtlButton | Gets or sets the value indicating whether the upload data button should be shown in the report viewer. | False | |
| Boolean | ShowFieldAsValueDropDown | Gets or sets the value indicating whether fields dropdown will be shown as value on "Is Less Then (Field)", "Is Greater Then (Field)" and "Equals (Field)" operators. | True | |
| Boolean | ShowFieldsTab | Gets or sets the value indicating whether tab with fields list is shown. | True | |
| Boolean | ShowFieldValueCheckbox | Gets or sets the value indicating whether "Field | Value" checkbox should be shown in the field tab. | True |
| Boolean | ShowFieldValueSummaryCheckbox | Gets or sets the value indicating whether "Field | Value" checkbox should be shown in the summary tab. | True |
| Boolean | ShowFilterFunctions | Gets or sets the value indicating whether Remove All button should be shown in the . | True | |
| Boolean | ShowFilterLogic | Gets or sets the value indicating whether Filter Logic should be shown in the . | True | |
| Boolean | ShowFiltersInDashboards | Gets or set value indicating whether filters should be shown in . | True | |
| Boolean | ShowFiltersInReportViewer | Gets or set value indicating whether filters should be shown in . | True | |
| Boolean | ShowFiltersTab | Gets or sets the value indicating whether tab with filters list is showed. | True | |
| Boolean | ShowFunctions | Gets or sets the value indicating whether functions should be shown in the . | True | |
| Boolean | ShowGaugePercentage | Gets or sets the value indicating whether percentage at gauges should be shown. | False | |
| Boolean | ShowGaugeTab | Gets or sets the value indicating whether gauges tab should be shown in report designer. | True | |
| Boolean | ShowGoButton | Gets or sets the value indicating whether "Go" button should be shown in the . | False | |
| Boolean | ShowGradientBackground | Gets or sets the value indicating is data grid items will be shaded with gradient | False | |
| Boolean | ShowGroupInFunctionDropdown | Gets or sets the value indicating whether GROUP feature should be shown as a function. Otherwise, it will be shown as a separate checkbox. | True | |
| Boolean | ShowGroupMonth | Gets or set value indicating whether Group(Month) function should be visible. | False | |
| Boolean | ShowHelpButton | Gets or sets the value indicating whether the "HideHelpPanel" icon should be shown in the toolbar. | False | |
| Boolean | ShowHtmlAsCode | This feature enables/disables showing HTML code containing in database fields as plain text. | False | |
| Boolean | ShowInTimePeriod | Gets or sets the value indicating whether "In Time Period" item is shown in operators dropdown. | True | |
| Boolean | ShowInvertSummaryCheckbox | Gets or sets the value indicating whether "Invert" checkbox should be shown in the summary tab. | False | |
| Boolean | ShowInvisible | Gets or sets the value indicating whether invisible checkboxes should be shown in the . | False | |
| Boolean | ShowJoinDropDown | Gets or sets the value indicating whether join type dropdown should be shown in the . | False | |
| Boolean | ShowJustification | Gets or sets the value indicating whether justification type should be shown in the field tab. | True | |
| Boolean | ShowLinkFormats | This feature enables/disables the link format function options for fields in the fields tab of reportdesigner. | True | |
| Boolean | ShowLoadingForDesigner | Gets or set value indicating whether loading message should be shown. | False | |
| Boolean | ShowLoadingOnDesignerLoad | Gets or set value indicating whether loading message should be shown on designer load. | False | |
| Boolean | ShowLogoInPdf | False | ||
| Boolean | ShowMapTab | Gets or sets the value indicating whether the Map Tab should be shown in the report viewer. | True | |
| Boolean | ShowMenuInReportViewer | Gets or set value indicating whether menu should be shown in . | False | |
| Boolean | ShowMiscTab | This checkbox enables/disables the misc tab from the Izenda Reports application report designer page. | True | |
| Boolean | ShowModifyButton | Gets or sets the value indicating whether the "Modify" button should be shown in the report viewer. | True | |
| Boolean | ShowMultiLineControls | Gets or sets the value indicating whether "Multi-Line" feature is enabled. | False | |
| Boolean | ShowNewButton | Gets or sets the value indicating whether the "New" icon should be shown in the toolbar. | True | |
| Boolean | ShowNonIndexedJoinFields | Gets or sets the value indicating whether non-indexed join fields should be shown. | True | |
| Boolean | ShowODTButton | Gets or sets the value indicating possibility export to ODT | False | |
| Boolean | ShowOnlineDocumentation | Gets or sets the value indicating if it's nessesary to show Details button in Settings. | True | |
| Boolean | ShowOpenOfficeButton | Gets or sets the value indicating possibility export to OpenOffice | False | |
| Boolean | ShowPDFButton | Gets or sets the value indicating possibility export to PDF | True | |
| Boolean | ShowPivot | Enables/disables the option of adding pivots to reports. | True | |
| Boolean | ShowPoweredByLogo | Gets or sets the value indicating whether "Powered By Izenda" logo should be shown. | False | |
| Boolean | ShowPreviewTab | Gets or sets the value indicating whether tab with preview is showed. | True | |
| Boolean | ShowPublishRdlButton | Gets or sets the value indicating whether publish rdl button should be shown in the reports tab of . | False | |
| Boolean | ShowRdlOutputIcon | Gets or sets the value indicating whether rdl button should be shown in the reports tab of . | False | |
| Boolean | ShowRecentDatasources | Gets or sets the value indicating whether recent datasources dropdown list will be shown in ReportDesigner. | True | |
| Boolean | ShowRemoveAll | Gets or sets the value indicating whether Remove All button should be shown in the . | True | |
| Boolean | ShowRemoveFieldInReportViewer | True | ||
| Boolean | ShowReportClassifiers | Gets or sets the value indicating whether control should be shown in the "Misc" tab. | True | |
| Boolean | ShowReportColor | Gets or sets the value indicating whether report color dropdowns are shown in . | True | |
| Boolean | ShowReportingServicesSettings | Gets or sets the value indicating allows edit reporting services settings | False | |
| Boolean | ShowReportsInHtmlOutput | Gets or sets the value indicating whether the list of reports should be shown in the Report viewer. | True | |
| Boolean | ShowReportsListAsDropDown | Gets or sets the value indicating whether reports displayed in Archive tab should be hyperlinks or should be items of dropdown list box. if reports should be displayed as hyperlinks. if reports should be displayed as items of dropdown list box. | False | |
| Boolean | ShowReportsTab | Gets or sets the value indicating whether tab with reports list is showed. | False | |
| Boolean | ShowResponseServerDetails | Gets or set value indicating showing diagnostic test at response server page | True | |
| Boolean | ShowRowButtons | Gets or sets the value indicating whether insert and move buttons should be shown in the . | True | |
| Boolean | ShowRTFButton | Gets or sets the value indicating possibility export to RTF | True | |
| Boolean | ShowSaveAsToolbarButton | Gets or sets the value indicating whether "Save As" button should be shown in the . | True | |
| Boolean | ShowSaveControls | Gets or sets the value indicating whether save controls should be shown in the reports tab of and in the . | True | |
| Boolean | ShowSaveControlsInReportsTab | Gets or sets the value indicating whether save controls should be shown in the reports tab of . | False | |
| Boolean | ShowSaveInReportViewer | Gets or sets the value indicating whether save controls should be shown in the ReportViewer. | True | |
| Boolean | ShowSaveRdlToolbarButton | Gets or sets the value indicating whether "Save As RDL" button should be shown in the . | False | |
| Boolean | ShowScheduleControls | Gets or sets the value indicating whether should be shown in the "Misc" tab. | True | |
| Boolean | ShowServerEmailButton | Gets or sets the value indicating whether the email from server icon should be shown in the toolbar. | False | |
| Boolean | ShowSettingsButton | Gets or sets the value indicating showing buttons for administration. An alias for ShowAdminButton setting. | True | |
| Boolean | ShowSettingsButtonForNonAdmins | Defines if Settings button will be shown to users without administrator rights | False | |
| Boolean | ShowSharedCheckbox | True | ||
| Boolean | ShowSharingControl | Gets or sets the value indicating is the sharing control will be shown. | True | |
| Boolean | ShowSideHelp | Gets or set value indicating whether side help should be shown in . | False | |
| Boolean | ShowSimpleModeViewer | Gets or sets a value indicating whether report viewer mode is simple mode. | False | |
| Boolean | ShowSqlOutputIcon | Gets or sets the value indicating whether the SQL output icon should be shown in the toolbar. | True | |
| Boolean | ShowStackTrace | Gets or sets the value indicating format for showing exceptions. | True | |
| Boolean | ShowStyleTab | Gets or sets the value indicating whether style tab should be shown in the report designer. | True | |
| Boolean | ShowSummaryLine | This feature allows the usage of a summary line in the fields tab of report designer. | True | |
| Boolean | ShowSummaryTab | Gets or sets the value indicating whether summary tab should be shown. | True | |
| Boolean | ShowTableNames | Gets or sets the value indicating whether colums should be grouped by table name. Otherwise show columns as "ColumnName(TableName)". | True | |
| Boolean | ShowTenantField | When false, this hides the field identified in the TenantField property | True | |
| Boolean | ShowTimeZoneDropdown | Gets or sets the value indicating whether timezone dropdown will be shown in the Report Designer. | True | |
| Boolean | ShowTopInFields | Gets or sets the value indicating whether results count dropdown should be shown in the fields tab of . | True | |
| Boolean | ShowTopInSummary | Gets or sets the value indicating whether results count dropdown should be shown in the summary tab of . | True | |
| Boolean | ShowVisualGroupLabels | Gets or sets the value indicating whether field names should be shown in visual group header. | False | |
| Boolean | ShowWatermarkedExports | Gets or sets the value indicating whether watermarked export should be used on license errors. | True | |
| Boolean | ShowWaterMarks | Gets or sets the value indicating whether watermarks should be used on license errors. | True | |
| Boolean | ShowWidth | Gets or sets the value indicating whether width edit should be shown in the . | False | |
| Boolean | ShowXLSButton | Gets or sets the value indicating possibility export to XLS | True | |
| String | SimpleFilterCssUrl | Gets or sets the css stylesheet URL for the . | rs.aspx?css=SimpleFilter | |
| Boolean | SingleLineViewerToolbar | Gets or set value indicating whether toolbar should be single line. | False | |
| String | SmtpLogin | Gets or sets the SMTP server login. | String.Empty | |
| String | SmtpPassword | Gets or sets the SMTP server password. | String.Empty | |
| String | SmtpServer | Gets or sets the SMTP server address for sending e-mails. | localhost | |
| Boolean | SortColumnNames | Gets or sets the value indicating whether dropdowns with column names are sorted alphabetically. | True | |
| Int32 | SqlCommandTimeout | Gets or sets the wait time in seconds for database command dropdown values loading. | 3600 | |
| String | SqlServerConnectionString | Gets or sets the connection string for MS SQL Server. | String.Empty | |
| Boolean | StoreCurrentReportSetInApplication | Gets or sets whether reportSet should be stored in application instead of session. | False | |
| Int32 | StoredProcedureStringLimit | Gets or set value indicating the max length of an string returned by a Stored Procedure (-1 for MAX) | -1 | |
| Boolean | StoreImagesToCache | Gets or sets the value indicating how temporary images should be stored. | True | |
| Boolean | StrictANSIOuterJoin | Gets or sets value indicating that strict ANSI/ISO SQL-92 outer join will be used (affects filters applied to joined tables). | True | |
| Boolean | StripInvalidCharacters | Gets or sets the value indicating whether invalid characters in report names should be striped. | True | |
| String | SubCalculationFilterRegex | Gets or sets the regular expression used for subtotals calculation. If name of a column matches this expression then it will not be added to subtotals. | ID$&124;Id$&124;^id$&124;_id$ | |
| String | TabBackgroundImageUrl | Gets or sets the URL of the tabs background image. | rs.aspx?image=TabStrip.Background.gif | |
| NameDistinctValueCollection | TableAliases | Gets or sets the collection of key-value pairs where the key is the table name and the value is a table alias. | NameDistinctValueCollection | |
| Unit | TableDropDownWidth | Gets or sets the width of table dropdown. | 190px | |
| String | TableFilterRegex | Gets or sets the regular expression used for table filtering. If name of a table or a column matches this expression then it will be excluded | ^(IzendaAdHoc) | |
| String | TabsCss | Gets or sets the css style for the . | @import url(rs.aspx?css=tabs); | |
| String | TabsCssUrl | Gets or sets the css stylesheet URL for the . | rs.aspx?css=tabs | |
| String | TempFiles | Gets or set value indicating path to temporary files. | TempFiles | |
| String | TemplatesPath | Gets or sets the path of the folder where templates are stored. | C:\cygwin64\home\jadams\webforms-cs-2\Reports | |
| String | TenantField | The name of the database field which stores a user's tenant. This is required for multi-tenant schedulin | String.Empty | |
| FieldHighlightInfoDictionary | TextHighlight | Izenda.AdHoc.FieldHighlightInfoDictionary | ||
| Int32 | ThumbnailHeight | Gets or sets the value indicating thumbnail size in pixels. | 220 | |
| Int32 | ThumbnailWidth | Gets or sets the value indicating thumbnail size in pixels. | 170 | |
| Unit | TimePeriodDropDownWidth | Gets or sets the width of time period dropdown. | 190px | |
| Int32 | TimeZoneOffset | Gets or sets the value indicating the time zone offset in Hours. | 0 | |
| SchedulerTimeZoneCollection | TimeZones | Collection of additional and hidden time zones. | Izenda.AdHoc.SchedulerTimeZoneCollection | |
| String | ToolbarBackgroundImageUrl | Gets or sets the URL of the toolbar background image. | rs.aspx?image=Toolbar.Toolgrad.gif | |
| String | ToolbarBorderColor | Gets or sets the color of toolbar border. | #95b7f3 | |
| String | ToolbarCssUrl | Gets or sets the css stylesheet URL for the . | rs.aspx?css=toolbar | |
| String | UnCategorizedReportsMenuItemTitle | Gets or sets the uncategorized reports menu item title. | Reports | |
| Boolean | UseAdvancedGauge | Gets or sets the value indicating whether advanced is used for "Gauge" format. | True | |
| Boolean | UseBulkCSV | Gets or sets the value indicating whether Bulk CSV use. | True | |
| Boolean | UseColumnNameForDashboardCommonFilters | Gets or sets the value indicating whether common filters in the Dasboard should be combined using Column Name only | True | |
| Boolean | UseConstraintsForJoins | Gets or sets the value indicating if multiple autojoining conditions are allowed. | False | |
| Boolean | UseDefaultDialogs | Gets or sets the value indicating whether system dialogs should be shown instead of Ad hoc dialogs. | False | |
| Boolean | UseFriendlyErrors | Gets or sets the value indicating whether friendly errors should be shown on exceptions. | True | |
| Boolean | UseImageDescriptions | False | ||
| Boolean | UseNoLock | Gets or sets the value indicating whether nolock statment will be used in sql-queries | True | |
| Boolean | UseNonPostbackDeleting | Gets or sets the value indicating whether should not be postback on report deleting. | True | |
| Boolean | UseNonPostbackExport | Gets or sets the value indicating whether should not be postback on report export. | True | |
| Boolean | UseNonPostbackPreview | Gets or sets the value indicating whether should not be postback on report preview. | True | |
| Boolean | UseNonPostbackServerEmailing | Gets or sets the value indicating whether should not be postback on report sever emailing. | True | |
| Boolean | UseReportID | Gets or sets the value indicating whether GUIDs will be used instead of report names in addresses. | False | |
| Boolean | ValidateBeforeSave | Gets or sets the value indicating whether reportset should be validated before saving | False | |
| Boolean | ViewsOnly | Gets or sets the value indicating whether only views is shown in tables dropdown. | False | |
| String[] | VisibleDataSources | Gets or sets the array of table names should be shown in tables dropdown. | System.String[] | |
| String[] | VisibleTables | Gets or sets the array of table names should be shown in tables dropdown. | System.String[] | |
| VisualGroupStyle | VisualGroupStyle | Gets or set value indicating what style should be used for visual groups. | CommaDelimited |