#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 User Guides and Developer Guides.
|Datatype|Setting name|Setting description|
|:——-|:———-:|:—————–:|
| string|AddAllFilterRegex||
| Dictionary<string,double>|AdditionalTimeZones ||
| AdHocConfig|AdHocConfig||
| string|AdHocUserKey||
| AggregateFunctionCollection|AggregateFunctions||
| bool|AllowAnalysisGrid||
| bool|AllowArchivedReportTableCreation||
| bool|AllowClientSorting||
| bool|AllowComparativeArithmetic||
| bool|AllowCreateNewCategory||
| bool|AllowDataFieldsInDescription||
| bool|AllowDeletingReports||
| bool|AllowDeltas||
| bool|AllowDomainJoin||
| bool|AllowEqualsSelectForStoredProcedures||
| bool|AllowFieldsAsValue||
| bool|AllowGroupWithoutSelect||
| bool|AllowHorizontalBarChart||
| bool|AllowHtmlOutputsInScheduledReports||
| bool|AllowInvalidCharacters||
| bool|AllowInvertedGrid||
| bool|AllowLineOnBar||
| bool|AllowMultilineHeaders||
| bool|AllowNewFiltersInReportViewer||
| bool|AllowOverwritingReports||
| bool|AllowSelfJoin||
| bool|AllowStackedBarChart||
| bool|AllowSummaryDeltas||
| bool|AllowVisualGroups||
| string|ApplicationHeaderImageUrl||
| bool|AutoJoinOnRenderedRows||
| bool|AutoPostBackOnFilterChange||
| bool|CacheEqualsSelect||
| bool|CacheQueries||
| bool|CacheReports||
| bool|CacheSchema||
| bool|CacheStoredProcedureMetaDataToDisk||
| bool|CascadeFilterValues||
| char|CategoryCharacter||
| bool|ChangParentUrlWhenRedirect||
| ChartingEngine|ChartingEngine||
| int|ChartLimit||
| ChartCollection|Charts||
| Point|ChartSize||
| string[]|ChartSortFields||
| int|CheckBoxListColumns||
| bool|CheckForUpdates||
| bool|CheckUserPermission||
| bool|CollapsedFiltersInReportViewer||
| Unit|ColumnDropDownWidth||
| CultureInfo|Culture||
| bool|CurrentUserIsAdmin||
| bool|CurrentUserIsGlobalAdministrator||
| string|CurrentUserName||
| string[]|CurrentUserRoles||
| string|CurrentUserTenantId||
| CustomizeChartDelegate|CustomizeChartDelegate||
| DashboardDateSliderMode|DashboardDateSliderMode||
| string|DashboardDesignerUrl||
| int|DashboardFieldsCount||
| double|DashboardGaugeMax||
| double|DashboardGaugeMin||
| int|DashboardGaugeWidth||
| int|DashboardMinimumWidth||
| bool|DashboardMode||
| string|DashboardsCss||
| string|DashboardsCssUrl||
| string|DashboardTabBackgroundImageUrl||
| string|DashboardViewer||
| string|DatabaseDiagramImageUrl||
| int|DataCacheInterval||
| NameDistinctValueCollection|DataSourceAliases||
| NameStringsCollection|DataSourceCategories||
| TimeSpan|DataSourceDropDownTimeout||
| Unit|DataSourceDropDownWidth||
| string|DataSourceHeading||
| int|DataSourceLimit||
| int|DateArithmeticDecimalPlaces||
| string|Db2ConnectionString||
| string|DefaultAlternatingItemColor||
| string|DefaultHeaderForegroundColor||
| string|DefaultItemForegroundColor||
| int|DefaultItemsPerPage||
| int|DefaultLinesPerItem||
| string|DefaultLoadTab||
| int|DefaultPreviewResults||
| string|DefaultReportBorderColor||
| string|DefaultReportHeaderColor||
| string|DefaultReportItemColor||
| StringCollection|DefaultReportOrder||
| string|DefaultSharingRights||
| string|DefaultTable||
| string|DefaultUserName||
| string|DefaultVisibilityForNonAdmins||
| Unit|DescriptionWidth||
| NameValueCollection|DetailReportFormatString||
| bool|Distinct||
| bool|DistinctSubtotalInnerQuery||
| FormatCollection|DrillDownStyle||
| AggregateFunctionCollection|DundasAggregateFunctions||
| string|EmailFromAddress||
| string|EmailSubjectFormatString||
| bool|EmbedReportInServerEmail||
| int|EqualsDropDownLimit||
| int|EqualsDropDownTimeout||
| Dictionary<string,string[]>|EqualsPopupDestinations ||
| string|EqualsSelectDateFormat||
| int|EqualsSelectLimit||
| string|EqualsSelectText||
| int|EqualsSelectTimeout||
| string|ErrorIzendaReplacement||
| string[]|ExistingDatabaseConstraints||
| bool|ExpandCategorizedReports||
| bool|ExpandVisualGroupGrids||
| Font|ExportFont||
| int|ExportLimit||
| NameValueCollection|ExtendedFormats||
| string[]|ExtendedFunctions||
| NameValueCollection|FieldAliases||
| Unit|FieldDropDownWidth||
| string|FieldFilterRegex||
| int|FieldLimit||
| FieldList|FieldList||
| string|FieldsRegex||
| string|FieldValueCssUrl||
| Unit|FilterParameterWidth||
| string|FiltersCustomPagesPath||
| string|FiltersRegex||
| bool|ForceNewNameOnSave||
| Unit|FormatDropDownWidth||
| FormatCollection|Formats||
| string|FormDesignerUrl||
| Unit|FunctionDropDownWidth||
| int|GaugeHeight||
| double|GaugeMaximum||
| double|GaugeMinimum||
| string[]|GaugeStyles||
| int|GaugeWidth||
| bool|GenerateParameterizedSql||
| bool|GenerateThumbnails||
| string|GeoDataTable||
| GetEqualsSelectValuesDelegate|GetEqualsSelectValues||
| TableItemStyle|GridHeaderStyle||
| TableItemStyle|GridItemStyle||
| System.Drawing.Color|HeaderForegroundColor||
| string|HeaderStyle||
| NameValueCollection|HelpText||
| string[]|HiddenCategories||
| string[]|HiddenColumns||
| List|HiddenTimeZones||
| string|IdentifiersRegex||
| string|ImagesPath||
| bool|InheritFiltersInSubreports||
| string|InstantReport||
| bool|InvalidateSchemaOnNew||
| int|InvertedGridLimit||
| System.Drawing.Color|ItemForegroundColor||
| Unit|JoinDropDownWidth||
| JoinedTablesList|JoinedTablesList||
| string|JoinFieldRegex||
| NameValueCollection|LabelAliases||
| AdHocLanguage|Language||
| char|LiteralComma||
| bool|LockViewer||
| string|LoginUrl||
| MapInfoCollection|MapInfoCollection||
| Size|MaxImageSize||
| int|MaximumReportSizeForCache||
| Unit|MinPdfFontSize||
| bool|MultiLevelVisualGrouping||
| string|MySqlConnectionString||
| string|NoDataSourcePage||
| int|NumChartPerRow||
| int|NumChartTabs||
| int|NumSharedDropdowns||
| bool|OpenCustomUrlInNewWindow||
| int|OracleCommandTimeout||
| string|OracleConnectionString||
| ReportOutputGeneratorCollection|OutputTypes||
| string|ParentReportDesignerUrl||
| string|ParentReportListUrl||
| string|ParentReportViewerUrl||
| string|ParentSettingsUrl||
| bool|PerUserCaching||
| int|PivotFieldLimit||
| string|PostgreSQLConnectionString||
| int|PreviewColumnLimit||
| string|PreviewColumnLimitMessage||
| int|PreviewTimeout||
| PrintMode|PrintMode||
| ProcessFiltersDelegate|ProcessFiltersDelegate||
| int|QuickAddFieldWidth||
| int|QuickAddMinElementsInColumn||
| string|RDLFolder||
| int|RecentlyUpdatedCountAtReportList||
| System.Drawing.Color|ReportAlternatingItemColor||
| System.Drawing.Color|ReportBorderColor||
| string|ReportCss||
| string|ReportCssUrl||
| string|ReportDesignerUrl||
| System.Drawing.Color|ReportHeaderColor||
| System.Drawing.Image|ReportHeaderImage||
| string|ReportHeaderImageUrl||
| string|ReportingService2005Url||
| System.Drawing.Color|ReportItemColor||
| string|ReportList||
| ReportListSettings|ReportListSettings||
| ReportSetEventWatcherCollection|ReportSetEventWatchers||
| string|ReportsPath||
| bool|ReportsSharedByDefault||
| StorageMode|ReportStorageMode||
| ReportTypeCollection|ReportTypes||
| string|ReportViewer||
| int|ReportViewerDefaultPreviewResults||
| string|ReportViewerPostHtml||
| string|ReportViewerPreHtml||
| int|ReportViewerRefreshInterval||
| string|ReportViewPageTitle||
| bool|RequireLogin||
| string|ResponseServer||
| int[]|ResultsDropdownValues||
| string|SavedReportsTable||
| string|SaveReportSetNextUrl||
| string|ScheduledReportsUrlFormatString||
| SchedulerOutputCollection|SchedulerOutputTypes||
| string|SchedulerTenantID||
| TimeSpan|SchemaCacheTimeout||
| string|ScriptDirectory||
| Unit|SelectValueDropDownWidth||
| bool|ServiceMode||
| string|SettingsKey||
| string|SettingsPageUrl||
| string[]|SharedWithValues||
| bool|ShowAddAll||
| bool|ShowAddFieldInReportViewer||
| bool|ShowAdminButton||
| bool|ShowAdvancedChartingButton||
| bool|ShowAllInPreview||
| bool|ShowAllInResults||
| bool|ShowAllTables||
| bool|ShowArithmeticInSummary||
| bool|ShowArithmeticOperations||
| bool|ShowBackButton||
| bool|ShowBetweenDateCalendar||
| bool|ShowBulkCSVButton||
| bool|ShowCategoryTextboxInSaveDialog||
| bool|ShowChartLegend||
| bool|ShowChartTab||
| bool|ShowClientEmailButton||
| bool|ShowConstraintsSettings||
| bool|ShowContinueLinks||
| bool|ShowCSVButton||
| bool|ShowCustomFormatType||
| bool|ShowDashboardAddDropDown||
| bool|ShowDashboardFieldsTab||
| bool|ShowDashboardPartViewerLinks||
| bool|ShowDashboardSettings||
| bool|ShowDatabaseDiagramIcon||
| bool|ShowDatabaseTypes||
| bool|ShowDataSourcesAsCheckBoxes||
| bool|ShowDataSourcesTab||
| bool|ShowDataWhenParametersBlank||
| bool|ShowDescriptionsInReportsTab||
| bool|ShowDesignDashboardLink||
| bool|ShowDesignLinkInReportViewer||
| bool|ShowDesignLinks||
| bool|ShowDetailFormat||
| bool|ShowDistinct||
| bool|ShowDOCButton||
| bool|ShowEtlButton||
| bool|ShowFieldAsValueDropDown||
| bool|ShowFieldsTab||
| bool|ShowFieldValueCheckbox||
| bool|ShowFieldValueSummaryCheckbox||
| bool|ShowFilterFunctions||
| bool|ShowFilterLogic||
| bool|ShowFiltersInDashboards||
| bool|ShowFiltersInReportViewer||
| bool|ShowFiltersTab||
| bool|ShowFunctions||
| bool|ShowGaugePercentage||
| bool|ShowGaugeTab||
| bool|ShowGoButton||
| bool|ShowGradientBackground||
| bool|ShowGroupInFunctionDropdown||
| bool|ShowGroupMonth||
| bool|ShowHelpButton||
| bool|ShowHtmlAsCode||
| bool|ShowInTimePeriod||
| bool|ShowInvertSummaryCheckbox||
| bool|ShowInvisible||
| bool|ShowJoinDropDown||
| bool|ShowJustification||
| bool|ShowLinkFormats||
| bool|ShowLoadingForDesigner||
| bool|ShowLoadingOnDesignerLoad||
| bool|ShowLogoInPdf||
| bool|ShowMapTab||
| bool|ShowMenuInReportViewer||
| bool|ShowMiscTab||
| bool|ShowModifyButton||
| bool|ShowMultiLineControls||
| bool|ShowNewButton||
| bool|ShowNonIndexedJoinFields||
| bool|ShowODTButton||
| bool|ShowOnlineDocumentation||
| bool|ShowOpenOfficeButton||
| bool|ShowPDFButton||
| bool|ShowPivot||
| bool|ShowPoweredByLogo||
| bool|ShowPreviewTab||
| bool|ShowPublishRdlButton||
| bool|ShowRdlOutputIcon||
| bool|ShowRecentDatasources||
| bool|ShowRemoveAll||
| bool|ShowRemoveFieldInReportViewer||
| bool|ShowReportClassifiers||
| bool|ShowReportColor||
| bool|ShowReportingServicesSettings||
| bool|ShowReportsInHtmlOutput||
| bool|ShowReportsListAsDropDown||
| bool|ShowReportsTab||
| bool|ShowResponseServerDetails||
| bool|ShowRowButtons||
| bool|ShowRTFButton||
| bool|ShowSaveAsToolbarButton||
| bool|ShowSaveControls||
| bool|ShowSaveControlsInReportsTab||
| bool|ShowSaveInReportViewer||
| bool|ShowSaveRdlToolbarButton||
| bool|ShowScheduleControls||
| bool|ShowServerEmailButton||
| bool|ShowSettingsButton||
| bool|ShowSettingsButtonForNonAdmins||
| bool|ShowSharedCheckbox||
| bool|ShowSharingControl||
| bool|ShowSideHelp||
| bool|ShowSimpleModeViewer||
| bool|ShowSqlOutputIcon||
| bool|ShowStackTrace||
| bool|ShowStyleTab||
| bool|ShowSummaryLine||
| bool|ShowSummaryTab||
| bool|ShowTableNames||
| bool|ShowTenantField||
| bool|ShowTimeZoneDropdown||
| bool|ShowTopInFields||
| bool|ShowTopInSummary||
| bool|ShowVisualGroupLabels||
| bool|ShowWatermarkedExports||
| bool|ShowWaterMarks||
| bool|ShowWidth||
| bool|ShowXLSButton||
| string|SimpleFilterCssUrl||
| bool|SingleLineViewerToolbar||
| string|SmtpLogin||
| string|SmtpPassword||
| string|SmtpServer||
| bool|SortColumnNames||
| int|SqlCommandTimeout||
| string|SqlServerConnectionString||
| bool|StoreCurrentReportSetInApplication||
| int|StoredProcedureStringLimit||
| bool|StoreImagesToCache||
| bool|StrictANSIOuterJoin||
| bool|StripInvalidCharacters||
| string|SubCalculationFilterRegex||
| string|TabBackgroundImageUrl||
| NameDistinctValueCollection|TableAliases||
| Unit|TableDropDownWidth||
| string|TableFilterRegex||
| string|TabsCss||
| string|TabsCssUrl||
| string|TempFiles||
| string|TemplatesPath||
| string|TenantField||
| int|ThumbnailHeight||
| int|ThumbnailWidth||
| Unit|TimePeriodDropDownWidth||
| int|TimeZoneOffset||
| SchedulerTimeZoneCollection|TimeZones||
| string|ToolbarBackgroundImageUrl||
| string|ToolbarBorderColor||
| string|ToolbarCssUrl||
| string|UnCategorizedReportsMenuItemTitle||
| bool|UseAdvancedGauge||
| bool|UseBulkCSV||
| bool|UseColumnNameForDashboardCommonFilters||
| bool|UseConstraintsForJoins||
| bool|UseDefaultDialogs||
| bool|UseFriendlyErrors||
| bool|UseImageDescriptions||
| bool|UseNoLock||
| bool|UseNonPostbackDeleting||
| bool|UseNonPostbackExport||
| bool|UseNonPostbackPreview||
| bool|UseNonPostbackServerEmailing||
| bool|UseReportID||
| bool|ValidateBeforeSave||
| bool|ViewsOnly||
| string[]|VisibleDataSources||
| string[]|VisibleTables||
| VisualGroupStyle|VisualGroupStyle||