Changes in Mar 11th 2009 Build 1. Fixed Date Range Filters for certain end of year offsets for Australia. Changes in Dec 29th Build 1. Fixed emailer and IR, so that reports from restricted users apply the correct security Restriction IR Build and Emailer need to be updated to Dec 29th distribution 2. Fixed a bug with pivot favourites - when vewing a pivot with a date option as a row or col, that option was not showing in the wizard page 3. Fixed a bug with the first date range in comparison reports when trying to edit a favourite - the selection of the daterange form the edit favourite advanced page was not passed correctly to the choose comparison ranges page Changes in Oct 14th Build 1. Build date now says 14 October 2008 2. Build should now install gdiplus for those windows 2000 platforms that require it. Changes in Oct 6th 2008 Build 1. Fixed leading zero dropping off in Excel Export 2. Fixed a bug with comparison top selection resulting in a sql error 3. Fixed a bug with javascript sorting in pivots - when you have a numeric quantity in the cells, ie qty, with other values underneath it, either in all(v) format or with % total, javascript sorting was not working. 4. Modified the heigth of the pivot reports to show the whole table when there are only a few rows, as the grand total was not shown completely 5. Fixed a bug with the top/bot selection not being defined correctly in comparison reports, keys/descriptions were taken alphabetically instead of finding the top/bot values 6. Fixed a bug with favourites not running, when a second date range was being mapped after a favourite was created. the reason was that an error check for non valid date values was making the report stop when it was checking the new date range that was not present in the favourite's url 7. Fixed a bug where IE in Vista would crash when the user attempted to sort the columns using javascript. Change on July 30th Build 1. Thai Trial dates are now accurate. 2. Thai Default dates support are improved Change on July 28th Build 1. ReFixed a bug with the license going out of date in non gregorian calendar locales e.g. Thai This was not compiling properly 2. When the start date exceeds the end date in Year To Last Month and Year To Last Month (last Year), the end date is shifted onwards by 1 year 3. Added the About link in the Admin side Change on June 18th Build 1. Fixed a bug with the license going out of date in non gregorian calendar locales e.g. Thai 2. Fixed a bug where firefox 3 would spread the report vertically accross the entire page, even when the the report only contained a few rows. Change on June 12th Build 1. Fixed a bug, where navigation lists were missing one entry. Change on June 12th Build 1. Fixed bug where server would go into infinite loop if an sql query was executed in the 'Execute SQL against an ODBC data source', that did not return results 2. Fixed a bug with some databases requiring the ORDER BY field to be part of the SELECT field list 3. Fixed a bug with top/bot chart reports in MySql - when selecting the top/bot the SELECT list was not constructed correctly. 4. Removed Informix SE database type Change on June 11th Build 1. Added Informix 7 and Informix SE Database Types 2. Fixed a bug with the NOT option disappearing when drilling down in reports for lookups with no key mapped 3. Javascirpt sorting of dates in detail reports was not working 4. Fixed a bug when drilling down to a report value that contains an & - parsing of the & was not done correctly 5. Fixed a problem with the navigation filter right arrow hiding in cases that it shouldn't 6. Fixed a bug on printing in Firefox - the table rows were spreading all over the page even if the height of the table was small - the resizeTable function should be disabled when printing in new version of Firefox 7. Fixed a problem with mysql sql error when generating a top/bottom report and the view by field was not present in the sql statement. to avoid such problems the view by dropdown list now contains only the calculated variables that have the analyze by option set to yes. similar action has been taken for the quantities of the order by dropdown 8. The breadcrumb levels were lost when returning to report page after trying to save a report Changes on Apr 10th Build 1. Fixed an issue where sometimes the filter value would blank out in the report header. Changes on Mar 31st Build 1. When a user has Multiple security restricted values, navigation variables now work with them 2. Fixed bug in analysis page where next arrow was shown when navigation filter only contained one item. 3. Fixed a bug with the external linking being truncated 4. When cloning a mapping the where clause of the maping_edit.asp page was not cloned 5. The filter search icon was visible even when the Find box in the mapping section was unchecked 6. Modified filter pages to display appropriate box when dealing with security fields, but to limit the options to the security values. 7. Fixed a bug when renaming a lookup from the mapipng editor properties popup page. the name property from the properties popup page and the tilte field from the mapping_edit1.asp page should match 8. When changing the first analyze by field from the template editor the new selection was not shown in the first wizard page. problem was that ther was incomplete check for whether a field was mapped or not leading to not appropriately selecting the correct field 9. Updated dates in favourites to be of 2007 Changes on Mar 3rd Build 1. Is using AD Authentication, can change AD Password. 2. AD Authentication now supports password expiration. ( Expiration is controlled by IR Admin, and not by AD Policy settings ) 3. Fixed bug with euro symbol not appearing in Tooltips Changes on Mar 3rd Build 1. When adding a User from An active Directory, and the active directory is misconfigured no longer crashes the web server. 2. Charts now Support Unicode Characters. Need to use UTF-8 with a Unicode Font. 3. Fixed a bug in javascript sorting of pivot reports wih option all(h). the format of the columns was not set correctly 4. fixed a bug with NOT filter in pivot reports, when the second analyze by field was a NOT filter and we drilled down into one of the desscriptions the NOT option was lost 5. Added Explicit Help in creating a mapping when selecting the SQLServer and Oracle databases. 6. Fixed a problem in emailing certain detailed Reports. 7. The principal table option has been removed from the template editor and has been changed to a hidden field 8. When in comparison reports, the date ranges of the calendar popup window are displayed one next to the other rather than one under the other, so that the buttons are visible 9. Added an option in calculated variables editor to select whether to show or not the total value of the quantity at reports. adjusted code in report side to handle such cases where it didn't make sense 10. Fixed gui table problems when the total value of a variable is not shown 11. Fixed bugs in reports with mixed cases - sums in pivot reports where not correct and grouping was not taking each case as separate 12. Fixed a javascript error when opening the search popup window of navigation text filters when no key was mapped Changes on Feb 14th 1. Fixed Pivot report to work with mixed upper and lower case descriptive values 2. Clicked on Advanced, Wizard, bring you back to the query you originally entered to generate a report rather than the current scope of analysis. 3. Fixed a bug when importing a template - the number of dropdowns was always set to 3 4. Conditional now reads Conditional Sum Changes on Feb 10th 1. Fixed Bug, where if you had select 2 or more items from a multiselect and tried to drilldown, it would give a no-matching records or other error. 2. Charts no longer display spurious commas 3. Simple bar and pie Charts now formatted display value in mouseover. 4. Emailer 3.2 now sends chart images with chart header. Changes on Jan 23rd 2008 1. Updated all builds, to fix a bug, where deleting shared user and groups from one favorite would also delete the same user and groups from other favourites. Current build now behaves correctly when removing user and groups from favourites. Changes on Jan 8th 2008 1. Updated EXE build, to fix a bug, where you could not save favourites. Changes on Jan 4th 2008 1. Fixed a bug with the "Year to Last Month" and "Year to last month (lst Yr)" date ranges that were not showing the correct initial dates if the month of the current date is January 2. Fixed external link feature to work with detail report 3. Removed check when saving a report to see if a report title is unique because of scalability issue 4. Fixed bug when adding a new user, each mapping name was displayed multiple times Changes on Dec 12th 1. Fixed Javascript error in Pivot Report Date Navigation Filter 2. Should be able to drill down on attributes with commas in them Changes on Dec 10th 1. Analysis Report now is 100% of screen width Changes on Dec 6th 2007 1. when only key is mapped and the first value of the filter list was empty, the selection of a filter value from the search icon was always putting an empty string as the first selection and filter was not rendering 2. fixed security bug where only the first security value was used as a filter 3. fixed a problem with the report titles when trying to edit a favourite 4. fixed a bug with the symbol of stacked % charts 5. Fixed bug where a hardcoded
in a variable would appear in the chart title 6. Changed 'favourite' to 'favorite' and 'colour' to 'color' 7. when trying to modify the definitions of a saved pivot, the pivot qty was not taken correctly 8. grouped charts by day were not sorted as dates but as text - problem existing in sorting algorithm 9. the comparison date in the table header was not appropriately updating for emailed favourites - problem also existing in printing and exporting to excel 10. Added support for wider search screen 11. when drilling down into a null value represented bu a dot, the navigation filter value was disappearing 12. when going from detail analyze report to pivot, both analyze by fields were set to the same value and pivot didn't genarate 13. when generating a detail comparison report an extra breadcrumb level was appearing that shouldn't and wasn't directing anywhere 14. when there were no matching records found and the top/bot option was selected the structure of the report page was wrong dislpaying the message above the toolbars 15. removed a pivot report from the contents of the user manual 16. the orderby list was not populated correctly in pivot reports. also removed the orderby direction dropdown from pivots as pivot only supports the asc option 17. very long lists in the report tab in the template editor were preventing saving any changes in IE - changed form method to post 18. corrected a typo at the error message when the license does not support the emailer 19. fixed a problem with numeric filters being lost when sorting large reports by clicking the column headings 20. fixed a bug when generating a report and drilling down, going back to the advanced/wizard pages, the analyze by options are not set correctly 21. fixed javascript sorting that was not working in comparison %var 22. fixed javascript sorting in comparison var and %var columns that contained null values - null values were replaced with zeros as they were interfering with other values 23. fixed problem with date comparison reports in table format and comparison var charts - when drilling down into a particular date range the whole range was retained 24. fixed a problem with date calculated variables in comparison reports - when field dodn't have valus for a comparison range the table was corrupted. also don't allow date calculated variables to have the option of comparison delta as it makes no sense 25. chart and pivot reports align left when printing Changes on Oct 4th 1. When a user was shown a the list of favourites as their home page, It was displaying a blank page, if they click on choose report, and then selected a mapping Changes on Sept 19th 1. Fixed issue with Printed Reports, being in scroll mode 2. Added support for / in user ids 3. Doubled length of timeouts. 12 mins to execute sql, 20 to execute report 4. Added support for Title tooltips in top 10 favourites. Change on sept 17th ( updated IIS Build ) Added Emailer32.zip , for use with builds after Sept 12th. Uses POST mechanism to generate emailed reports. Fixed 1. Set default security to Integrated Model. AD had been set as default in Sept 5th build 2. IR was switching into Page Mode, if you set a custom color or font size, and when back to advanced 3. Removed Hyperlinks from Emailed Pivot Reports 4. Added support for numeric filters in Emailed Reports 5. Modified IR, to support POST request for Emailer Reports. 6. Upgrade Program now upgrades user table correctly. This fixes the bug, where you could not add uses to an upgraded version of IR Some previous versions of the upgrade program, added the field count_favourites_time to the users table. when it should have been count_favourites_date. Change on sept 5th ( updated IIS Build ) 1. Navigation Filter, does not appear for users locked down by user and grouped security. 2. Added, external AD authentication, where IR picks up whether someone is authenticated from IIS AUTH_USER variable Change on Aug 24th ( updated IIS Build ) Added 1. Active Directory Support. ( To enable AD support goto the "User Security" Tab in Settings and select "Active Directory" from the dropdown ) You should enter your ldap server ad domain name here. Existing User Ids, will only be able to log in, if they exist in the AD. New Users, are selected from a dropdown of user_ids and usernames. You will know if the connection to AD works, if the dropdown populates okay. When logging in, you must enter the active directory user id and password to log in. Do not enter a domain name part into the ad username. 2. Ability to control if a user can share favourites 3. Ability to control log in page of user Bug Fixes 1. Fixed filter values displaying the separator text "~comma~" instead of a comma 2. Fixed external linking - when a link contained & it was truncated as separate request variables 3. FDixed external linking with % disappearing from %variable% 4. When emailing a report the pivot qty was not properly set and the report was empty 5 Javascript sorting was not working when field contained nulls and numbers 6. Added error check whether there are mapped textual fields in detail report to eliminate sql errors 7. When the key field was selected for a detail report withiut selecting the main lookup, the key field was not appearing in the table 8. When more than one key fields with the same name were selected for the detail report and no main lookup was selected, only one of them was shown in the table 9. When more than one key fields with the same name were selected for the detail report and no main lookup was selected, none of them was shown in the show list of +/- cols 10. When no main lookup was selected for detail reports and more than one key/description fields had the same name, the order by list didn't contain all the fields 11. When the option code was selected for ordering from the advanced page for detail reports, there was no arrow in any column showing by which field data are sorted Readded GDIplus.dll - Needed for some version of Win2k Change on Aug 16th 1. Added interactive_reporting.msi, new setup program Vista Compatible Change in Aug 13 Build New Feature 1. Added "Last 3 Months" in date ranges Removed GDIplus.dll - More than likely it is included with (most) versions of windows Bug Fixes 1. Removed check on uniqueness of Attribute Name 2. when changing mapping from the report side the pivot qty was not resetting and if it didn't exist in the new mapping, the pivot option was defaulting to all(v) rather than the mapping's last pivot qty 3. when clicking a preview button from the admin and chnaging the mapping from the client side, the edit button was redirecting to the old mapping's editor page rather than to the new one's 4. the first report breadcrumb was missing when the clicking the preview report button and drilling down in the report page 5. fixed datapump transfer for bo0lean values in sqlserver that was not working 6. the back button of the transfer page of the datapump tool was not working 7. Enhanced Scalability in Groups. Groups can now handle larger numbers of users. 8. when there were columns with %total option the subtotal rows in grouped comparison reports were messed up Changes in Aug 6th Build IIS Build Updated. Exe not updated yet Bug Fixes 1. the pivot misalignment problem when removing the key column - problem appeared only if you had attributes mapped 2. fixed a detail report sql error when no main lookup has been mapped - same sql error existed if you had the main lookup added to the detail report but removing it form the +/- Cols option 3. fixed an sql error that appeared when clicking the preview report button and none of the default analyze by fields was mapped. in such a case a detail report is generated instead 4. fixed a problem with the editing of lookups and the error check about attributes 5. fixed a problem when trying to add more than 10 attributes in a lookup, the indexing of the new attributes was wrong, always beginning from number 10. 6. removed validation warning error from reports 7. changed % of Total fonts from Italic to regular 8. % Total values are shown with 1 decimal place only 9. fixed a bug with two mapped date fields in pivot date reports - both dates were changing when drilling down 10. fixed a bug with multiselect filter - the search options were not shown properly 11. fixed a problem with extra spaces in sqlserver data that were making navigation filter options not to show the select lists in the report for combo filters. if a data value is smaller than the specified field length extra spaces are being added - the database_types.replaceChar value was set to 0 for sqlserver 12 fixed a problem for the search popup window layout for text filters Changes in July 26th Build IIS Build Updated. Exe not updated yet Added Postgres Support Bug Fixes 1. Fixed a bug with the scheduling of emails set to daily nomatter of the option selected 2. Changed the html page title in reports to the mapping's name instead of the template's 3. Fixed a problem with the edit favourites page breadcrumbs - the reports name was shown at the wrong position 4. the cancel button in the main template page was redirecting to the mapping page instead of the template page 5. fixed problem with < and > in claculated variables formula. combinations of <% due to the addition of the %principal table. were producing combinations of <% that code was wrongly interpreting as asp tags 6. added restriction when creating/editing a lookup not to allow names that are used for existing attributes, as it generates 3rd level links in mappings 7. fixed javascript error when trying to import an existing template 8. add check when validating a mapping, if a lookup has no key mapped its filter options can only be text type or none 9. added fix for quarter bug issue when the default month is not january for sql server. in the group by quarter field the division by 3 should be replaced by division by 3.0 in sql server 10 fixed a bug with the filter key value not shown in the navigation filters list at the report side if code shown option is selected 11 fixed a bug with mapped attributes innavigation filters, when the parent lookup was also selected to filter the report, trying to change the navigation value of the attribute was giving a javascript error and change was not done 12 modified code to show the navigation filter values up to a length of 35 characters to the right select list of the search filter page 13 modified fix for the problem with commas and parentheses in navigation filter values because it was not totally correct - the select list for the navigation filter values was being lost in the case of parentheses, and sometimes an erroneous no match found was given because code checks were not working with removeBrackets change 14 fixed a problem with the IR logo section of the filter search popup window - the blue strip was not matching the width of the popup window. also the layout of the popup page was not consistent with all other pages, blue frame was missing Enhanced Emailer Added 1. Password Support 2. -configure Configuration and testing Form 3. Logging Support Changes in July 16th Build 1. More Enhanced Favorite Scalability. 2. Fixed Array out of bound error Changes in July 12th Build 1. Favorite links now use id in Show Favourites and 10 Ten, instead of long URLS 2. Favorite Links are now saved using a POST Request. Changes in June 28th Build 1. Fixed typo introduced in June 26th build relating to footers. Changes in June 26th Build 1. Footer is now customizable in OEM version. 2. Fixed error in line 19/29 analysis2.asp relating to breadcrumbs 3. Oem version configured correctly, for direct logins Changes in June 20th Build 1. Grouped Comparison Grouped Totals Variances are no longer zero 2. Added Last Week Last Year, This Week Last Year & Week Before Last Year 3. Fixed Navigation Variables to work with Descriptions longer than 35 chars 4. IR is now compatibile with SmallDateTime Fields in Sql Server Changes in June 19th Build 1. Fixed problem with Attibutes in Secured Dimensions locking users down 2. Fixed Problem with , in the description of navigation variable selection Changes in June 5th Build 1. Default demo user has Intranet Option turned off Changes in May 15th Build 1. Made sure IIS responses are cut off in queries that no longer have an attached client 2. Turned on "Intranet Docs" Module in default IIS build. 3. Fixed upgrade program to allow you to add users, in upgraded databases. Changes in May 10th Build 1. Fixed Javascript Sorting Bug 2. Fixed Selection Issue with hidden Text field. ( Support for (,),") character removal 3. Added feature to display Codes search box in Multiselect boxes and Combo Boxes with codes 4. Removed Leading Space from Navigation filter box with 2 or more values 5. Upgrade Program now sets favourites schedule to daily. Changes in May 2nd Build 1. Added ability to have security filters with multiple values 2. Cleaned up Sales Template, so Qty now appears in Analysis Report. Changes in Apr 30th Build 1. Reverted MYob support to Inner Join 2. Icons now use GIF images 3. Less aggressive Whitespace removal. Tabs are converted to spaces. 4. Misc Filter Bugs Fixed 5. When emailing Charts, sometimes, grouped charts didn't chart the values 6. Fixed a problem with favourites & javascript sorting, after logging in using Preview Reports 7. Removed Extra line from Grouped Excel Charts 8. Enhanced Charset support. Charset is now a dropdown, with support for other 20 charsets 9. Upgraded to latest service release of charting component Changes in Apr 25th Build Emailer Changes * Updated Performance Issue Removed o(N2) loop * Added -1 option to Subtract one, on the datestamp when sending. IR Changes changes to the style of the simple advanced page to vertical minimize space changes to the style of emailed reports - changed style of td cells, removed javascript code, added style sheets as include file Emailed Reports are now much more compact using stylesheets instead of verbose font tags fixed a bug in pivot reports with the option all(H) - when there were null values for some cells, the zeros set in these cells had the format of the first pivot qty, resulting in inconsistencies in the format of zeros. fro example for margin instead of showing 0% it showed €0 if the first pivot qty was of currency type, or 0 if it were a number fixed a small problem with the pivot quantity being lost if set to All(H) or All(V) when adding/removing a column to the pivot report Changes in Apr24th Build fixed a javascript error when generating chart reports and no matching records are found when changing the font settings from the report page and return to the advanced page the new settings were not shown since the top/bot option is not available for detail reports, the top/bot dropdown is not shown when detail selected when in the toolbar side and in chart reports there was an extra separator at the end of the toolbar in some complicated comparison reports there were cells with no values and the cell borders were not shown, so that the table was looking ugly. forced these cells to have the   value so that the borders are always shown deleted and re-added the location lookup in the inventory template - some onconsistency in one of the schema_items field values for this lookup, most probably from an older version, was causing problems when trying to map this lookup. investigated code, there was not a bug associated with this issue fixed the value of the color popup in the advanced page that was showing the initial value as decimal and not hex Changed charts to use JPGs instead of BMPs. fixed a bug associated with detailed favourite reports modified the code so that the dates in the date range column of the favourites reports and the dates of the date navigation filters at the report page to be shown accordingly to the locale used fixed a problem with favourites saved at european locale - when viewed in american format trying to changes the date range with the previous/next button was not working Added support for folders to Intranet Module Added support for Auto White Space Removal, and simple html cleanup in IR html removed comments from source code modified code so that the css style part does not appear as an include file in the source code but they are linked externally renamed some toolbar buttons renamed Favourites to Favorites everywhere to be consistent with the button name change removed the sorting arrow from pivot reports except from the case of All (H) removed the drilldown link from the pivot column headings when setting up a pivot report the default pivot qty is set the last qty in the pivot list the All(H) and All(V) options were missing from the pivot configuration wizard page fixed a javascript error in advanced page when no qtys have been selected for pivot reports from the template editor - took care of similar problem with chart reports fixed a bug appearing when javascript sorting by a field and then removing it via the +/- Cols button - sorting was entirely lost fixed a bug in pivot reports when only one field is displayed and being removed via the +/- Cols button - fixed similar problem in chart reports fixed a bug in analysis report when trying to order the report from the advanced page by a field that was not available to the report fixed a bug with paging, when returning to the advanced page the paging option was not shown fixed a javascript error in sidebar mode when no matching records were found, removed some forgotten response.write, the error message was appearing at the wrong place in the page when importing a mapping the mapping preferences show the corresponding system preferences values, but are disabled, the default option is to use the system settings fixed a bug when creating a new mapping or cloning an existing one and the user had access to all mappings, the new mapping was not selected fixed a bug in the user edit page - the row classes of the mapping details table did not alternate properly between gray and white in all cases fixed a javascript error when the trying to save a report and the emailer is disabled fixed a bug when trying to edit the options of a newly saved report fixed a javascript error when trying to generate a chart report with more than 1000 elements fixed a bug with the paging options appearing when changing the analyze by field to detail fixed a bug with textual filters being separated by double commas fixed a bug when trying to generate a comparison report from a grouped analysis report when only one Analyze by field is selected from the template editor, the pivot report is not available at the client side Changes in Apr 15th Build 1. Emailer Fixed. Broken In Apr 5th build 2. Fixed javascript bug when you switched to sidebar mode Changes in Apr 5th Build 1. Pivot All Horizontal Feature 2. Html is now more compact 3. Printing Header is not more compact 4. % of Total now works in Pivot Report 5. Toolbar is now more compact, and fits better on screen 6. When running in IIS mode, IR does a periodic flush. 7. Fixed Clone Mapping Issue 8. Emailer License option is now checked. 9. Fixed some bugs related to adding or removing Specific IR features in Mapping Preferences. 10. Fixed paged sorting. 11. Favourites remember what columns to display, even after adding/removing fields Changes in Feb 28ths Build 1. Lock icon moved to toolbar, margins shrunk around vertical and horizontal edge 2. Javascript Sorting behaves better, in arranging columns when sorting. 3. Can now drill down on UTF-8 values. 4. Updated Admin Docs 5. Added Preview Feature to Admin. Can now look at reports, and edit mappings, without logging in and out all the time. 6. Added 10,15,20 Options for Rows per Page Changes in Feb 22nd 2007 Build 1. Updated Demo Data 2. Report pages dont display the IR footer. 3. MYOB now uses left joins 4. Charts don't have explicit borders any more. 5. Remove the Link option from the Client side. Changes in Feb 19th 2007 Build 1. Created V30 Resource Site