Using Crystal Report with Oracle and parametrized Query (Passing sql query parameters to crystal reports)
This article gives an idea as how to use report in .Net Windows Application with parametrized queries and as Database using dataset.I had searched on internet for articles related to Report with parametrized query with ,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. Report with parametrized query.
2. Using Views because here stored procedure will not be able to do this job because of the fact that Stored Procedure does not return Multiple Rows(Record Set) as Sql Server Stored Procedures do.
3. Using DataSet.
Hence I have used views in this project to bind the 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 Report with . There are many methods to do this job, even we can create 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:
Hope you will found this blog useful .