Release 4.0.867
===============
1. Minimum 3 columns required to build a Cross Tab Report
2. There was a bug with <@=where-clause=@> if it was the only macro tag in the SQL query and user did not input it during 
   the sql definition phase.
3. During SQL Query definition, remove syntax error if user enters spaces in the where-clause field.


Release 4.0.860
===============
1. Allow each report to have it's own template. If the report does not have it's own template, then the generic one 
   for the report type is used.
2. Template editor is incorporated into the Report Designer. New tab has been added.
3. Cross tab reports can now drill down to other report layouts including card layout
4. Misc. bug fixes in template editor
5. Security Groups fix for queries

Release 4.0.788
===============
1. Support for Oracle procedure calls
2. The database prop file now supports the debug=true property to show additional info if things are going wrong
3. form:variables in query fields are mandatory
4. Filter interface enhancements:
		a. Mandatory or ad-hoc filter field definition
		b. Alias name for filter fields
		c. Help text for filters at run time
5. Display enhancements:
		a. Run-form formatting improvements
		b. Query interface screen font improvements
6. Parameters to stored procedures are now through the same interface (with alias and help)
7. Enhanced exception handling for list boxes while running a report, does not give a blank screen anymore
8. Release notes are a part of the release
9. Properties editor bug fix



Release 4.0.656
===============
1. Long names for query fields can be greater than 50 bytes.
2. Bug Fixed - Sort and Filter tabs would not be displayed
3. Access fixes assocatiated with schema/catalog names
4. Activation of LineGraphs
5. Restrict definition of functions for query related fields in the report

For upgrading the application 
a. unzip the patch file and copy the unzipped RRlib.jar to /program files/RightReporter4/webapps/RR4/WEB-INF/lib
b. Replace the SELECTBL contents with the ones of the new rptdb97.mdb
c. Change the field definition of TEXT1 in DBFIELDS
d. Restart RightReporter service.

Note: In some cases you might have to save the already existing inquiry fields



Release 4.0.497

I. Importing of Tables based on Schema
======================================
1. New feature added to allow users to import and perform database joins from mulliple database schemas or catalogs.
	 Impacts:
	 		Import table screens - new screens added to add steps to select schemas
	 		Query builder interface to take fully qualified name for each field. Example in Oracle is:
	 			select * from scott.emp 
	 			where scott is the name of the schema and emp is the table name
	 		All report types now take advantage of this feature allowing users to join across schemas
	 		

II. Query related Enhancements
===============================
1. Allow query designer to enter <@=variables=@> through the forms
	 Impacts:
	 	 Query builder Interface, user does not have to enter URL Options while defining the query


2. Enhancements to Query based data sources to have dynamic filter clause-
   Impacts:
     Query builder Interface can now take statements like in SQL Server query
     			SELECT * FROM pubs.dbo.Authors WHERE <@=where-clause=@>
     Report Designer Interface - users can now go to the filter screens and add filter conditions
     Cross Tab Reports - clicking on a link now correctly pops up data pertaining to the cell/row/column
 	 	 The Where clause can be entered while testing the query without defining it in the URL options on the screen
 	 	 Drill down to a report built on a query source now works correctly

     
3. Enhancements to Query based data sources to have dynamic sort clause-
   Impacts:
     Query builder Interface can now take statements like in SQL Server query
     			SELECT * FROM pubs.dbo.Authors WHERE <@=where-clause=@> <@=order-clause=@>
     Report Designer Interface - users can now go to the sort screens and add sorting fields
     Standard Reports - clicking on a link now correctly sorts the query
     Drill down reports for cross tab reports - clicking on a link now correctly sorts the query
 	 	 The sort clause can be entered while testing the query without defining it in the URL options on the screen
     

III. Graph Enhancements
=======================
1. Graphs to do grouping on other fields that are not used for grouping within the report
	 Impacts:
	 		Graph Interface now allows users to define fields other than the grouping fields
	 		
2. Line Graphs added

3. Graphs on multiple fields
	 Impacts:
	 	  Mutliple graphs on the same chart possible for line and bar charts
	 	  Graph Interface takes in more information

	 		
IV. Security Enhacements
========================
1. Design Interface now shows reports that allowed for the designer's security
2. Designer can only select reports and queries that are allowed for the designer's security


V.  Performance Enhancements
============================
1. Allow users to define property file for any data source and define any connection property supported by the vendor.
2. Removal of logging information for reporting speedup.


VI. Interface Enhacements
=========================
1. Run form input fields and prompts are now displayed on a table
2. Run form now defaults to show graphs and don't show report details



IV.  Bug Fixes
==============
1. Bug fixed in grouping graphs on numeric fields.
2. Bug fixed in cross tab summery on numeric fields.
3. Report based on query sources sometimes gives wrong columns. Requires user to save the same query once again.
4. Count of records problems in graphs was incorrect in some cases
5. Formula problems in Graph
6. Next Button problem fix.
7. Misc formatting changes in Query, Sort and Run form screens
8. Report Tag is now working correctly