☰
Current Page
Main Menu
Home
Home
Editing CodeSamples
Edit
Preview
H1
H2
H3
default
Set your preferred keybinding
default
vim
emacs
markdown
Set this page's format to
AsciiDoc
Creole
Markdown
MediaWiki
Org-mode
Plain Text
RDoc
Textile
Rendering unavailable for
BibTeX
Pod
reStructuredText
Help 1
Help 1
Help 1
Help 2
Help 3
Help 4
Help 5
Help 6
Help 7
Help 8
Autosaved text is available. Click the button to restore it.
Restore Text
#Code Samples [[_TOC_]] ##Introduction Here we will provide snippets of programming code in various languages applicable to Izenda Reports and Dashboards that will allow you to modify and enhance your reporting solution. _**Note:** Some of the items below are listed more than once. This is because they apply to more than one area of Izenda Reports._ ##Login Page * [[Authentication Function|/Tutorials/CodeSamples/Login-Sample]] * [[Controlling user logins and login customization|http://wiki.izenda.com/Tutorials/CodeSamples/Login-Sample]] ##Global Application * [[Secure https on a load balancer|http://wiki.izenda.com/FAQ/Questions/Secure-https-on-a-load-balancer]] * [[How can I apply a hidden filter using an inner query|/FAQ/applying-hidden-filter-using-inner-query]] * [[ProcessEqualsSelectList()|/FAQ/ProcessEqualsSelectList]] * [[CustomizeChart()|/FAQ/CustomizeChart]] * [[Introduction to the Global.asax file|/API/AdHocConfig]] * [[InitializeReporting()|/FAQ/InitializeReporting]] * [[Session_Start()|/FAQ/Session-Start]] * [[Add Formatting to Grid or New Formats to Formats Dropdown|/FAQ/Questions/Add-Formatting-Options]] ##General * [[Inherit filters in the subreport|http://wiki.izenda.com/Guides/ReportDesign/9.0-Misc-Tab#9.2.6-Passing-Filters-from-Master-Report-to-Sub-Report]] * Storing Reports in Database and Fusion Driver * [[Overriding Driver Methods|http://wiki.izenda.com/Guides/Izenda-AdHoc-Driver#Overriding-CustomFusionDriver-Methods]] * Using constraints * [[Custom Report Viewer Export Button|http://wiki.izenda.com/API/CodeSamples/ReportViewer/Custom-Export-Buttons]] * [[Dymamically changing the database with url parameter|http://wiki.izenda.com/FAQ/switching-databases-via-code#Using-the-Query-String]] * [[Create Button to Switch Databases|http://wiki.izenda.com/FAQ/switching-databases-via-code]] * [[Secure https on a load balancer|http://wiki.izenda.com/FAQ/Questions/Secure-https-on-a-load-balancer]] * [[Control names change randomly when deployed from development to production|http://wiki.izenda.com/FAQ/Questions/Control-Names-Break-In-Production]] * [[Placement of custom code|http://wiki.izenda.com/API/AdHocConfig]] * Turn off or Change the Background Gradient of the Trend Chart * User Defined Function (UDF) in SQL 2000/2005 * Switching from File System to Database mode ##Security * [[Basic security sample|http://wiki.izenda.com/FAQ/Questions/Applying-Security]] * Support Active Directory/Windows Authentication * [[Controlling access to tables and views|http://wiki.izenda.com/API/CodeSamples/ViewsOnly]] * Switching databases via code * Using PreExecuteReportSet to control data level access * Using query string, dynamically set connection string and authenticate against hash * Using ListReports() to control report access * [[Controlling access to fields|http://wiki.izenda.com/API/CodeSamples/FieldsRegex]] * [[Setting the user and administrator state|http://wiki.izenda.com/FAQ/How-user-credentials-are-applied#Setting-the-user]] ##Report List * Writing your own Report Lists * Turn off Report List Dropdown and Report List Button * [[Hiding Report List Buttons|http://www.izenda.com/Site/KB/CodeSamples/Hiding-Report-List-Buttons]] * [[Change or Remove Report Review Menu Buttons|http://wiki.izenda.com/API/CodeSamples/ShowReportsInHtmlOutput]] ##Report Designer * Override/Changing Behavior for Popups * [[Adding New Items to Time Period Dropdown List|http://wiki.izenda.com/FAQ/Questions/Adding-Custom-Time-Periods]] * [[Create Custom Field Aliases|http://wiki.izenda.com/API/CodeSamples/FieldAliases]] * [[Control names change randomly when deployed from development to production|http://wiki.izenda.com/FAQ/Questions/Control-Names-Break-In-Production]] * [[Report Designer Page Code Samples|/API/CodeSamples/ReportDesigner]] * [[Add and Remove Report Designer Toolbar Buttons|http://wiki.izenda.com/API/CodeSamples/ReportDesigner#Toggling-toolbar-buttons]] * [[Showing Side Help in the Desigher|http://wiki.izenda.com/API/CodeSamples/HelpText]] ##Report Management * [[SaveReportSet()|/FAQ/SaveReportSet]] * [[DeleteReportSet()|/FAQ/DeleteReportSet]] * [[LoadReportSet()|/FAQ/LoadReportSet]] * [[ListReports()|/FAQ/ListReports]] ##Report Viewer * [[Displaying Filter Names in the Report|http://wiki.izenda.com/Guides/ReportDesign/5.0-Filters-tab#5.6-Other-Filter-Features]] * [[How to add/remove values to results dropdown|http://wiki.izenda.com/FAQ/Questions/modify-report-viewer-results-dropdown-menu]] * [[Override/Changing Behavior for Popups|]] * [[Adding New Items to Time Period Dropdown List|http://wiki.izenda.com/FAQ/Questions/Adding-Custom-Time-Periods]] * [[Code Sample for Export Button|http://wiki.izenda.com/API/CodeSamples/ReportViewer/Custom-Export-Buttons]] * [[Creating Custom Export Buttons on the Report Viewer|http://wiki.izenda.com/API/CodeSamples/ReportViewer/Custom-Export-Buttons]] * [[Report Viewer Page Code Samples|http://wiki.izenda.com/FAQ/Questions/hiding-report-viewer-buttons]] * [[Collapse Filter Panel on Load|http://wiki.izenda.com/FAQ/Questions/collapse-filter-panel-on-load]] ##SQL * [[Join data sources with composite keys|http://wiki.izenda.com/API/CodeSamples/Using-Constraints]] * [[LEFT OUTER and FULL OUTER joins|http://wiki.izenda.com/Guides/ReportDesign/3.0-Data-sources-tab#3.1.1-Simple-Mode-Allow-Nulls]] * [[Different JOIN types and Filters|http://wiki.izenda.com/FAQ/Questions/Different-Join-Types-and-Filters]] * [[Configure LEFT OUTER JOIN filters|http://wiki.izenda.com/FAQ/Questions/Different-Join-Types-and-Filters]] * [[Add "Forms" column to the IzendaAdHocReports table manually|/FAQ/IzendaAdHocReports-table]] * [[Create IzendaAdHocReports table manually|http://wiki.izenda.com/FAQ/IzendaAdHocReports-table]] * [[Pulling Data From Analysis Services Cubes|]] * [[Combining Multiple Event Based Fields with UNION|http://wiki.izenda.com/FAQ/Questions/Combining-Fields-with-Union]] * [[Organizing Dates by Week|http://wiki.izenda.com/Integration/Tutorials/Views]] * [[1 Million Record View|/API/CodeSamples/1 Million Record View]] ##Appearance * [[Adding Custom Formats|/FAQ/Questions/Add-Formatting-Options]] * [[Report List CSS Code Sample|/FAQ/Questions/Overriding-page-level-css]] ##[[API|/API/AdHocConfig]] * [[Adding custom filters to the dashboards. MVC application|/FAQ/Questions/Adding-custom-filters-to-dashboards]] * [[Adding custom filters to the dashboards|/FAQ/Questions/Adding-custom-filters-to-dashboards]] * [[Reports and tenants|http://wiki.izenda.com/FAQ/Questions/reports-and-tenants]] * [[How to dynamically change TimeZone in post-process|http://wiki.izenda.com/FAQ/Questions/reports-and-tenants]] * [[Web Farms / Gardens / Clusters / Load Balancers / Clouds / Azure|]] * [[How to use Driver.AddForcedLeftJoin|http://wiki.izenda.com/API/CodeSamples/AddForcedLeftJoin]] * [[How Can I Archive Reports?|http://wiki.izenda.com/FAQ/ArchiveReportOutput]] * [[Overriding AdHocConfig|http://wiki.izenda.com/API/AdHocConfig]] * [[Secure https on a load balancer|http://wiki.izenda.com/FAQ/Questions/Secure-https-on-a-load-balancer]] * [[How can I add the system date and time into my report?|API/CodeSamples/How-can-I-add-the-system-date-and-time-into-my-report]] * [[How to post-process data|http://wiki.izenda.com/FAQ/ProcessDataSet]] * [[Dynamically Creating Reports Via the API|http://wiki.izenda.com/API/CodeSamples/DynamicReportCreation]] * [[Applying Security for Owner of the Report Out of Scheduler|http://wiki.izenda.com/FAQ/Questions/Applying-Security-to-Scheduled-Reports]] * [[Creating Custom Exporters|http://wiki.izenda.com/API/CodeSamples/ReportViewer/Custom-Export-Buttons#C♯-Sample]] * [[Graphs are visible on development server (local) but not on production server (public)|http://wiki.izenda.com/FAQ/Questions/Graphs-not-visible]] * [[How do I hide the settings page button or aspx page from users?|http://wiki.izenda.com/API/CodeSamples/ShowSettingsButton]] * [[Run User/Role Related Code, Connection-String before Global Settings|http://wiki.izenda.com/Tutorials/CodeSamples/Login-Sample]] * [[Passing Username/Password Credentials with Connection String when Login|http://wiki.izenda.com/API/CodeSamples/SqlServerConnectionString#Specifying-Username-and-password]] * [[Logging the Loading Exception when "No Fields Selected" Occurs|http://wiki.izenda.com/FAQ/LoadReportSet#Logging-Loading-Exceptions]] * [[Dynamically Changing Data Sources|http://wiki.izenda.com/FAQ/Questions/Dynamically-Changing-Data-Sources]] * [[Using Custom Time Period Setting|]] * [[Show How Many Records Returned to the Grid from SQL|]] * [[Override Equals Select Drop-Down Used in the "Filter" Tab & Report Viewer|http://wiki.izenda.com/FAQ/ProcessEqualsSelectList]] * [[Hiding Read Only Check Box|http://wiki.izenda.com/API/CodeSamples/ShowSharingControl]] * [[Reducing Server Trips in AdhocConfig Methods|http://www.izenda.com/Site/KB/CodeSamples/Reducing-Server-Trips-in-AdhocConfig-Methods-]] * [[Getting the Report Name|]] * [[Changing the response server page ( rs.aspx ) for custom errors or redirects|http://www.izenda.com/Site/KB/CodeSamples/Code-Sample-for-Export-Button]]
Uploading file...
Header
 **This documentation is for the legacy Izenda 6 product. Documentation for the new Izenda 7 product can be found at [[https://www.izenda.com/docs/|https://www.izenda.com/docs/]]**
Sidebar
 --- * [[Izenda 7 Series Documentation|https://www.izenda.com/docs/]] * [[Release Notes]] * [[Upgrade Best Practices|FAQ/Izenda-Update-Best-Practices]] * [[FAQ]] * [[Tutorials]] * [[The Izenda API|/API/AdHocConfig]] * [[The AdHocSettings class|/API/AdHocSettings]] * [Developer Links and Guides](/Guides/Developer-Links-and-Guides) * [[Known Issues]] --- * <a href="http://www.izenda.com" rel="nofollow" target="_blank">Izenda Website</a> * [Product Video](https://www.youtube.com/watch?v=X3-yWFq0w5A) * <a href="http://www.izenda.com/blog" rel="nofollow" target="_blank">Izenda Blog</a> * <a href="http://www.izenda.com/company/" rel="nofollow" target="_blank">About Us</a> * <a href="http://www.izenda.com/contact-us/" rel="nofollow" target="_blank">Contact Us</a> --- * [Guide To Report Design](/Guides/ReportDesign) * [Making Custom Forms Video](http://www.youtube.com/watch?v=5b2axJlgdFs) --- * [[Acknowledgements]]
Edit message:
Cancel