27th Jan 2022 - Emailer 1. Updated emailer to support resending of Dashboards. ( Emailnow for Dashboards) 2. Updated Mailbee.dll to the latest version to better support newer Versions of TLS. Older versions like 1.0/1.1 are becoming more Depracted, and this version better supports TLs 1.2/1.3 You will need to re-register this dll, with REgsvr32 in admin mode, or rerun the setup, with ADmin rights 3. Added new command line option called -tlsprotocol to explicitly force the version of TLs -tlsprotocol 6 will force TLS 1.2 -tlsprotocol 7 will force TLS 1.3 When running on windows 7/ Windows 2008, it may try to use TLS 1.1, which is no longer supported by Office 365 29th April 2021 - Emailer 1. Bug fix relating to MYOB emailer 25th Jan 2021 - Emailer 1. Added function -sendfailed, which attempts to resend all emails stored in the 'Failed' folder. 07th Jan 2021 Emailer 1. Added functions -sendemail and -savemessage and -sendmessage. Both functions need a 'Sent' and a 'Failed' folder in the emailer folder. 10th Oct 2019 Emailer 1. Fixed a bug for support for Report IDs>32768. It still wasn't actually sending these emails correctly. 28th Sept 2019 Emailer 1. Added support to the emailer for Report ID > 32768. ( I.e. Support for longs ) 27th Sept 2019 IR 1. The Add Group By Dialog, that opens, when you click on a report, now sorts the Group By Dimensions Alphabetically 2. Comparison Report, keeps the order of the date ranges, and no longer swaps them. The old behaviour, wass if the first Land Hand Date is before the first Right Hand Date, it then swaps all the comparison dates ranges. The intent of this behaviour was that the most recent date range would be on the left, and the oldest date range on the right. This convention suited some of our early users, but it is leading to annoyance, and or confusion for others. Our change, is to leave the date ranges the user entered, and just calculate the correct variance. What we will do, is to add a feature to look at the pair of date ranges, and add a multiplier of -1 depending on which date range starts first, and apply that to the variance calculations, so that you still get accurate results. 3.Fix for grouped/comparison charts in dashboards not rendering with certain tables 4. Added new Mapping Where clause Text Search and Replace. You can maintain this through the Mapping Admin Add &debug=1 to the sql on a sample report, to help develop. Example that should work with Northwind. Search Text #ZZZLastCust$ Replace with SQL select '#WOLZA$' as newValue from ( select sum(1) from products ) as xyz The Replace With SQL is executed if Search Text is found inside the body of the sql statement of the report. It should return 1 row exactly, with a column name of newValue This is turned off by default, and is enabled by editing utilities_boolean.asp This feature also requires a mapping_replace table be created. 5. New Checkbox option in Dashboards, to allow you to force a pagebreak between consecutative report segments. 6. New Donut Chart Visualization 7. Fixed a potential issue where MappingJoins where not being cloned, when you used the Clone Template and Mapping feature. 12th Nov 2018 IR 1. Added Support for SAP Hana. You may need to add the Hana entry to your database_types table in system33.mdb, so the option appears. 2. Columns names in Sap Hana are case sensitive. Redo Datatypes will now explicitly set the case sensitivity of the column. 6th Nov 2018 IR 1. Security Enhancement 2. Fix for grouped/comparison charts in dashboards not rendering with certain tables 3. When running against Sql server/InMemory.Net datasources, IR now looks for the presence of a last_updated table with a field called last_updated, and display a last_updated header in the reports. 4. Cloud Reporting admin enhancement. 5. Dashboards now support upto 20 consecutive elements 6. When emailing dashboards, there is a chekbox option to force elements to be put on a separate page, when emailing PDFs. 5th July 2018 IR 1. Fixed a bug in emailed grouped reports, where it was defaulting to the new GL Mode. 08th June 2018 IR Updates 1. Added new report property to sort groups in grouped reports by the key of the group. 2. Fixed a bug in comparison reports with 2 levels of grouping, where the grouped subtotals weren't being calculated for one of the sets of grouped data, when the metric was a derived SUM. 3. If you put into the mapping html description, then it will remove all excess total wordings in the reports, and just display a simple group name. 4. ( Beta ) Analysis reports no longer display dots in empty rows, instead a unicode   is used. 5. The new build adds support for a /*dbexec and dbexec*/ tags in the mapping sql, that contain the dynamic sql ( or stored procedures), you want to execute against your mapping datasource. It needs to be preceded by a dummy sql, that returns the rights columns and appropriate datatypes, so the mapping admin can run. The resulting code, must return a resultset containing a string field named sql_to_exec, that contains the ultimate sql you would like to use for the mapping table. You can help debug things by adding &debug=1 to the url, and it should display each dynamic table, and the ultimate sql for each. @user_custom1, @user_custom2 Variables are supported. Example Contents for a northwind mapping. SELECT Orders.OrderID, CustomerID, EmployeeID, OrderDate, ProductID, UnitPrice, Quantity, CostPrice FROM Orders LEFT JOIN [Order Details] dets ON Orders.OrderID=dets.OrderID /*dbexec select 'SELECT Orders.OrderID, CustomerID, EmployeeID, OrderDate, ProductID,UnitPrice, Quantity, CostPrice FROM Orders LEFT JOIN [Order Details] dets ON Orders.OrderID=dets.OrderID where 1=@user_custom1' as sql_to_exec dbexec*/ This allows the mapped sql to be dynamically generated by a stored procedure. 6. Sorted list of mappings and lookups in the 'Copy Lookups' module. 08th June 2018 Emailer Updates 1. If an excel object cannot be created, then the html file will be simply renamed with and .xls extension 2. Added command line parameters -reporttimeout and -apppoolname a. When a report times out, if the -reporttimeout parameter is detected, then the emailer will call the batch file, restartapppool.bat which will restart the IR application pool in IIS. b. If the application pool name differes from the default IR_APP_POOL_v33 then the actual name can be passed in using -apppoolname c. The emailer manual has been updated with new commands e.g. emailer.exe –reporttimeout –apppoolname your_app_pool_name 3. Fixed a bug, where emailed reports where displaying old favorite titles. IR stores the original favorite title as part of the url when saving WHen favorites are edited, this is not update. 30/01/2018 1. Added page number to a report exported to PDF 30 Jan 2018 1. Added page number to emailer report when exported to PDF. 02th nov 2017 1. Added date to the log file when sending test emails in the config form. 12th Oct 2017 1. Bug fixed in Emailer when scheduled_details contains a null value 2. Added function -connectionstring to Emailer 3. Updated emailer documentation 16th May 2017 1. Added new 10,11,12 Consecutive Layours to Dashboards 2. Added Locale support to Organisations. 3. Fixed a bug, when refreshing the detail report was loosing columns, or giving an error in certain cases. 4. Fixed a bug where certain reports were failing to email. 22nd Feb 2017 1. Turned off SqlDebug feature, that was causing some unnecessary errors in 26th Jan Build. 08th Feb 2017 1. Updated Emailer. Fixed bug when using Relativemdb in configure form. 2. Updated the MailBee.dll file 26th Jan 2017 1. Fixed a bug in Clone User, that was causing the default dashboard feature not to work 2. Fixed a bug in the detail report, where have a date ( by date ) dimension and grouping by it was causing a SQL Error 3. Updated Northwind demo data to 2016/17 4. Added support for using Memo fields in User_Access to provide longer security filters. 5. Improved menu changes for charting in hamburger menu 6. Added last_login tracking feature for users login. ( Turned off by default ) 7. Added company_id to email_log for sites using multi company feature 21st Dec 2016 1. Added new Color Picker, that works with latest version of Chrome 2. Added Hamburger menu to mobile version 3. Fixed a bug causing duplicate favorites, when using org level stats 4. Added a clone user feature to the admin. 5. Added EmailLog table, to record emails being sent ( Turned off by default ) 6. Changed how Grouped and Grand Total Derived variables are calculated. They now recalculate the total based on other totals, rather than summing individual rows. This fixes an issue where a difference of 2 average would calculate incorrectly in the total Changed only Analysis Report. 7. Dashboard Date filters should now use Jquery widget 8. Added ability to manually add a user when using Active Directory. Controlled in utilties_boolean by addActiveDirUser() 9. Put a Save and Cancel button at the top of the user_preferences form. 10. Added Currency Symbol per Company in MYOB version 11. Added currency_symbol field to Companies table. 12. Added an 'Access All' check box to mapping security, all provide a faster way to give all users permissions to a mapping. 13. Added a confirmation dialogue box when deleting lookups and attributes. 14. Fixed a bug in the Deeplink functionality 15 Added last_emailed field to UserReports. 16. Added new table Email_Log 17 Oct 2016 1. Added Call to the emailer batch files May 23rd 2016 1. Fixed a bug in the column widths, when using total on top group layout 2. Fixed a bug when sorting a column 2 or more times in the comparison report 3. Pivot report rendering time reduced by 40% for larger pivot reports 4. Charts now pays attention to whether a metric is a cumulative sum or not 5. Mobile version favorites pays now supports categories 6. Dashboard filters now have a month dropbox option - turned off by default 7. Added the ability to bulk print a series of favorites - Turned off by default 8. Added support for addressbook feature. Turned off by default. May 18th 2016 1. Emailer: Fixed ability to send charts in html and within dashboards. Feb 24th 2016 1. Leap-Year bug fixed whereby a date-range in a Comparison Report could cause an error when the in-report "next date-range" icon clicked. 2. Bug-fix whereby non-alphabetic characters caused an error in User Favourites section under Admin. Feb 23rd 2016 1. Table Headers are now fixed when scrolling vertically in IE 11, Edge, Chrome, Mozilla & Safari. Version <= IE 10 were fixed before 2. New ability in admin to search favorites by recipient email addres 3. New Ability to delete a recipient email address across all favorites. 4. Pivot reports now pay attention to if the total is disabled or not. 5. Analyze by Week, now uses dd/mm format when in appropriate locale 6. Pivot report now supports Total on Top format 7. setupdll.bat supports windows 10 8. Mobile version prototype Turned off by default 9. New Dashboard filters. Turned off by default 10. Fixed a bug with multiple range searches generating an SQL Error 11. Add link to change multiple groups by when viewing a report 12. Import/Export are now separate icons in the Admin Dec 15th 2015 1. Emailer: Added ability to email by range of report ids. Dec 04th 2015 1. Emailer: Added date to each line of the emailer log file. Nov 24th 2015 1. Emailer: Added function -wkhtmltopdf to allow the user to enter windows authentication details, when IR is set to Windows Authentication. Oct 28th 2015 1. Admin Favorite Admin now allows you to search by User/ Mapping & Title 2. Fixed a bug where multiple range searches was generating an sql error or invalid SQL 3. Fixed a bug, when editing favorites via modifying favorite url, was double url encoding values in combo/ multi select fitlers, and stopping the reports being emailed 4. Certain lists like export/import are now sorted alphabetically. Oct 20th 2015 1. Support added to setupdll.bat and emailer_setup.bat for Windows 10. 2. Added manual to install IR on Windows 10. Sept 15th 2015 1. Modified the getUserFavourites() function to allow -ignoreschedule to be used in conjunction with -alerts. 2. Modified the getUserFavourites() function to check if -reportsid is being used i.e. just to run a specific alert, then no dashboards will be sent. 3. If an invalid DSN is being used in the alerts, an error is now written to the log file. 4. Removed a STOP from Emailer.cls which had been left in in previous testing 5. When using alerts, reportheader or reportfooter weren't showing in Excel files. 6. Modified ReturnDataType function to improve performance 7. The replace in the alerts was failing if the lookup didn't end with description Sept 14th 2015 1. Updated emailer manual to include support for generating PDF files 2. Fixed an issue when XML HTTP Object being called but no disposed of after use Aug 28th 2015 1. Amended the emailer_setup batch file to detect the OS and create necessary folders on Server 2008, Windows 7, Windows 8 and Server 2012. 2. Updated emailer manual to detail the folders needed. Aug 21st 2015 1. Added Row Counts to grouped Pivot Reports 2. Fixed a problem with the Pivot Report, when the column description was duplicated 3. New option to put grouped totals on the, rather than the bottom, in the analysis report 4. New feature to track favorites hit counts at an org level, when running in org mode 5. Fixed bug, when running an analysis report with 2 grouping levels, and the first grouping level was set to columns, where the Total Counts were displaying zero 6. Fixed a bug, when importing a mapping, and the mapping join feature was enabled, where it wasn't deleting the old mapping_join_info 7. Code now supports using sql server with the Saas and Multicompany version of IR 8. Added a new Metric column to the pivot report, when using the All(V) version of the pivot report, to make seeing the metric name easier. 16th June 2015 1. Added a bug fix for sorting in Pivot report. Disbale sorting when multi grouping is enabled 2. Added a bug fix for having support for the IRDB InMemory Database. July 21st 2015 1.Emailer Bug fix: If SSL or StartTLS are switched on, then the Authentication is set to none, SSL and StartTLS remained switched on. July 07st 2015 1. Emailer: Bug fix in alerts when a WHERE statement is being used as part of the alerts SQL statement. There is a WHERE clause used when determining the datatype of the 'ID' field, which is resulting in a WHERE ... WHERE in the SQL statement. 2. Emailer: The Utilities class was not being correctly called from the UserFavourites module. Included a SetUtilities function in UserFavourites that is called from gerUserFavourites funtion in the EmailerModule. June 29th 1. CSV Exports with Dynamic Dates should now use the correct date range when emailed. June 25th 2015 1. Emailer: Fixed bug causing a problem with command -dsn June 16th 2015 1. Updated Emailer to latest build May 23rd 2015 1. We can support a build of ir that has it own version of DLLs and System DSN 2. Fixed a bug when using Derived variable Having filters in IRDB 3. Fixed a bug in Pivot Sorting when dealing with multi grouping. 4. Added support for more custom login scenarios. e.g. e.g. test_login.asp <%session("deeplogin.enabled")="1" session("deeplogin.username")="demo" session("deeplogin.password")="demo" server.execute "login_action.asp"%> 5. Sql Server support for system database for Saas & Multi Company Version May 13th 2015 1. Emailer: Fixed a number of bugs in relation to new functions recently added May 07th 2015 1. Emailer: Included function -deletefile, which deletes the report from the hard drive after it has been emailed. 2. Emailer: Included function -archive, which saves a softcopy of the report to the ..\Emailer33\Reports folder. 3. Emailer: Updated emailer manual April 14 2015 1. Fixed bug where Show Grand Total checkbox in Reports wasn't working in the standard analysis report. April 13th 2015 1. Emailer: Included function -imageincluded, which stops blank lines being deleted at the beginning of an Excel Spreadsheet when an image is embedded in the Report Header. 2. Emailer: Included function -excludeid, which allows the user to omit a report from the emailer run using the report's id. 3. Emailer: Included function -reportname, which names the attached file as the report title. 4. Emailer: Added a trim function to the configure module when saving settings. Apr 8th 1. Fixed a bug in the Mar 19th build, where trailing spaces in columns, were causing problems with values not to appear in the pivot reports 2. Fixed a bug where the Null row Total was not appearing in Pivot Reports. Mar 19th 2015 New Features 1. Added 3 Levels of grouping to Standard Analysis & Pivot Reports ( Standard View ) 2. Added 2 Levels of grouping to Comparison Report 3. New Copy Lookups feature from one Mapping to Another. 4. Clone Template & Mapping at the same time. 5. Add the username of the user who prints something to the Printed on Report Header 6. Misc Bug Fixes. Feb 12th 2015 1. Emailer: Fixed issue with sending alerts when ID is numeric 2. Emailer: When using -reportid when sending alerts, dashboards were also being sent. This is now resolved. Jan 14th 2015 1. Emailer: Debugging issues with emailing & exporting (-location) Dashboards in html format, especially if there is a chart in the report. Oct 13th 2014 1. Replaced MailBee.dll in Emailer33.zip. July 24th 2014 1. Fixed a bug when doing comparison reports, with multi date dimensions, and clicking on the Non Comparitive date dimension, on the onscreen report filters gave a date widget with 2 boxes. Now it only gives one. 2. Fixed a bug when doing comparison reports, with multi date dimensions and it was using a filter 1900-01-01 to 2100-01-01 for All for one of the ranges. Now it should not generate any filtering sql here. 3. Fixed a bug in Pivot reports involving mixed case data. 4. Fixed a bug involving All to Last Month, generating incorrectly in emailed reports. ( wasn't evaluating the current range) 5. Fixed a bug where emailed reports with no print header, and say dynamic dates, were generating incorrectly 6. Fixed a bug where emailed comparison reports with no print header, where generating date invalid labels when emailed 7. Fixed a bug where Replacing default currency symbol wasn't working for Euro Currency Symbol. I updated the IR code to internally not replace the Euro Symbol with € This could cause some other euro related bugs. 8. Added new feature to allow a special value of local in the AD domain name string that forces a windows authentication mode that uses the local computer accounts Users are listed from the local machine 9. Added new Dynamic Filtertype for Lookup with Text. This allows you to tell IR, not to generate a whereclause, but to allow you have the variable to substitute directly into the sql dynamically Usage: Look at the html source in the analyze dropdown and look for the internal name used. If the name in the template of the lookup was item and its description part is called description then it should be something like item$description The variables that are available are @item$description_value - Numeric separation e.g. 1,2,3 -> 1,2,3 in sql @item$description_value$ - String separtion e.g. a,b,c -> 'a','b','c' in sql ( Recommended form ) (Request for ERS ) 10. Extended @user_custom1 ... @user_custom10 to also support @user_custom1$ .. @user_custom10$ With a $ on the end of value, it will turn a,b,c into 'a','b','c' which makes for better population of string values 11. Bugfix When doing Top N / Bottom N where it was loosing rows when the key data contained + ( reported by byformyob ) 12. Misc commented out Response.write 13. Added new custom Emailed Report Header feature. Turned off by default. 14. Fixed a bug whereby cloning a favorite didn't work in the admin. 15. Fixed a bug whereby deleting a favorite didn't work in the admin. June 26th 2014 1. Emailer - Fixed bug to ignore null IDs and Email addresses when using alerts. June 23rd 2014 1. Modified Emailer to encode semicolons (;) May 20th 2014 1. Modified Emailer Setup batch file. May 1st 2014 1. Modified Emailer setup file to include a button to apply settings for office 365. Apr 24th 2014 1. Updated Setupdll.bat to register mDict.dll correctly on 64 bit systems. Fixed an issue where mDict.dll wasn't being registered on 32 bit systems. 2. Fix for % character in key messing up Derived Calculations 3. IR now has better SUM ( A+B) to SUM(A) + SUM(B) handling rules and can handle Parenthesis in the formulae better. Used by IRDB to enhance performance Apr 3rd 2014 1. Enhanced IRDB Support. Now supports sorting by Weighted Sums Correctly. IRDB now uses Left Joins by default. 2. General Performance improvements on Large Analysis and Detail Reports. The non sql time should be about 80%-100% faster. 3. Bug fix in Derived Sums and Derived Weighted Sums, stopping calculations if there was a % in the key 4. This build introduces a new DLL mdict.dll that is used as part of 2. You need to regsvr32 mdict.dll if doing a new inplace upgrade and mdict needs to be copied as well Mar 11th 2014 1. Updated IRDB Driver informatin in database types tables in all system33.mdbs 2. Added feature in IR, to generate sql to use start limit and end limit directy rather than using nested sql to improve performance of paging through filters in IRDB 3. Added feature to IR, to added a row limit to all queries sent to IRDB. This is to make sure IRDB doesn't return unmanable result sets. 4. Removed some javascript from Emailed Reports 5. IR should now support derived tables correctly in IRDB. 6. Added support to allow for admin-defined graph/chart colours instead of the default chart colours. Turn off by default. Feb 24th 2014 1. Fixed potential bug with Emailed Reports not working in Feb 7th 2014 build 2. Fixed bug when grouping in a chart with keys like 2012-01 Feb 7th 2014 1. Add 23:59:59 Time part to End Date Ranges for SQL End Date Filters to improve accuracy with IR against Data that includes a time component. Works with SQl Server & Access 2. Fixed bug when using 100 as a filter for Result % It was classifying this as 0.1 instead of 1.0 3. Improved Validation of Email Addresses for Favorites 4. Added Print Date to Printed & Exported Reports 5. Added Move to Top and Move to Bottom to Add/Remove Fields in Client and Admin 6. Under Mapping Preferences, if you disable Favorites it will also remove the Dashboard Icon 7. Under Mapping Preferences, if you disable favroites it will also remove the top right 4 buttons on the Analyze Menu Band Dec 4th 2013 1. Fixed a bug in the Nov 29th build, where the calendar popup wouldn't navigate forward or backwards months or years Dec 3rd 2013 1. Fixed a bug with missing rows in the comparison report when using multiple rows and the Hide Zero row feature 2. Fixed an issue in IE11, where multiselect combo boxes weren't working in Advanced page. Clients need to clear cache or server needs to expire html pages 3. For invisible Keys, when turned, enhanced the functionality to hide the grouped key column, in grouped reports. 29th Nov 2013 1. Updated Norwind data & demo favorites for 2013 2. Fixed a bug where Multiselect boxes weren't working on the advances/home page in IE 11 21 Nov 2013 1. Fixed bug with the Navigation Combobox when you drilled down, and it would not select the correct value. 07 Nov 2013 1. Allow 4 comparison date ranges 2. Last Quarter / This Quarter were messed up when CustomDates where enabled. 3. Fix for Emailed Freeform Dashboards 4. For Sql Server queries, set the Query to use a low level locking type 5. Improved support for Negative numbers. 6. Fixed a bug in SQL Count Distinct optimization, when used with Rank Functions 7. % of Total now prints out as a separate column in Excel & printed reports 03 Oct 2013 1. Fixed bug if no schedule details are set for a report. 01 Oct 2013 1. Emailed Excel Spreadsheets have been cleaned up. Less blank lines, and top headers are formatted correctly 2. New Experimental PDF Feature 3. New Cumulative Sum & Weighted Cumulative Sum feature. 4. Emailer has been updated with some bug fixes to allow non Alphanumeric chars in the keys for mas emailling 5. Emailing of PDFs now allow spaces in the path to the emailer 6. Emailing of HTML Dashboards improved. 28 Aug 2013 1. updated emailer manual to include documentation on -sleep and -intervals commands. Also support on installing with Office 365. 01 Aug 2013 1. Facility to specify a time interval between sending emails 2. Allow send single dashboard 3. Updated Manual 4. Ability to email reports and dashboards as pdf 29 July 2013 1. Included function -sleep, to allow a time delay between sending multiple emails. 10 July 2013 1. Facility to email dashboards 2. Facility to email reports as PDF 10 April 2013 1. Resolved alerts not showing header and footer - had been resolved at an earlier stage but mustn't have been checked in. 07 Feb 2012 1. Fix bug in emailer 01 Feb 2012 1. Modified emailer setup batch file to include lines: %~d0 cd %~dp0 These two lines set the current context to the drive containing this script. Then sets the current directory to the scripts directory. 24 January 2013 1. Modified emailer to allow svaing SSL and StartTLS settings irrespective of eachother. 09 January 2013 1. Added a year to the dates in Northwind database 2. Modified Install_IR_windows_2012.doc manual Dec 19th 2012 1. Updated install script to support Windows 2012 2. Dashboard Fix 3. Added Install Manual for windows 2012 October 11th 2012 1. Update emailer33 manual October 10th 2012 1. Fixed bug caused by last update 2. Update Install_IR_Windows_7.doc manual 3. Upgrade v32_to_v33 to include Blank Database in 2000 format October 3rd 2012 1. Included Mass Email Manual 2. Fixed bug not showing Header and Footer in Mass Email 3. Created log if 'Value To Replace' not found in favourite 4. Provided the facility to enter the reportid in the command line prompts August 3rd 2012 1. Updated Build to reenable sharing of Dashboards that was broken in July 19th Build July 19th 2012 1. Added button to hide onscreen filters 2. Updated Dashboard editor to prevent saving of freeform dashboards until they are loaded July 17th 2012 1. Updated Emailer Module to stop it emailing Excel Spreadsheets with "No Matching Records" June 7th 2012 1. Fixed a bug in favorites with Single quotes causing Freeform Dashboards not to be editable 2. Misc Dashboard bug Fixes May 11th 2012 1. Updated Northwind demo data to 2012 May 4th 2012 1. Fixed a bug in the mapping Editor, where the sql in lookup tables was being rendered as blank. This effected the Apr 16th and Apr 30th Builds. Any such build should be updated Apr 30th 2012 1. Fixed a bug in the Mapping Editor, where some older Inventory Mapping SQl wasn't showing in the Map Main Transaction. This only effect Apr 16th 2012 build Apr 16th 2012 1. When downloading an app from the app store, and entering a datasource, the Corresponding Radio Button Clicks to selected 2. Fixed a bug in the Dashboards when the underlying report used a Dynamic Date. Applied Date filter was the original custom value when the report was saved. Now uses correct Date range 3. Remove some unneeded html tags from emailed reports. Mar 26th 2012 1. Added new Query Engine to speed queries 2. Added faster engine for handling Derived Variables 3. Added new Geochart Visualization Mar 12th 2012 1. Added support for deeplinking of Dashboards, and defaulting to a dashboard 2. Added support for denom() in the rank function for sql server When using you should use something like in the text of the rank formula (a+b)/denom(b) Mar 8th 2012 1. Fixed table date range display when calling comparison report favourite in Dashboard 2. Fixed header bug when calling favourites in Dashboard when Display Execution Popup is enabled 3. Improved Template & Mapping Editor Integration Jan 9th 2012 1. Fixed bug with Year to Last Month Last Year date range, being off by one year in the first month of a new Year 2. Updated Rank Support to only with SQl Server & Oracle, and Disable Rank function in totals and detail report. Jan 5th 2012 1. Fixed bug when editing a dashboard and loosing the settings. Dec 16th 2011 1. Allowed single quote and - in login name 2. In month annotation timeline the data show the 15th of each month instead of the last day 3. The new count of users in Login_action.asp was causing a problem for sites bypassing index.asp, because the licensing was setup. 4. Added a missing End if, that fixes an issue with Dashboard Deleting Added in the Nov 29th build Nov 29th 2011 1. Fixed some bugs where the IR System sql wasn't working against SQL Server A. SchemaUtil, strcomp function not in SQl Server B. problem selecting max(iD) with a memo field 2 Numerical Filter issues 1. Filters on derived variables weren't working in Detail report 2. Weights Sums had issues with SGN & ABS function needing to be outside, rather inside the sum expr. 3. Checked in Fix for Annotated Time Line, as It was only rendering 1/3 of points 4. Fix IR APP Store project download as it was not importing 5. Added Freeform Dashboard Designer Sept 6th 2011 1. Improved Dashboard Rendering Speed 2. Fixed bug when editing favourites with & in the title. Sept 2nd 2011 1. Added Improved Caching Capabilities 2. Added ability to copy mapping user security settings from another mapping. This makes it easier if you have a large numbers of users, and you have a new mapping, that you want to apply the security credentials of an existing mapping to. 3. Added sum expansion to boost query performance Aug 17th 2011 1. Added support for @user_today dynamic substitution variable. It dynamically will substitute todays date in iso format, and can improve some queries that make use of getdate() in sql server. Aug 11th 2011 1. Fixed a bug with handling US date formats where 6/4/2011 would become 201164 instead of 20110604 in our quicksort keys. Resulted in out of order reports when sorted by date. This was effecting grouped charts with a day/week key 2. Adding enhanced support for COUNT DISTINCT in sql 2008, to speed its performance 3. Fixed a bug with multiple descriptions based on different keys not showing in visualizations 4. Fixed one case where count distinct queries do not work in the Results numerical filters 5. Fixed a few cases, leading to numeric filters being displayed as blank. 6. fixed a bug in wizard losing all text filter values when navigating back and forth, when fiilters have symbols 7. Fixed bug with blank database credentials being inserted as spaces into the system database when importing a mapping. 8. fixed a bug with hidden qtys shown when emailing reports 9. Removed encodings hz-gb-2312 and utf-7. URLs and forms were messed up and users unable to login to change encoding back. 10. Modified the custom button behaviour to be output as individual button instead of a dropdown menu. 11. Changed values of the SQLServer entry in database_types for the datediff calculation to DateDiff(d,%1%,%2%) and DateAdd(d,%2%,%1%). July 20th 2011 1. Added a fix for IE9 Visualizations, to turn ie9 into compatibility mode 2. Added support for emailing visualizations 3. Removed Misc whitespace in Chrome 4. Added Last 12 Months Date Range June 27th 2011 1. Added fix where the last grouped total wasn't appearing. This appeared recently with the addition of the new CSV export feature.