| Code |
| AdHocConfig | Gets or sets the current AdHocConfig - Ad Hoc configuration. |  |
| AllowAnalysisGrid | Gets or sets the value indicating whether it is allowed analysis grid.
The option appears in the Visual Group Style combobox at the Style tab in the ReportDesigner. | |
| 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.
If set, AdHoc checks if table in database for keeping reportsets exists, and creates it if necessary. | |
| AllowComparativeArithmetic | Gets or sets the value indicating whether comparative arithmetic is allowed in arithmetic checkbox.
Comparative operators appear in "A" checkboxes at the Fields tab in the ReportDesigner. | |
| AllowDeltas | Gets or sets the value indicating whether "Add Deltas" checkbox should be shown at the fields tab in the ReportDesigner.
Any time there is a change in a quantity that change is calculated by taking the later value for that quantity and subtracting from it the earlier value for that quantity. | |
| AllowGroupWithoutSelect | Gets or sets value indicating if it is possible to make invisible fields which are used for Visual Grouping.
If set, fields with both "Hide This Field" (in the advanced properties) and "VG"; flags set, will not lead to report being considered as invalid. | |
| AllowSummaryDeltas |
Gets or sets the value indicating whether "Show Summary Deltas" checkbox should be shown in the summary tab in the ReportDesigner.
Any time there is a change in a quantity that change is calculated by taking the later value for that quantity and subtracting from it the earlier value for that quantity.
AllowDeltas feature MUST be turned on to use this feature.
| |
| CacheEqualsSelect | Gets or sets the value indicating whether "Equals (Select)" value should be cached.
Caching "Equals (Select)" can be usefull if you have problems with performance in your data base or slow connection to it. But data in cache may be not relevant if it is updated very often in the data base. So, use this setting carefully. | |
| CacheQueries | Gets or sets the value indicating whether all queries for the Driver should be cached. | |
| CacheSchema | Gets or sets the value indicating whether DatabaseSchema should be cached.
Disable schema caching may be useful if you data base schema changes very often. But ussually it is better to use caching because it will prevent extra queries to the data base. | |
| CascadeFilterValues | Gets or sets the value indicating whether filter values at the Filters tab in the ReportDesigner will be cascaded. For example, this will only show cities in the country selected on the prior filter by country | |
| Charts | Gets or sets the collection of available Charts.
Collection of available charts is shown in the Chart Type combobox at the Cart tab in the ReportDesigner. | |
| Culture | Gets or sets the default culture for Ad Hoc.
Note: use this only in special cases. Normally you should use Language setting for localization, see links below:
Language
Izenda Language Pack | |
| CurrentUserIsAdmin | Tells AdHoc whether the current user is an Admin user. Admins may see and overrite all reports for that tenant | |
| CurrentUserName | Sets the name of the current user. This is required for multi-user security. | |
| CustomizeChartDelegate | Represents a method that runs before chart reports get run. | |
| CustomTimePeriods | Defines custom time periods, accessible in 'In Time Period' filter operator at the Filters tab in the ReportDesigner.
You can easily add new custom time periods to the predefined time periods list.
Note: There are several overloads for CustomTimePeriod constructor, so you can define different time periods with various types. | |
| DashboardDesignerUrl | Gets or sets the URL of a page used to design dashboards (DashboardDesigner). | |
| DashboardDesignerUrlWithDelimiter | Gets the DashboardDesignerUrl with "?" or "&" char at the end. | |
| DashboardFieldsCount | Gets or sets the count of additional reports.
Affects ReportDesigner when ShowDashboardFieldsTab is true. | |
| DashboardGaugeWidth | Gets or sets the gauge width for "Dashboard Gauge" format.
This will affect width of gauges when they are shown in the dashboards. | |
| DashboardTabBackgroundImageUrl | Gets or sets the URL of the tabs background image for Dashboard. | |
| DataSourceDropDownTimeout | Gets or sets the timeout between starting loading dropdown values (in the DataSources dropdown at the Data Sources tab in the ReportDesigner) from server and redirecting to About page. | |
| DefaultReportOrder | Gets or sets the default report order at they Style tab in the ReportDesigner. | |
| DistinctSubtotalInnerQuery | Gets or sets the value indicating whether DISTINCT option should be used in inner query for the subtotals calculating. | |
| ExportFont | Gets or sets the font for the PDF and RTF outputs. | |
| ExtendedFunctions | This list allows the user specify additional SQL functions to be used on their data. For example: Log | |
| FieldAliases | This feature let's you dynamically alter the field names that the user sees in the Report Designer, on a per-user basis. This is useful for localization and when custom fields are used in your application. | |
| Formats | Gets or sets the list of available fields formats.
This affects Formats dropdown at the Fields tab of the ReportDesigner for example.
Note: You could use Formats to add new custom formats. For example, adding new format for Europe-style date: AdHocSettings.Formats["EuroDate"] = "{0:dd/MM/yyyy}"; | |
| GaugeHeight | Gets or sets the gauge height for "Gauge" format.
This will affect height of gauges when they are shown in reportsets.
Note: This setting will affect only Linear Gauges. | |
| GaugeWidth | Gets or sets the gauge width for "Gauge" format.
This will affect width of gauges when they are shown in reportsets.
Note: This setting will affect only Linear Gauges. | |
| GenerateParameterizedSql | Gets or sets the value indicating whether queries to the database should be parameterized. | |
| GetEqualsSelectValues | Represents a method that returns values for Equals_Select operator.
This handles the list of values shown at the Fields tab in the ReportDesigner in the Value(s) combobox if Equals(Select) operator is used. | |
| GridHeaderStyle | Gets or sets the OpenOffice output style for report results grid header. | |
| GridItemStyle | Gets or sets the OpenOffice output style for report results grid item. | |
| HeaderStyle | Gets or sets the CSS style for the headers in Fields, Summary and Filters tabs. | |
| 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.
Can be seen in the ReportDesigner if ShowSideHelp is enabled.
Note: You can also enable/disable side help by clicking Help button (AdHocSettings.ShowHelpButton should be enabled). | |
| ImagesPath | Gets or sets the path of the folder which contains the images used by Ad Hoc. If the value is a null reference then built-in images will be used. | |
| InvalidateSchemaOnNew | Gets or sets the value indicating whether database schema should be invalidated when user creates new report. | |
| InvertedGridLimit | Gets or sets the maximum count of rows for inverted grid.
This affects maximum count of rows when AllowInvertedGrid flag is enabled and set in the ReportDesigner. | |
| LiteralComma | Gets or sets the delimiter separating items in the 'Equals' filter operator value.
If Equals operator is selected at the Filters tab in the ReportDesigner, AdHoc looks for LiteralComma char in the Value(s) textbox, and if found, splits Value(s) textbox value by this char to the several items and fills textbox with these items delimited by comma. | |
| 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. | |
| OutputTypes | Gets or sets the registered ReportOutputGenerators. | |
| RDLFolder | Gets or sets path to Folder where RDL files would be saved. | |
| ReportAlternatingItemColor | Gets or sets the color of report alternating item.
Records in the grid are shown with interleaving of two background colors. Those two colors are called ItemColor and AlternatingItemColor. | |
| ReportBorderColor | Gets or sets the color of report border. | |
| ReportHeaderColor | Gets or sets the color of report header. | |
| ReportHeaderImage | Gets or sets the image which will be shown at the top of the report. | |
| ReportingService2005Url | Gets or sets the base URL of the XML Web service. | |
| ReportItemColor | Gets or sets the color of report item.
Records in the grid are shown with interleaving of two background colors. Those two colors are called ItemColor and AlternatingItemColor. | |
| ReportSetEventWatchers | Gets or sets the collection of registered IReportSetEventWatcher which can do some actions on ReportSet-related events. | |
| ReportViewerPostHtml | Gets or sets the string contains html code that will be placed after the entire HtmlOutputReportResults section.
This can be seen in the ReportViewer in the bottom page after the report body. | |
| ReportViewerPreHtml | Gets or sets the string contains html code that placing before the entire HtmlOutputReportResults section.
This can be seen in the ReportViewer in the top of the page before the report body. | |
| ReportViewPageTitle | Gets or sets the title of report view page.
This text can be seen as the title of browser window when ReportViewer is opened. | |
| ResponseServer | Gets or sets the URL of the ResponseServer page. | |
| ResponseServerWithDelimiter | Gets the ResponseServer page with "?" or "&" char at the end. | |
| SchemaCacheTimeout | Gets or sets the time span for schema caching. | |
| SettingsPageUrl | Gets or sets the URL of the Settings page. | |
| ShowCustomFormatType | Gets or sets the value indicating whether "Custom" format type should be shown in formats dropdown.
If set, custom formats will be available in Format dropdown, for example, at the Fields tab in the ReportDesigner. | |
| ShowDashboardFieldsTab | Gets or sets the value indicating whether AdHocReportDesigner tab with dashboard fields is shown. | |
| ShowFieldValueCheckbox | Gets or sets the value indicating whether "Field|Value" checkbox for main report should be shown at the Style tab in the ReportDesigner. | |
| ShowFieldValueSummaryCheckbox | Gets or sets the value indicating whether "Field|Value" checkbox for summary should be shown at the Style tab in the ReportDesigner. | |
| ShowGroupInFunctionDropdown | Gets or sets the value indicating whether GROUP feature should be shown as a function at the Fields tab in the ReportDesigner. Otherwise, it will be shown as a separate checkbox. | |
| ShowInTimePeriod | Gets or sets the value indicating whether "In Time Period" item is shown in operators dropdown.
If enabled, this can be found at the Filters tab in the Operator combobox in the ReportDesigner. | |
| ShowMultiLineControls | Gets or sets the value indicating whether "Multi-Line" feature is enabled.
If enabled, "Stacked Lines Per Grid Row" control appears at the Style tab in the ReportDesigner. | |
| ShowNonIndexedJoinFields | Gets or sets the value indicating whether non-indexed join fields should be shown.
This setting affects fields lists in all fields dropdowns in the ReportDesigner. If it is set, non-indexed fields are not shown in the dropdowns. Affects only Join fields dropdowns at the Data Sources tab, when AdHocSettings.ShowDataSourcesAsCheckBoxes is false. | |
| ShowReportClassifiers | Gets or sets the value indicating whether ReportClassifiers control should be shown at the "Misc" tab of the ReportDesigner. | |
| ShowReportColor | Gets or sets the value indicating whether report color (Item and AlternatingItem) dropdowns are shown at the Style tab in the ReportDesigner. | |
| ShowRowButtons | Gets or sets the value indicating whether insert and move buttons should be shown at the Fields tab in the ReportDesigner against fields. | |
| ShowSaveControlsInReportsTab | Gets or sets the value indicating whether save controls should be shown in the reports tab of AdHocReportDesigner. | |
| ShowSaveRdlToolbarButton | Gets or sets the value indicating whether "Save As RDL" button, performing saving RDL file at the server side, should be shown in the AdHocToolbarNavigation. | |
| ShowScheduleControls | Defines whether or not the scheduling controls are show at the Misc tab in the ReportDesigner. | |
| ShowWatermarkedExports | Gets or sets the value indicating whether watermarked export should be used on license errors. | |
| ShowWaterMarks | Gets or sets the value indicating whether watermarks should be used on license errors. | |
| StripInvalidCharacters | Gets or sets the value indicating whether invalid characters in report names should be striped.
If disabled, non-literal characters will not be stripped from the report name, entered in the Report Designer in Save As dialog. | |
| TabsCssUrl | Gets or sets the css stylesheet URL for the TabStrip. | |
| UseAdvancedGauge | Gets or sets the value indicating whether advanced is used for "Gauge" format.
If disabled, there will be simple bar instead of gauge with divisions. Affects only Linear gauges. | |
| UseFriendlyErrors | Gets or sets the value indicating whether friendly errors should be shown on exceptions. | |
| UseNonPostbackDeleting | Gets or sets the value indicating whether should not be postback on report deleting. | |
| UseNonPostbackExport | Gets or sets the value indicating whether should not be postback on report export. | |
| UseNonPostbackPreview | Gets or sets the value indicating whether should not be postback on report preview. | |
| UseNonPostbackServerEmailing | Gets or sets the value indicating whether should not be postback on report sever emailing. | |
| Database |
| Db2ConnectionString | Gets or sets the connection string for DB2. | |
| LicenseKey | In this text box the Izenda license key must be entered for Izenda Reports to function in the correct version. | |
| MySqlConnectionString | Gets or sets the connection string for MySQL. | |
| OracleConnectionString | Gets or sets the connection string for Oracle Server. | |
| SqlServerConnectionString | Gets or sets the connection string for MS SQL Server. | |
| 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. | |
| ViewsOnly | ViewsOnly should be used if you would like all views visible and only views visible at the Data Sources tab.
Note: ViewsOnly will not work if you also use VisibleDataSources.
Use cases:
1) Tables and fields may have not very user-friendly names. Creating Views with user-friendly names can make working process with database much more easier and clear.
2) You may not want to allow users to work with tables in your database because they may contain sensitive information or consist of raw data useless for reports. Creating Views with proper data aggregation may help you to build better reports with relevant data.
| |
| Email & Scheduling |
| EmailFromAddress | Setting for "email from" address for the automated scheduler. | |
| EmailSubjectFormatString | Setting for subject of the emailed reports. By default it uses the report name as the subject of the email. | |
| ScheduledReportsUrlFormatString | This text box allows the user to set the url that is sent via email as the report web address.
If user selects in the scheduling controls sending report as link, this value will be used to form that link. | |
| SmtpServer | This textbox allows the user to set the SMTP server used by your company to send out emails. | |
| Features |
| AllowDataFieldsInDescription | This checkbox enables/disables the ability to allow a data field to be used in the description of the report (which is set in the misc tab). This is particularly useful in drill down reports and those reports with filters. For example: Let's say we are filtering a report by the field CategoryName and the value Produce. For the Description we enter: [CategoryName] details. This will show on the report as Produce details and dynamically change when the user changes the filter value. | |
| AllowDeletingReports | This checkbox enables/disables the delete icons at the report list page against reports names, for the current user. Clicking on the red x delete icon deletes the report. | |
| AllowFieldsAsValue | Gets or sets the value indicating whether field name is allowed in filter value.
If set, values like "Is Less Than (Field)" appear in the Operator combobox at the Filters tab in the ReportDesigner. Fields comparison allows you to compare values from one field with values from another field.
| |
| AllowInvertedGrid | Allows the inverted checkbox to be shown in the Summary tab in the ReportDesigner. Inverted grid means it exchanges columns for rows (up to 36 rows) | |
| AllowNewFiltersInReportViewer | This checkbox enables/disables the ability to add new filters in the report viewer page of Izenda Reports. Note: Current filters used on the report will still be displayed. | |
| AllowOverwritingReports | This enables/disables the current user's ability to overwrite reports currently saved. An example of this usage is that many users create base reports for their users to use. Disabling the overwrite report feature ensures that the default reports are not tampered with. | |
| DefaultItemsPerPage | This setting changes the default items shown in the report viewer per page. For example let's say a report had 150 items. By default this value is set to 100. So 100 items would be on the first page. When the user scrolls to the bottom of the page they will see a link that shows 101-150. When the user clicks on it the remaining report items will be shown. | |
| DefaultLinesPerItem | Gets or sets the default count of lines per item for "Multi-Line" feature. The default value is 1 and is listed in the style tab of report designer as field/value common pairs. Let's say that you have a report with 12 fields. This report would be difficult to print. By changing this value to 2 the grid would be 6 fields wide instead of 12. This is a feature commonly used in accounting style reports. | |
| DefaultPreviewResults | This changes the default number of results (records) shown in the report designer preview tab. When exporting all results always will be exported. Web browsers are not designed to show reports with hundreds of thousands of lines so keep this in mind when changing this setting. This should be set to a power of 10 such as 1, 10, 100, or 1000. | |
| Distinct | Sets the default value of the distinct checkbox. The distinct checkbox is located on the datasources tab of the report designer page. | |
| PivotFieldLimit | Sets the limit for how many pivot columns are in a report.
User can click Add Pivot button at the Fields tab in the ReportDesigner and select field for pivot with a lot of values, each of them will be shown as an additional column in the report. Given setting limits maximum number of such additional columns. | |
| ShowAdvancedChartingButton | This checkbox enables/disables advanced button from being shown in the Chart tab of Report Designer. | |
| ShowAllInPreview | This checkbox enables or disables the all from the preview results drop down box in report designer. If you have reports with lots of data say 5,000+ lines you may want to disable the all preview otherwise a user may select it in a web browser when previewing the report. Since web pages aren't meant to be designed with that much data using this selection may make the browser appear to be "locked up." Exporting the data will always export all results. | |
| ShowAllInResults | This checkbox enables or disables the all from the results drop down box in report viewer. If you have reports with lots of data say 5,000+ lines you may want to disable the all preview otherwise a user may select it in a web browser when previewing the report. Since web pages aren't meant to be designed with that much data using this selection may make the browser appear to be "locked up." Exporting the data will always export all results. | |
| ShowArithmeticInSummary |
This feature enables arithmetic operations multiway checkbox to be enabled at the Summary tabs of Report Designer. Arithmetic operations allows the user to design reports that involve adding, subtracting, multiplying, or dividing one field by another field.
Note: arithmetic operations must be enabled to use arithmetic in summary
| |
| ShowArithmeticOperations | This feature enables arithmetic operations multiway checkbox to be enabled in the Fields tab of Report Designer. Arithmetic operations allows the user to design reports that involve adding, subtracting, multiplying, or dividing one field by another field. The operation is done on the current field and the field above it in the fields tab. | |
| ShowCategoryTextboxInSaveDialog | Gets or sets the value indicating whether category dropdown should be shown in the save dialog.
If false, when user clicks Save As in the Report Designer, popup dialog window will not contain dropdown field which allows to define category for the report to be saved. | |
| ShowChartLegend | This setting sets the default behavior as to whether charts should show legends. | |
| ShowContinueLinks | This setting enables or disables the "Continue to" buttons in report designer that assist walking a user through the tabs in report designer. | |
| ShowDatabaseTypes | Gets or set value indicating whether database types should be shown in the fields dropdowns.
When true, data types of fields will be visible in fields dropdowns at the Fields and other tabs in the ReportDesigner. | |
| ShowDesignLinks | Gets or sets a value indicating whether design links should be shown in report list and in the toolbar.
If false, then pencil icons againts reports names in the ReportList will be invisible. | |
| 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 at the Filters tab in the ReportDesigner. | |
| ShowFunctions | This enables functions to be used on the fields such as count, group, etc. This is automatically populated based on the datatype.
If disabled, all Function dropdowns disappear in the ReportDesigner. | |
| ShowJoinDropDown | Gets or sets the value indicating whether join type dropdown should be shown in the JoinedTablesList.
This can be found at the Data Sources tab in the ReportDesigner, if ShowDataSourcesAsCheckBoxes is disabled. | |
| ShowJustification | This feature enables the justification box to be shown in the Advanced Properties of a field at the Fields tab of Report Designer. Using this box allows the user to set the justification for the field in the report. | |
| ShowMenuInReportViewer | This checkbox enables/disables the menu in the Report Viewer. | |
| ShowPivot | This checkbox enables/disables the option of adding pivots to reports.
If set, "Add Pivot" button appears at the Fields tab in the ReportDesigner. | |
| ShowPoweredByLogo | This checkbox enables or disables the Powered by Izenda logo in Izenda Reports. | |
| ShowReportsListAsDropDown | Gets or sets the value indicating whether reports displayed in Archive tab should be hyperlinks or should be items of dropdown list box. True if reports should be displayed as hyperlinks. False if reports should be displayed as items of dropdown list box. | |
| ShowSimpleModeViewer |
This feature enables or disables the Simple Mode of Report Viewer which disables the ability to load another report, export the report, and add fields. If the report has a filter it can be used to update the report results.
Simple Mode just shows the report & current used filters. It allows the ability to change the current filter.
Simple mode removes ability to export or add additional filters.
| |
| ShowTopInFields | This feature allows you to specify how much data you want returned in the grid section of the report by specifying it in the fields tab of report designer. By default it returns all. | |
| ShowTopInSummary | This feature allows you to specify how much data you want returned in the summary section of the report by specifying it in the summary tab of report designer. By default it returns all. | |
| Images & CSS |
| DatabaseDiagramImageUrl | Setting an image here allows the user to show a database diagram image through the report designer that shows the table relationships. These can be created through Microsoft SQL. Izenda recommends using tables to simplify the prejoin complex related tables. | |
| ReportCssUrl | This setting allows the user to specify their own css file to be used on reports generated by Izenda Reports. | |
| ReportHeaderImageUrl | This setting allows the user to set a report header image to be used on reports. | |
| TabBackgroundImageUrl | Setting an image here allows the user to customize the look of the background image for the tab section of the report designer. | |
| ToolbarBackgroundImageUrl | Setting an image here allows the user to customize the look of the background image for the toolbar section of the report designer. | |
| ToolbarCssUrl | Gets or sets the css stylesheet URL for the Toolbar. | |
| Other |
| ColumnDropDownWidth | Gets or sets the value indicating the width of the dropdown for dropdown boxes at the Fields tab in the ReportDesigner. | |
| DataSourceHeading | This textbox renames the heading within the Data Sources tab of Report Designer. Some users rename this since some users may not be familiar with database terminology. | |
| DefaultTable | Gets or sets the default table which is automatically added to new report.
The table must be present in the database and be accessible. | |
| DescriptionWidth | Gets or sets the width of description edit at the Fields tab in the ReportDesigner. | |
| EqualsSelectText | This textbox allows the user to specify the wording for the equals (drop down) filter. This option is found in the filter tab of report designer in the operator drop down box. | |
| ErrorIzendaReplacement | Gets or set value which will replace the word "Izenda" in StackTrace when exception occurs. | |
| ExpandCategorizedReports | This checkbox enables/disables the categorized reports to be expanded underneath each category in the report list and in the report designer's report tab. | |
| ExpandVisualGroupGrids | This checkbox enables/disables the visual grouped data details to be expanded underneath each visual grouping in the report viewer and in the report designer's preview tab.
I.e. when enabled all visual groups will be expanded automatically when you open report. | |
| FieldDropDownWidth | Gets or sets the width of field dropdown at the Fields tab in the ReportDesigner. | |
| FilterParameterWidth | Gets or sets the width of filter parameter value edit.
This can be seen at the Filters tab in the ReportDesigner, if Equals operator selected. | |
| ForceNewNameOnSave | This feature forces usage of the Save As function always and requires the user to specify a report name when saving. If another report has the same name Izenda Reports warns the user. Note: Also consider “allow overwriting reports†function in the Other tab of the settings page (described previously in this section). | |
| FormatDropDownWidth | Gets or sets the width of Format dropdowns in the Report Designer. | |
| FunctionDropDownWidth | Gets or sets the width of Function dropdowns in the Report Designer. | |
| JoinDropDownWidth | Gets or sets the width of join type dropdown.
These dropdowns can be found at the Data Sources tab of the ReportDesigner when ShowDataSourcesAsCheckBoxes is set to false. | |
| MinPdfFontSize | Sets the minium font size that will be used when creating a PDF document. Default is 10 point. | |
| OpenCustomUrlInNewWindow | This checkbox enables/disables the functionality of opening a new window when a custom url link is clicked (custom url is enabled as the format of a field in the fields tab of report designer.) If this is not enabled the current page will change to the clicked on link. If the user would like to keep up the current report and open the new page then keep this feature enabled. | |
| ReportDesignerUrl |
Gets or sets the URL of a page used to design reports.
| |
| ReportList | Gets or sets the URL of the report list page. If null or empty the Report List button in toolbar will be hidden. | |
| ReportsPath | This field folder in which Izenda Reports will keep the reports in when filesystem mode is enabled. Note: Be sure the folder exists and has the correct network user permissions specified. | |
| ReportViewer | Gets or sets the URL of the report viewer page. | |
| ReportViewerDefaultPreviewResults | This textbox specifies the default number of results in the Report Viewer for all reports. Izenda does not recommend setting this to a large number such as 5000 or larger as the html report will take a long time to generate. If you would like to view all the data we recommend exporting the report which always provides the entire report. | |
| SavedReportsTable | Gets or sets the table name for saved reports. If DatabaseAdHocConfig is used, reports data will be saved in this table in the database. By default this is IzendaAdHocReports table. | |
| SelectValueDropDownWidth | Gets or sets the width of filter values dropdown.
This affects width of filtering value combobox, which appears at the Filters tab in the ReportDesigner when user selects Equals(Select) operator. | |
| ShowStackTrace | Gets or sets the value indicating format for showing exceptions. | |
| SortColumnNames | Gets or sets the value indicating whether dropdowns with column names are sorted alphabetically.
If set, columns names will be sorted alphabetically in Field dropdowns at the Fields tab in the ReportDesigner | |
| TableDropDownWidth | Gets or sets the width for the Data Sources dropdown box in the Data Sources Tab of the ReportDesigner. | |
| Performance |
| DataSourceLimit | This setting limits the number of data sources Izenda Reports allows to be used as data sources in a single report. Data sources are set in the data sources tab on the report designer page. | |
| EqualsDropDownTimeout | This setting allows the user to increase the database query time for building the drop down selection options at the Filters tab in the Report Designer. If you have a large or unoptimized database increasing this setting can help with proper reporting performance. | |
| EqualsSelectLimit | Limits the number of (options) rows selectable through an equals (drop down) filter. These filters can be found in the Filters tab of Report Designer and in the report viewer when an equals (drop down) filter is utilized. Note by default this is set to either 500 or 1000 rows. If for example you have 2 choices (true and false) and the false value is not in the first 1000 rows then true will be the only option showed unless you increase this number. | |
| EqualsSelectTimeout | This setting allows the user to increase the database query time for building the drop down selection options at the Filters tab in the Report Designer. If you have a large or unoptimized database increasing this setting can help with proper reporting performance. | |
| FieldLimit | This setting limits the number of fields Izenda Reports allows to be used in a single report. Fields are set in the fields tab on the report designer page. | |
| OracleCommandTimeout | Sets the time Izenda Reports will wait for an Oracle command to execute before timing out. | |
| PreviewTimeout | Sets the minumum time Izenda Reports will wait for a MS SQL command to execute before timing out. | |
| SqlCommandTimeout | Gets or sets the wait time in seconds for database command dropdown values loading. | |
| TimePeriodDropDownWidth | Gets or sets the width of time period dropdown. | |
| Security |
| AddAllFilterRegex | This setting allows the user to use a regular expression to filter certain fields from being added through the "Add All" button (the "Add All" button can be turned on in the features tab of the settings guide and is added in the fields section of report designer). An example of when this may be used is if you don't want social security numbers added to reports you could add part of the name of that field to the regular expression. | |
| AdHocUserKey | A single password limiting access to the report designer, report list and report viewer. This is for projects that do not need multi-user security. | |
| DefaultUserName | This settings allows the user to set the default username for users logged into the Izenda Reports web application. User names are shown on the report list and on the reports tab of report designer. | |
| JoinFieldRegex | This setting allows the user to use a regular expression to filter certain fields from being the join field between data sources in the data sources tab of report designer. For example, to show only fields ending with "ID", use following value: AdHocSettings.JoinFieldRegex = "^.*(?<!id)$"; | |
| LoginUrl | This setting allows the user to specify their own login page to be utilized by Izenda Reports. Note to utilize this login page the "Require Login" check box must be selected. | |
| ShowHtmlAsCode | This feature enables/disables showing HTML code containing in database fields as plain text.
If set, all data from database like "< input type="text">" will be shown as text. If not set, you will see them as rendered html controls directly inside the rendered reportset html. | |
| RequireLogin | This setting tells Izenda Reports that system will use authorization. So, it will use the login page specified in the LoginUrl setting. | |
| SubCalculationFilterRegex | This setting allows the user to use a regular expression to filter certain numeric fields from having subcalculation function options when selected in the fields tab of report designer. For example let's say the user does not want the subcalculation function (such as sum or average) for ID fields create the regular expression to filter here. | |
| UnCategorizedReportsMenuItemTitle | This setting allows the user to specify the report folder name for uncategorized reports. This name will be used in report viewer with menu mode. The mode in which www.izenda.com/livedemo runs. | |
| SharedWithValues | This sets the users or roles available in the Shared With dropdown of the Misc tab in the Report Designer. | |
| Tabs |
| DefaultLoadTab | Sets the default tab that loads when a report is loaded in report designer. By default this goes to the fields tab. | |
| ShowChartTab | This checkbox enables/disables the charts tab from the Izenda Reports application report designer page. The chart tab allows the user to add or modify trend, pie, plot, and bar charts in a report through the report designer. | |
| ShowDataSourcesTab |
This checkbox enables/disables the data sources tab from the Izenda Reports application report designer page. The data sources tab allows the user to add or modify data sources (tables and views) used in a report through the report designer.
| |
| ShowFieldsTab | This checkbox enables/disables the fields tab from the Izenda Reports application report designer page. The fields tab allows the user to add or modify the fields reported on in a report, the functions used on them, the descriptions, and the formatting of the field through the report designer. | |
| ShowFiltersTab | This checkbox enables/disables the Filters tab from the Izenda Reports application report designer page. The filters tab allows the user to add or modify filters used on report data through the report designer. | |
| ShowGaugeTab | This checkbox enables/disables the gauges tab from the Izenda Reports application report designer page. The gauges tab allows the user to add or modify gauges used in a report through the report designer. | |
| ShowMiscTab | This checkbox enables/disables the misc tab from the Izenda Reports application report designer page. The misc tab allows the user to set the title, description, header, footer, report scheduler settings (if enabled), and report access permissions for a report through the report designer. | |
| ShowPreviewTab | This checkbox enables/disables the preview tab from the Izenda Reports application report designer page. The preview tab allows the user to view the current report so they can quickly see any modifications and the report layout through the report designer. | |
| ShowReportsTab | This checkbox enables/disables the Reports tab from the Izenda Reports application report designer page. The reports tab allows the user to load currently saved reports to preview or modify through the report designer. | |
| ShowStyleTab | This checkbox enables/disables the style tab from the Izenda Reports application report designer page. The style tab allows the user to modify the report colors, print options, visual group advanced options, report order, set report viewer items per page, and modify field value / report layout options through the report designer. | |
| ShowSummaryTab | This checkbox enables/disables the summary tab from the Izenda Reports application report designer page. The summary tab allows the user to add or modify a summary section in a report through the report designer. | |
| ShowTableNames | Gets or sets the value indicating whether colums should be grouped by table name. Otherwise show columns as "ColumnName(TableName)". | |
| Toolbar |
| ShowBackButton | This checkbox enables/disables the back button from the Izenda Reports toolbars. The back button is used for navigating within the web application.
This button can be found, for example, in the ReportViewer or ReportDesigner. | |
| ShowClientEmailButton | This checkbox enables/disables the client email button from the Izenda Reports toolbars. The client email button when clicked launches the users default email program and allows the user to email the url to the link to another person. | |
| ShowGoButton | This checkbox enables/disables the Go button from the Izenda Reports toolbars. The go button applies the changes and updates the report preview. | |
| ShowNewButton | This checkbox enables/disables the New button from the Izenda Reports toolbars. The new button launches report designer and begins the new report creation process. | |
| ShowPublishRdlButton | Gets or sets the value indicating whether publish rdl button, performing publishing RDL using ReportingService2005, should be shown at the toolbar in the ReportDesigner. | |
| ShowRdlOutputIcon | Gets or sets the value indicating whether rdl button, performing sending RDL file to the client, should be shown at the toolbar in the ReportDesigner. | |
| ShowSaveAsToolbarButton | This checkbox enables/disables the save as button from the Izenda Reports toolbar in report designer. The save as button allows the user to specify the category and report name. | |
| ShowSaveControls | This feature disables the save controls (save and save as icons in the toolbar) from report designer. Some users use this feature when they do not want users to modify their base reports. | |
| ShowServerEmailButton | This checkbox enables/disables the server email button from the Izenda Reports toolbars. The server email button when clicked requests the email of the person to send the report to and does so through the SMTP server setup in the email & scheduling tab of the settings page. | |
| ShowSettingsButton | This checkbox enables/disables the settings button from the Izenda Reports toolbars. The settings button launches the settings page which allows for customization and setup of Izenda Reports.
Allows showing Settings button in the toolbar in the ReportDesigner. | |