☰
Current Page
Main Menu
Home
Home
Editing ChartSortFields
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
#ChartSortFields [[_TOC_]] ##About Gets or sets the list of additional columns that are used to sort chart data. This will apply only when using charts that have an additional chart element, such as Pareto charts. The resulting chart will sort elements according to any sort already specified by the report designer plus the value of the separator column. The strings entered into the array should be the column name without the schema and table. _**Note:** The wildcard "*" denotes the list of existing sort items on the chart._ ##Global.asax (C♯) ```csharp //main class: inherits DatabaseAdHocConfig or FileSystemAdHocConfig public class CustomAdHocConfig : Izenda.AdHoc.DatabaseAdHocConfig { // Configure settings // Add custom settings after setting the license key and connection string by overriding the ConfigureSettings() method public static void InitializeReporting() { //Check to see if we've already initialized. if (HttpContext.Current.Session == null || HttpContext.Current.Session["ReportingInitialized"] != null) return; AdHocSettings.LicenseKey = "INSERT_LICENSE_KEY_HERE"; //Creates a connection to Microsoft SQL Server AdHocSettings.SqlServerConnectionString = "INSERT_CONNECTION_STRING_HERE"; Izenda.AdHoc.AdHocSettings.AdHocConfig = new CustomAdHocConfig(); AdHocSettings.ChartSortFields = new string[] {"*", "ShipCountry"}; //The relevant setting HttpContext.Current.Session["ReportingInitialized"] = true; } } ``` ##Global.asax (VB.NET) ```visualbasic 'main class: inherits DatabaseAdHocConfig or FileSystemAdHocConfig Public Class CustomAdHocConfig Inherits Izenda.AdHoc.DatabaseAdHocConfig Shared Sub InitializeReporting() 'Check to see if we've already initialized If HttpContext.Current.Session Is Nothing OrElse HttpContext.Current.Session("ReportingInitialized") IsNot Nothing Then Return 'Initialize System AdHocSettings.LicenseKey = "INSERT_LICENSE_KEY_HERE" AdHocSettings.SqlServerConnectionString = "INSERT_CONNECTION_STRING_HERE" Izenda.AdHoc.AdHocSettings.AdHocConfig = New CustomAdHocConfig() AdHocSettings.ChartSortFields = New String() {"*", "ShipCountry"} 'The relevant setting HttpContext.Current.Session("ReportingInitialized") = True End Sub End Class ``` ##Screenshots A sample report definition. Note the chart's "line value" field value.  AdHocSettings.ChartSortFields = {"*", "ShipCountry"}  ###Query Results ```sql SELECT DISTINCT TOP 10 [dbo].[Employees].[LastName] AS 'Label', SUM([dbo].[Orders].[Freight]) AS 'Value', [dbo].[Shippers].[CompanyName] AS 'Separator', COUNT([dbo].[Orders].[ShipCountry]) AS 'LineValue' FROM [dbo].[Orders] WITH(NOLOCK) INNER JOIN [dbo].[Shippers] WITH(NOLOCK) ON [dbo].[Shippers].[ShipperID]=[dbo].[Orders].[ShipVia] INNER JOIN [dbo].[Customers] WITH(NOLOCK) ON [dbo].[Customers].[CustomerID]=[dbo].[Orders].[CustomerID] INNER JOIN [dbo].[Employees] WITH(NOLOCK) ON [dbo].[Employees].[EmployeeID]=[dbo].[Orders].[EmployeeID] GROUP BY [dbo].[Employees].[LastName], [dbo].[Shippers].[CompanyName] ORDER BY SUM([dbo].[Orders].[Freight]) DESC, COUNT([dbo].[Orders].[ShipCountry]); ``` AdHocSettings.ChartSortFields = null  ###Query Results ```sql SELECT DISTINCT TOP 10 [dbo].[Employees].[LastName] AS 'Label', SUM([dbo].[Orders].[Freight]) AS 'Value', [dbo].[Shippers].[CompanyName] AS 'Separator', COUNT([dbo].[Orders].[ShipCountry]) AS 'LineValue' FROM [dbo].[Orders] WITH(NOLOCK) INNER JOIN [dbo].[Shippers] WITH(NOLOCK) ON [dbo].[Shippers].[ShipperID]=[dbo].[Orders].[ShipVia] INNER JOIN [dbo].[Customers] WITH(NOLOCK) ON [dbo].[Customers].[CustomerID]=[dbo].[Orders].[CustomerID] INNER JOIN [dbo].[Employees] WITH(NOLOCK) ON [dbo].[Employees].[EmployeeID]=[dbo].[Orders].[EmployeeID] GROUP BY [dbo].[Employees].[LastName], [dbo].[Shippers].[CompanyName] ORDER BY SUM([dbo].[Orders].[Freight]) DESC; ```
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