| A |
| 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. |  |
| AdHocConfig | Gets or sets the current AdHocConfig - Ad Hoc configuration. | |
| AdHocUserKey | If the user would like to require a password before people enter the Izenda Report application they can set a password here. | |
| 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. | |
| AllowBreaksOnHeading | Gets or sets a value indicating whether breaks are allowed in report grid header. | |
| 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 icon from the report list page. Clicking on the red x delete icon deletes the report. | |
| AllowDeltas | Gets or sets the value indicating whether "Add Deltas" checkbox should be shown in fields. | |
| AllowFieldsAsValue | Gets or sets the value indicating whether should not be postback on report sever emailing. | |
| AllowGroupWithoutSelect | Gets or sets value indicating visibility fields marked as invisible. | |
| AllowHtmlOutputsInScheduledReports | Adds HTML and XLS output capability to the Send Email As drop-down in the schedule controls. | |
| AllowInvertedGrid | Allows the inverted checkbox to be shown in the Summary tab. 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 checkbox enables/disables the user 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. | |
| AllowSummaryDeltas |
Gets or sets the value indicating whether "Show Summary Deltas" checkbox should be shown in the summary tab.
AllowDeltas feature MUST be turned on to use this feature.
| |
| AllowVisualGroups | Gets or sets the value indicating whether visual groups are allowed. | |
| AutoJoinOnRenderedRows | Gets or sets the value indicating whether auto-join function should work for server-rendered rows in JoinedTablesList. | |
| C |
| CacheEqualsSelect | Gets or sets the value indicating whether "Equals (Select)" value should be cached. | |
| 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. | |
| CheckConnectionString | Checks if the connection string is valid, if not, it displays error. | |
| CheckForUpdates | Gets or sets the value indicating whether AdHoc is checking for updates. | |
| ColumnDropDownWidth | Gets or sets the value indicating the width of the dropdown for Fields dropdown boxes. | |
| Culture | Gets or sets the default culture for Ad Hoc. | |
| CurrentUserIsAdmin | Tells AdHoc whether the current user is an Admin user. | |
| CurrentUserName | Gets or sets the name of the current user. | |
| CustomTimePeriods | Gets custom time periods, that can be used in filters. | |
| D |
| 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. | |
| DataSourceDropDownTimeout | Gets or sets the timeout between starting loading dropdown values from server and redirecting to About page. | |
| DataSourceDropDownWidth | Gets or sets the width of data source dropdown. | |
| 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. | |
| 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 | This setting set the number of fields shown per line. 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. | |
| DefaultLoadTab | Sets the default tab that loads when a report is loaded in report designer. By default this goes to the preview tab and shows a report preview. | |
| DefaultPreviewResults | This changes the default number of results 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. | |
| DefaultReportOrder | Gets or sets the default report order. | |
| DefaultTable | Gets or sets the default table which is automatically added to new report. | |
| 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. | |
| DescriptionWidth | Gets or sets the width of description edit. | |
| Distinct | This checkbox tells Izenda Reports whether the report results should be distinct. The distinct checkbox is located on the datasources tab of the report designer page. | |
| DistinctSubtotalInnerQuery | Gets or sets the value indicating whether DISTINCT option should be used in inner query for the subtotals calculating. | |
| E |
| EmailFromAddress | This text box allows the user to set the email from address for the automated scheduler. | |
| EmailSubjectFormatString | This text box allows the user to set the subject of the emailed report. By default it uses the report name as the subject of the email. | |
| EqualsDropDownLimit | Limits the number of (options) rows selectable through an equals (drop down) filter. These filters can be found in the filter 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. | |
| EqualsDropDownTimeout | This setting allows the user to increase the database query time for building the drop down selection options. If you have a large or unoptimized database increasing this setting can help with proper reporting performance. | |
| EqualsSelectDateFormat | This textbox allows the user to specify the default date format utilized by the equals select filters. Equals select date filters can be found in the filters tab of report designer and then selecting a date field. | |
| EqualsSelectLimit | Limits the number of (options) rows selectable through an equals (drop down) filter. These filters can be found in the filter 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. If you have a large or unoptimized database increasing this setting can help with proper reporting performance. | |
| 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. | |
| ExtendedFormats | Gets or sets the collection of names and values of additional formats which should be displayed in "Formats" dropdown lists. | |
| ExtendedFunctions | This list allows the user specify additional SQL functions to be used on their data. For example: Log | |
| F |
| FieldAliases | This feature let's you dynamically alter the field names that the user sees on a per-user basis. This is useful for localization and when custom fields are used in your application. | |
| FieldDropDownWidth | Gets or sets the width of field dropdown. | |
| FieldFilterRegex | This setting allows the user to use a regular expression to filter certain fields from being added to the report through the fields tab in the 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 so they are not listed as a field option. | |
| 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. | |
| FilterParameterWidth | Gets or sets the width of filter parameter edit. | |
| ForceNewNameOnSave | This feature always uses the save as function 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 dropdown. | |
| Formats | Gets or sets the FormatInfoCollection. | |
| FunctionDropDownWidth | Gets or sets the width of function dropdown. | |
| G |
| GaugeHeight | Gets or sets the gauge height for "Gauge" format. | |
| GaugeMaximum | Gets or sets the maximum value of gauge. | |
| GaugeMinimum | Gets or sets the minimum value of gauge. | |
| GaugeWidth | Gets or sets the gauge width for "Gauge" format. | |
| GenerateParameterizedSql | Gets or sets the value indicating whether queries to the database should be parameterized. | |
| H |
| HeaderStyle | Gets or sets the style for the JoinedTablesList, FieldList and FilterList headers. | |
| 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. | |
| I |
| InvalidateSchemaOnNew | Gets or sets the value indicating whether database schema is invalidated then user creates new report. | |
| InvertedGridLimit | Gets or sets the maximum count of rows for inverted grid. | |
| J |
| JoinDropDownWidth | Gets or sets the width of join type dropdown. | |
| 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. | |
| L |
| LicenseKey | In this text box the Izenda license key must be entered for Izenda Reports to function in the correct version. | |
| LiteralComma | Gets or sets the delimiter for values for Value. | |
| 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. | |
| M |
| 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. | |
| MinPdfFontSize | Sets the minium font size that will be used when creating a PDF document. Default is 10 point. | |
| MultiLevelVisualGrouping | Gets or set value indicating whether Visual Groups should be multi-level. | |
| MySqlConnectionString | Gets or sets the connection string for MySQL. | |
| O |
| 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. | |
| OracleCommandTimeout | Sets the minumum time Izenda Reports will wait for an Oracle command to execute before timing out. | |
| OracleConnectionString | Gets or sets the connection string for Oracle Server. | |
| OutputTypes | Gets or sets the registered ReportOutputGenerators. | |
| P |
| PivotFieldLimit | Sets the limit for how many pivot columns are in a report. | |
| PreviewTimeout | This setting allows the user to increase the query time required by Izenda Reports on the database. Increasing this setting maybe necessary for large or unoptimized databases. | |
| R |
| ReportAlternatingItemColor | Gets or sets the color of report alternating item. | |
| ReportBorderColor | Gets or sets the color of report border. | |
| ReportCssUrl | This setting allows the user to specify their own css file to be used on reports generated by Izenda Reports. | |
| ReportDesignerUrl | | |
| 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. | |
| ReportHeaderImageUrl | This setting allows the user to set a report header image to be used on reports. | |
| ReportingService2005Url | Gets or sets the base URL of the XML Web service. | |
| ReportItemColor | Gets or sets the color of report item. | |
| ReportList | | |
| ReportsPath | This textbox specifies the 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. | |
| ReportsSharedByDefault | Enables/disables the default setting of saved report as being shared. If the report is shared it can be seen by everyone regardless of the username / usergroup. | |
| ReportViewer | | |
| ReportViewerDefaultPreviewResults | This textbox specifies the default number of results previewed in the report view page 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. | |
| ReportViewerPostHtml | Gets or sets the string contains html code that placing after the entire HtmlOutputReportResults section. | |
| ReportViewerPreHtml | Gets or sets the string contains html code that placing before the entire HtmlOutputReportResults section. | |
| ReportViewerRefreshInterval | Gets or sets the milliseconds between preview auto-refresh. If 0 then there no auto-refresh. | |
| RequireLogin | This setting tells Izenda Reports to use the login page specified above in the Login URL setting. | |
| ResponseServer | Gets or sets the URL of the ResponseServer page. | |
| S |
| SavedReportsTable | Gets or sets the table name for saved reports. | |
| ScheduledReportsUrlFormatString | This text box allows the user to set the url that is sent via email as the report web address. | |
| SchemaCacheTimeout | Gets or sets the time span for schema caching. | |
| SelectValueDropDownWidth | Gets or sets the width of filter values dropdown. | |
| SettingsLoadedException | | |
| SettingsPageUrl | Gets or sets the URL of the Settings page. | |
| ShowAddAll | This checkbox turns on the "Add All" button to the fields tab in report designer. Clicking this button adds all of the fields for the selected table or view so that you don't have to add each field to the report one at a time. | |
| ShowAddFieldInReportView | This checkbox enables or disables the ability of the user to add fields to the report in report viewer. | |
| ShowAdminButton | Gets or sets the value indicating showing buttons for administration. | |
| ShowAdvancedChartingButton |
This checkbox enables/disables advanced button from being shown in the charts tab of report designer. Some of the advanced features are as follows:
Trend charts – separators (commonly used with dates), legend, value labels
Pie Chart – separators, legend, 3d, and explode largest and percentages of the pie
Plot Charts – legend
Bar Charts - legend
Sort Column Names – this checkbox enables/disables the sorting of data in drop down boxes including field names, data sources, etc.
| |
| 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 in the summary tab 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. | |
| ShowBackButton | This checkbox enables/disables the back button from the Izenda Reports toolbars. The back button is used for navigating within the web application. | |
| ShowCategoryTextboxInSaveDialog | Removes the category box from the "Save" and "Save As" dialog boxes. | |
| ShowChartLegend | This setting sets the default behavior as to whether charts should show legends. | |
| 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. | |
| 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. | |
| ShowContinueLinks | This setting enables or disables the "Continue to" buttons in report designer that assist walking a user through the tabs in report designer. | |
| ShowCustomFormatType | Gets or sets the value indicating whether "Custom" format type should be shown in formats dropdown. | |
| ShowDatabaseTypes | Gets or set value indicating whether database types should be shown in the fields dropdown. | |
| 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.
Note: Do not disable unless you have set a default table in the “other” tab of the settings page.
| |
| ShowDataWhenParametersBlank | Gets or sets the value indicating whether data should be shown in report viewer if all parameters is blank. | |
| ShowDescriptionsInReportsTab | Gets or sets the value indicating whether reports descriptions should be shown in the reports tab of AdHocReportDesigner. | |
| ShowDesignLinks |
This enables or disables the design links which are the pencil icons in the report list. Which when clicked allow the user to modify the report.
Note: If you disable this button you may also be interested in disabling the show modify button in the report viewer. This feature is under the toolbar tab on the settings page.
| |
| 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. | |
| 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. | |
| ShowFieldValueCheckbox | Gets or sets the value indicating whether "Field|Value" checkbox should be shown in the Field tab. | |
| ShowFieldValueSummaryCheckbox | Gets or sets the value indicating whether "Field|Value" checkbox should be shown in the Summary tab. | |
| ShowFilterFunctions | This feature allows you to filter based off of a field with a function applied. For example let's say that you were summing the freight cost in the fields tab. In the report you wanted to see the customers that you spent over $5000 on freight shipping to. When you go to the filter tab at the bottom of the list you will see [Sum (freight)] and you can select this field to filter your data with. | |
| 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. | |
| ShowFunctions | This enables functions to be used on the fields such as count, group, etc. This is automatically populated based on the datatype. | |
| 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. | |
| ShowGoButton | This checkbox enables/disables the go button from the Izenda Reports toolbars. The go button applies the changes and updates the report preview. | |
| 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. | |
| ShowInTimePeriod | Gets or sets the value indicating whether "In Time Period" item is shown in operators dropdown. | |
| ShowInvertSummaryCheckbox | Gets or sets the value indicating whether "Invert" checkbox should be shown in the Summary tab. | |
| ShowInvisible | Allows showing the invisible checkboxes in the Fields Tab, in the Fields area. | |
| ShowJoinDropDown | Gets or sets the value indicating whether join type dropdown should be shown in the JoinedTablesList. |