Jan 5th 2011
1. FIxed a bug when "Year to Last Month was off by one MOnth in the first month of the new YEar

Nov 24th 2011
1. Fixed a bug with Weight Sum Numerical filters.

Apr 28th 2011
1. Fixed a bug with editing a favourite from the admin side.

Apr 6th 2011
1. Fixed a bug in multiple orderby's, when viewing a favourite it was losing the first order by option.
2. Fixed a bug with the dateadd,datediff functions showng numbers instead of dates
3. Fixed a bug when having a top/bottom selection for both analyze by fields of a pivot report, when trying to drilldown into a value of the "Other" column the filters don't apply correctly and wrong results are produced 
4. Fixed an error in pivot reports, when switching rows and columns, when the ordering was done by description the pivot was displaying extra cells
5. Additional problem was fixed when the above bug was fixed, and the ordering was done by a mapped attribute
6. Fixed an sql error in detail reports when having in the report both the name of the main lookup and its key, and their names were different.
7. Fixed a bug with drilling down with multiple text filters
8. When trying to import a favourite in the admin side that had a category assigned to it, the import was failing due to a typo in the sql that was retrieving the categories.
9. Modified the export code to prevent the removal of additional whitespace from mapping SQLs. This was being done on purpose.
10. Fixed a bug when trying to drilldown when a range filter was applied
11. Fixed a bug in the order by of pivot reports, data ddi not order by attribute.
12. Additional changes for the database connection type problem
13. Fixed database connection type problems when both client and admin side are open and differerent type of databse used on the client side.
14. Fixed an error on the analysis parameters wizard page when no fields have been selected for detail report

feb 10th 2011
1. Fixed a bug, where if you changed the detail column ordering it was lost when you saved it as a favourite, logged out and then back in to see it

Jan 28th 2011
1. Fixed a bug that was generating spurios SQL errors caused by the order by clause when switching between mappings when ordering by a qty that was absent in one of the mappings 
2. Fixed a bug that was causing some favourites to be corrupted when saving 
3. When defining a date in the template editor, the endings _day, _week, _month, _quarter, _year are not allowed, as they interfere with the parsing of the date options in reports
This fixes a bug where if a date field ended in day week month, quarter or year, then it wasn't generating the date in the where filter
4. Fixed a bug in the detail report, a check for mapped fields was failing due to the option to set the type of date in the unmapped_default field. This was causing SQL errors when invalid sql was being generated in cases where you had unmapped date fields
5. Improved support for Pervasive 10+
6. Fixed bugs where dervied dates where not working correctly.


Nov 12th 2010
1. Fixed a bug when using Dynamic Dates and favourites.

Nov 11th 2010
1. FIxed a bug where totals where showing all Zero's in certain cases

Nov 3rd 2010
1. Fixed a bug with favourites not saving the order by correctly when it had been changed by clikcing on the top of thetable

Oct 5th 2010
1.Fixed a problem with qtys that were simple sums, the number of digits was rounding to two decimal points with extra zeroes for the remaining number of digits.
2.Fixed a space missing from the end date title in the advanced page
3.Added an extra property to suppress the headers when exporting/printing
4.Fixed a bug when trying to javascript sort data in pivot reports with a top/bottom selection and when the % of Total is present

Sept 17th 2010
1. Hide empty categories from the Category side bar list in the favourites page
2. Exporting to excel in pivot reports was not keeping the format of the numbers and summation couldn't happen - recently enhanced class was modifying the numbers format. added new class just for the pivots 
3. Fixed a typo for the error message for unregistered Simplechart component, that was truncating a part of the message
4. An extra change for the HAVING clause, needed to add change for the "between" values numeric filteR
5. Fixed a bug in the "between" numeric filters, the numric filter description on the report page was displayed max<qty<min instead min<qty<max. the results of the report were correct only the way the filter was shown on the report page was reverse 
6. When importing a single template/mapping from their Import option the All check box is not shown and the checkbox by the template/mapping is checked by default. 
7. When the number of mapped fields is less or equal to 15 the list in the wizard choose analysis page is displayed vertically,  and horizontally for a larger number
8. When selecting a pivot report from the wizard pages, and going to the advanced page before creating a report, then the All(V) and All (H) properties were lost in the advanced page
9. The wizard selection of the analyze by fields were being lost when navigating through the pages 
10. When having a pivot report with top/bottom selection, then flipping the rows/columns should switch the top/bottom selection too
11. Fixed a javascript error in the wizard pages when sorting the fields in the chinese version


August 16th 2010
1. Updated Demo data to make it more time relevant
2. Added Chinese Buid
3. i18n fixes

August 15th 2010
1. Enhanced Login procedure
2. Increased the width of the filter tables in browsers that work like firefox
3. The detail_numdigit field was empty for the Sales template and the wtys in the detail reports didn't display any decimal points.
4. Cleaned up i18n tokens
5. Added a warning class in the ir_default.css file, so if an error message was displayed limiting reports to say 5,000 rows, the report will still email. 
6. Enhanced the class for the table cells, so that leading zeroes would not be truncated when email reports in excel format
7. Fixed an error when a user who is not allowed to share favourites edits a favourite - error shown when on error is commented 
8. When editing a favourite from the user favourites page in the admin side, selecting a, owner who cannot share favourites hides the share favorite option.
9. Fixed an error with the multiselect with codes without All filter type. the selected value was not presented with the key value causing problems - it was the same problem that was in a previous bug, I did an overall search for the same error it is not present in any other part of the code now.
10 Fixed an error when trying to validate the sql in the mapping editor with a dynamic date
11. When a multicombo filter with codes and w/o All was selected the key values were not shown in the filter dropdown. 
12. Modified the  MYOB entry for database_types.derivedTables from true to false


July 8th 2010
1. Fixed a bug with selecting the wrong option in the filter dropdown when there were duplicate descriptions.
2. Fixed issue with char() datatype which included padding on fields, which led to filter dropdowns not rendering correctly.
3. Increased with of titles in mapping editor.
4. Dynamic dates bug fixes.



June 30th 2010
1. Removed forgotten debugging alert when adding a calculated variable
2. fixed a problem with case sensitivity in the report filters - the navigation tools were hidden and the value was added as an extra value in the filter dropdown



June 21st 2010
1. Fixed an issue which would prevent favourites where security filters were applied from being generated when they were being called by the emailer.
2. The dynamic date was giving sql in comparison charts
3. Scroll bars were visible when printing in Chrome
4. Extended max number of calc. vars to 100
5. Fixed problem with emailing of certain reports in May 18th build.

May 19th 2010
1. Added Exe version

May 18th 2010
1. When importing mappings the "database connection from existing mappings" dropdown list, displays the mapping name to avoid showning the same dsn multiple times
2. Modifed the abaove option to accept database_string where appropriate
3. Corrected a problem with some warnings appearing at the wrong option when trying to import existing templates/mappings
4. When in the vertical table format and no description was mapped the key in the column headings was being truncated
5. When a value was null in the vertical layout the column heading was either displayed "<Null>" for key or nothing for the description. Added the dot option like in horizontal format.
6. Modified the style in the favourites page to get rid of the problem of the favourites table overlapping with side bar. 
7. Default detail num of digits for currency set to 2
8. The dateadd,datediff functions didn't accept "today" as an argument
9. corrected upgrade program to pass over the custom_menus table

May 4th 2010
1. New IR Logo
2. Fixed bug where grouped keys being wrong when the Hide Zero row was being used.
3. Fixed a problem with the dates in the wizard date ranges, when going back from the filters page the dates were being displayed urlencoded

Apr 15th 2010
1. Added help entries for mass emailing alerts feature.
2. Fixed some problems with some of the date ranges when in the beginning of a month, mainly YTY(Last Year) and MTY (This Year)
3. Removed some forgotten debug from previous fixes
4. increased the width of the select boxes in the report field selection part of the template editor
5. When drilling down into the other row data, the values not included in the other row are shown as NOT filter values
6. When a NOT filter value from the analyze by field was applied the other row data were not being calculated correctly
7. When generating a pivot report with a NOT filter for one of the attributes of the first analyze by field, selecting to view the top/bot of the first analyze by field, messes with the layout of the pivot table, 
8. In a gouped comparison report when the right date range has zeros, selecting to hide the zeros rows hides these rows too.
9. In a grouped report, when javascript sorting by a numeric field or the key if it has numbers, then trying to javascript sort by the textual description gives a javascript error


Apr 5th 2010
1. Fixed a bug in grouped comparison reports, when the then by field and the group by fied were the same, drillinging down into a value once, going back with the Back Browser button, drilling down again, was not resetting the groupby field for the new report.
2. Pressing Enter in the filters search box was losing the selections
3. Fixed a problem with the not being able to drilldown into the "other" row data - needed small adjustment after recent changes for the filters encoding.
4. Changed the option in database_types to show the Other row for all the databases.

March 23rd 2010
1. Fixed an issue with dynamic date filter in non MSAccess DBS mapping admin

March 19th 2010
1. Fixed an issue with importing mappings where an empty start/end date in the preferences would cause an SQL error.

March 11th 2010
1. Fixed & issue in Wizard, when drillnig down
2. Modified how filter sorting by code works. When the code variable is hidden, setting the filter sort order by code will always order by code. In the case where the code is invisible it will order by code again.
3. Added a new filter sorting method called by First Column, so that you can sort the filter by the first visible column. 

March 3rd 2010
1. Added Support for Dynamic Dates
2. Added Dynamic Dates Project And Intro

March 2nd 2010
1. Added Emailer support for Excel 2007.

Feb 18th 2010
1. Fixed the scrolling of large reports, so that they scroll correctly now
2. Fixed the find search box for databased that don't support derived tables
3. Stop sorting the left filter box, when removing items.

Feb 15th 2010
1. Added Last 30 Days Date Range
2. Fixed bug in Bulk Import/Export Feature
3. Modified Search box to center the paging widget.

Feb 5th 2010
1. Added support for paging through search results with more than 1,000 entries
2. Added support for bulk importing and exporting templates & mappings
3. Added admin support for configuring alert emails.