CRYSTAL REPORT BASIC
When we consider about today day today activities, information management plays huge role. It means that data is a one of the resource we have. By managing using proper manner it will be help in many ways to success our day today activities. Therefore people use various types of reports to manage those valuable assets.
As well as, when we consider about software development it also use various types of report as a output of software process. In here I am going to explain basic ways to generate report using CRYSTAL REPORT using .NET C#.
Actually crystal report is one of very powerful tool we have to generate some report which we want. Using that we can easily manage our data and able to provide very good human interactive report.
In here I am use following Data base which I created. And so on I use that Data base to generate report. Figure 1 shows that Data base diagram which I use to generate Crystal Report so on.
Data Base Name: HGSResourceMgt
Data Base Table : StuDetails, StudentSubject, Subject, TeacherDetails, TeacherSubject
Figure 1
Using .Net IDE basically we can create Crystal report though Windows Application or even Web base Application (ASP.net). In here I am explain how to generate crystal report though Windows Application using.Net C#. First of all create new project using .net C#.
1st step:
To add new crystal report to your project simply follows below step.
Solution Explore r on your project right click AddAdd New Item
After that it will gives a popup window like Figure 2. From that select crystal report and by providing name for that able to add new crystal report to project.
Figure 2
2nd Step:
After adding crystal report it will popup new window figure 3 shows that popup window it ask about crystal report type and by selecting crystal report type can create crystal report.
Figure 3
3rd Step:
Next it is very import to provide the database connection details. It means that to generate crystal report definitely we want some database connection using database we can use data which belong to that to generate Crystal report. Figure 4 show that the new popup window. By using that we can provide SQL or any type of Database connection.
Figure 4
Step 5:
Next it will popup window like Figure 5. And using that window can be providing suitable Database connection to crystal report. In here I provide” Microsoft OLE DB Provider for SQL Server “.
Figure 5
6th Step:
Figure 6 show that popup window by providing SQL Server, UserID, Password and Database which going to create crystal report by using Data.
Figure 6
After providing SQL connection detail, it will popup new window like Figure 7. And it will show the SQL Database details which added to crystal report.
Figure 7
Step 7:
Now according to your purpose (To create crystal report using Data base) you can select whatever database table which belong o OLE DB(ADO) . By selecting suitable table you can add them to crystal report and here on you can deal with them and generate reports using data from that table which added. Figure 8 shows that how add database table.
Figure 8
After that simply by click on Next button it will popup window like Figure 9 and I will provide basic details which related to that.
Figure 9
8th Step:
After finishing above steps now it will create basic crystal report. Figure 10 shows that basic crystal report and basically it has five sections. Each and every section has own task and you can do whatever things using that.
Figure 10
Your Comments are highly appreciated; it will be improving my knowledge also.
As well as, when we consider about software development it also use various types of report as a output of software process. In here I am going to explain basic ways to generate report using CRYSTAL REPORT using .NET C#.
Actually crystal report is one of very powerful tool we have to generate some report which we want. Using that we can easily manage our data and able to provide very good human interactive report.
In here I am use following Data base which I created. And so on I use that Data base to generate report. Figure 1 shows that Data base diagram which I use to generate Crystal Report so on.
Data Base Name: HGSResourceMgt
Data Base Table : StuDetails, StudentSubject, Subject, TeacherDetails, TeacherSubject
Figure 1
Using .Net IDE basically we can create Crystal report though Windows Application or even Web base Application (ASP.net). In here I am explain how to generate crystal report though Windows Application using.Net C#. First of all create new project using .net C#.
1st step:
To add new crystal report to your project simply follows below step.
Solution Explore r on your project right click AddAdd New Item
After that it will gives a popup window like Figure 2. From that select crystal report and by providing name for that able to add new crystal report to project.
Figure 2
2nd Step:
After adding crystal report it will popup new window figure 3 shows that popup window it ask about crystal report type and by selecting crystal report type can create crystal report.
Figure 3
3rd Step:
Next it is very import to provide the database connection details. It means that to generate crystal report definitely we want some database connection using database we can use data which belong to that to generate Crystal report. Figure 4 show that the new popup window. By using that we can provide SQL or any type of Database connection.
Figure 4
Step 5:
Next it will popup window like Figure 5. And using that window can be providing suitable Database connection to crystal report. In here I provide” Microsoft OLE DB Provider for SQL Server “.
Figure 5
6th Step:
Figure 6 show that popup window by providing SQL Server, UserID, Password and Database which going to create crystal report by using Data.
Figure 6
After providing SQL connection detail, it will popup new window like Figure 7. And it will show the SQL Database details which added to crystal report.
Figure 7
Step 7:
Now according to your purpose (To create crystal report using Data base) you can select whatever database table which belong o OLE DB(ADO) . By selecting suitable table you can add them to crystal report and here on you can deal with them and generate reports using data from that table which added. Figure 8 shows that how add database table.
Figure 8
After that simply by click on Next button it will popup window like Figure 9 and I will provide basic details which related to that.
Figure 9
8th Step:
After finishing above steps now it will create basic crystal report. Figure 10 shows that basic crystal report and basically it has five sections. Each and every section has own task and you can do whatever things using that.
Figure 10
Your Comments are highly appreciated; it will be improving my knowledge also.
0 comments:
Post a Comment