Reports and Data are dependent on one another. If there wasn’t data, there really wouldn’t be any reason to report. Reports are basic ways that people can get at their data in an understandable format.
Understanding Data and Data Sources
A Database is a place to manage data within your company. SQL is the programming language that allows one to perform operations on that data.
Most if not all database tools have some common components:
- SQL is the programming language.
- Tables are tasked with containing all of the data stored within a database.
- Views are for displaying the data in a customized format for easier usability. Views hide the unnecessary information from the user.
- Stored Procedures are pre-compiled queries, they are also used to set requested values which are passed into the query. For example a query that reports requested days of for each individual. A parameter would be the individual
Crystal Reports is an excellent tool for reporting data contained within a database.
There are a variety of database tools available. The types are very diverse on the low end, one can find MS access and on the high end there is Oracle. There are open-source databases, such as MySQL, and middle of the road, such as MS SQL. The most common thread across all database access is accessing the database.
With crystal reports there are two very common ways to access a database. One can directly connect through direct access or use Open Database Connectivity, ODBC.
Subscribe and Share!
Did you enjoy this article? Your feedback is very important! I'd like to invite you to keep up to date with the latest posts from Anticlue. We offer several venues. If you have some questions, help can be found here.- Become a Facebook Fan
- Subscribe to Anticlue
- Follow me on Twitter
- Add to Technorati Favorites
- Digg this post
0 Comments to “Accessing Data with Crystal Reports Designer”
Please share your thoughts and suggestions
-
Receive Our eNewsletter
The latest Project Management and Healthcare IT practices
-
About Me
Welcome to the Healthcare IT Project Management Blog of Elyse Nielsen. This is the place where I share the ideas I have learned, the things I’d like to remember, and my thoughts for a brighter future. Find out more.
Subscribe to Our Tips
This weblog is licensed under a Creative Commons License.