#Code Samples

##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

##Global Application

##General

  • Inherit filters in the subreport
  • Storing Reports in Database and Fusion Driver
  • Overriding Driver Methods
  • Using constraints
  • Custom Report Viewer Export Button
  • Dymamically changing the database with url parameter
  • Create Button to Switch Databases
  • Secure https on a load balancer
  • Control names change randomly when deployed from development to production
  • Placement of custom code
  • 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
  • Support Active Directory/Windows Authentication
  • Controlling access to tables and views
  • 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
  • Setting the user and administrator state

##Report List

  • Writing your own Report Lists
  • Turn off Report List Dropdown and Report List Button
  • Hiding Report List Buttons
  • Change or Remove Report Review Menu Buttons

##Report Designer

##Report Management

  • SaveReportSet()
  • DeleteReportSet()
  • LoadReportSet()
  • ListReports()

##Report Viewer

  • Displaying Filter Names in the Report
  • How to add/remove values to results dropdown
  • Override/Changing Behavior for Popups
  • Adding New Items to Time Period Dropdown List
  • Code Sample for Export Button
  • Creating Custom Export Buttons on the Report Viewer
  • Report Viewer Page Code Samples

##SQL

##Appearance

##API

  • Adding custom filters to the dashboards. MVC application
  • Adding custom filters to the dashboards
  • Reports and tenants
  • How to dynamically change TimeZone in post-process
  • Web Farms / Gardens / Clusters / Load Balancers / Clouds / Azure
  • How to use Driver.AddForcedLeftJoin
  • How Can I Archive Reports?
  • Overriding AdHocConfig
  • Secure https on a load balancer
  • How can I add the system date and time into my report?
  • How to post-process data
  • Dynamically Creating Reports Via the API
  • Applying Security for Owner of the Report Out of Scheduler
  • Creating Custom Exporters
  • Graphs are visible on development server (local) but not on production server (public)
  • How do I hide the settings page button or aspx page from users?
  • Run User/Role Related Code, Connection-String before Global Settings
  • Passing Username/Password Credentials with Connection String when Login
  • Logging the Loading Exception when "No Fields Selected" Occurs
  • 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
  • Hiding Read Only Check Box
  • Reducing Server Trips in AdhocConfig Methods
  • Getting the Report Name
  • Changing the response server page ( rs.aspx ) for custom errors or redirects

Izenda Logo