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.

data bases for sequence clustering

hi

where i can find some data bases to see how the sequence clustering works?.

thanks a lot

The sample database AdventureWorksDW has datasets for all Microsoft data mining algorithms. You can follow the instructions given in the following tutorial to get this database and try Microsoft Sequence Clustering (and all other Microsoft data mining algorithms):

http://www.sqlserverdatamining.com/dmcommunity/_tutorials/59.aspx

Thanks,

Data base learning resources?

Hello:

I'm a beginner in data bases and I'm looking for data base theory,learning, preactices and another resources. Can you recommend me books, e-books, journals, web sites and communities? I'll aprreciate your help.

Thanks.

You might want to start at the top of the posts; there is a listing here.

Give a look to the discussion here. A number of good books are referenced.

|||

My latest book "Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)" (Addison Wesley) is currently holding a 5-star rating on Amazon. It has helped thousands of developers at every skill level from beginner to pro.

I've written a dozen books over the years--many written while I was at Microsoft writing the data access help topics and Data Access Guides for Visual Basic versions 2-5. In my own books I wanted to provide a more independent and comprehensive set of documentation using a style and focus that Microsoft would not permit me to use. Since I focus almost exclusively on Visual Studio and SQL Server readers don’t have to be confused by irrelevant designs or features that don’t apply in their applications.

The 7^th Edition is also designed for you--the beginner. It contains content designed to bring your skills up to speed across the wide spectrum of tools and .NET Framework classes you'll need to design, code, build, debug and deploy successful applications and server-side executables. I talk about how to design applications given your and your company's skills, requirements and constraints. I talk about how SQL Server works behind the scenes in a way that makes it easy to understand how to leverage its power. I show how to best use Visual Studio to leverage this power and how to use SQL Server Management Studio and the other SQL Server tools like the Profiler to manage the databases you create. I talk about SQL Server Express, SQL Server Compact Edition and all of the other editions as well, understanding that many readers need to leverage the free versions of SQL Server as they get up to speed or work to prototype a larger application.

Key topic coverage includes:

? Data access architectures and how to choose the best strategy for Windows Forms, ASP.NET, XML Web Services, and SQL Server CLR executables. Where do these make sense and how much will they cost to build and maintain?

? SQL Server and relational database fundamentals and inner-machinery. How does SQL Server work and why is it important that developers know?

? Making the development experience more productive through judicious use of the Visual Studio toolset, and how to know when the wizards can help.

? Using the latest ADO.NET data provider efficiently and safely.

? How to protect the security of your database–and your job–by avoiding common mistakes.

? How to build secure, efficient, scalable applications in less time with fewer resources–how to create faster code faster.

? How to leverage the potential of SQL Server CLR executables and knowing

when these features make sense.

? How to work with your DBA to maintain database integrity and security.

? Working with the new Visual Studio report controls to expose your organization’s data safely and easily with or without leveraging existing SQL Server Reporting Services technology.

The book also contains a GUID that can be used to gain access to the premium area on the book’s unique support website. There I provide additional errata and a question-and-answer area for those needing direct support from me and the other readers. The book includes a DVD that contains a wealth of examples and sample databases that illustrate the points in the book.

I hope this helps.

William Vaughn

Microsoft MVP, Mentor, Author, Dad, Granddad

Data base learning resources?

Hello:

I'm a beginner in data bases and I'm looking for data base theory,learning, preactices and another resources. Can you recommend me books, e-books, journals, web sites and communities? I'll aprreciate your help.

Thanks.

You might want to start at the top of the posts; there is a listing here.

Give a look to the discussion here. A number of good books are referenced.

|||

My latest book "Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)" (Addison Wesley) is currently holding a 5-star rating on Amazon. It has helped thousands of developers at every skill level from beginner to pro.

I've written a dozen books over the years--many written while I was at Microsoft writing the data access help topics and Data Access Guides for Visual Basic versions 2-5. In my own books I wanted to provide a more independent and comprehensive set of documentation using a style and focus that Microsoft would not permit me to use. Since I focus almost exclusively on Visual Studio and SQL Server readers don’t have to be confused by irrelevant designs or features that don’t apply in their applications.

The 7^th Edition is also designed for you--the beginner. It contains content designed to bring your skills up to speed across the wide spectrum of tools and .NET Framework classes you'll need to design, code, build, debug and deploy successful applications and server-side executables. I talk about how to design applications given your and your company's skills, requirements and constraints. I talk about how SQL Server works behind the scenes in a way that makes it easy to understand how to leverage its power. I show how to best use Visual Studio to leverage this power and how to use SQL Server Management Studio and the other SQL Server tools like the Profiler to manage the databases you create. I talk about SQL Server Express, SQL Server Compact Edition and all of the other editions as well, understanding that many readers need to leverage the free versions of SQL Server as they get up to speed or work to prototype a larger application.

Key topic coverage includes:

? Data access architectures and how to choose the best strategy for Windows Forms, ASP.NET, XML Web Services, and SQL Server CLR executables. Where do these make sense and how much will they cost to build and maintain?

? SQL Server and relational database fundamentals and inner-machinery. How does SQL Server work and why is it important that developers know?

? Making the development experience more productive through judicious use of the Visual Studio toolset, and how to know when the wizards can help.

? Using the latest ADO.NET data provider efficiently and safely.

? How to protect the security of your database–and your job–by avoiding common mistakes.

? How to build secure, efficient, scalable applications in less time with fewer resources–how to create faster code faster.

? How to leverage the potential of SQL Server CLR executables and knowing

when these features make sense.

? How to work with your DBA to maintain database integrity and security.

? Working with the new Visual Studio report controls to expose your organization’s data safely and easily with or without leveraging existing SQL Server Reporting Services technology.

The book also contains a GUID that can be used to gain access to the premium area on the book’s unique support website. There I provide additional errata and a question-and-answer area for those needing direct support from me and the other readers. The book includes a DVD that contains a wealth of examples and sample databases that illustrate the points in the book.

I hope this helps.

William Vaughn

Microsoft MVP, Mentor, Author, Dad, Granddad

Dashboard Guage type graph?

Hi,
I am on RS sp1, I have developed several reports bases on Analysis Services
cubes. I use in the reports several pie, bar, etc charts. I would like to
know if there is a Dashboard type Guage chart ( sort of like a speedometer
in the dashboard of one's car) in the RS graphicas library, maybe not built
in but can be added to the RS existing Graphics library, where I can use it
seemlesly as if it wa part of the product. If an addition exists, how do I
get it and what is the procedure to add it in.
Thank you in advance for your help.
--
Message posted via http://www.sqlmonster.comwould't that be nice. The extensions RS are very expensive. Every executive
now wants some sort of analog guage to display the overall aggregates of
their metrics at different levels of the enterprise.
--
Message posted via http://www.sqlmonster.com|||Here is an idea:
You could try creating a background image that gives the appearance of
the dashboard, then use a pie-chart with 2 values to act as the guage.
If you place it just right, you may be able to simulate the "Guage"
appearance you want.
Good luck!
~Lance Hunt
http://weblogs.asp.net/lhunt/