Using Crystal Report with Oracle and parametrized Query (Passing sql query parameters to crystal reports)

[Former Member]

This article gives an idea as how to use Crystal report in .Net Windows Application with parametrized queries andOracle as Database using dataset.I had searched on internet for articles related to Crystal Report with parametrized query with Oracle,but I was unable to find any good article on this topic.So I am posting my article on this topic.

There are three main points in this article.
1. Crystal Report with parametrized query.
2. Using Oracle Views because here stored procedure will not be able to do this job because of the fact that OracleStored Procedure does not return Multiple Rows(Record Set) as Sql Server Stored Procedures do.
3. Using DataSet.
Hence I have used Oracle views in this project to bind the Crystal Report and Dataset.Then I wrote my parametrized query on the view as we do generally on database tables. So this Project will give a good idea on how to Use CrystalReport with Oracle. There are many methods to do this job, even we can create Oracle packeges which will return mutiple records as SQl Server Stored Procedures. But I found this way simple and fast to do.

Note: No special background knowledge is needed for this article. Any beginner or Intermediate will be able to understand this code.It will be good if you have a basic knowledge of database views

You can also follow this link for the same:

http://www.codeproject.com/Articles/28330/Using-Crystal-Report-with-Oracle-and-parametrized

Hope you will found this blog useful .

- Bwuser