Izenda, LLC

Ad Hoc Reports & Dashboards for ASP.NET Apps

Free Trial

Izenda Reports is licensed on a "per user" or "per server" basis. Please complete this form to receive a price quote.

All fields are required.

The live demo demonstrates Izenda reports with the Northwind Sample database. To login, please register below.

All fields are required.

You can download a full time-limited trial version here. Or, email a CSV file to data@izenda.com and our sales team will create several complementary reports on our demo environment.

All fields are required.

How do I use other built-in SQL functions?

Expand / Collapse
 

How do I use other built-in SQL functions?


In order to add more functions to the "functions" drop-down in the Fields and other tabs, you use the extended functions setting. In your global.asax file, inside of ConfigureSettings(), place this code:

AdHocSettings.ExtendedFunctions = new string[] { "STDEV","LOG"};

The setting uses an array of strings, each of which correspond to built-in SQL functions. In this example, we have added the log function and standard deviation function to the drop-down. The will now be available for selection in the report designer.



Details
Type: FAQ
Options