Thursday, March 8, 2012

Data comparision of different data bases in crystal report 8.5

I have a requirement to compare the data from different data bases ( Oracle , Sybase, DB2) and hight the data if its different then Oracle data.
We have the same data in Oracle ,sybase and DB2. I now need to connect to all these DBs and get the data and then compare them and provide hight light if the data is different.

Can any expert provide me the best way of doing in crystal reports 8.5
I am trying to use the formula field .But don't know how to format the data and dispay with bold in crystal function.Link the databases. Then, if you want to show only the records with mismatched data fields, in your select formula pull only those records where the field(s) you are comparing are not equal. However, if you want to pull (and list) all the records but highlight only the mismatches, use highlighting.

No comments:

Post a Comment