Yagnesh Tatmiya

Crystal Report with .Net – 2

Introduction

We have started to learn Crystal Report with .Net simple application now we are going for one more step that is connection with database. We need to have SQL server database with specific Table and Stored Procedure, I m guessing you are aware of this all. We need Stored Procedure for selecting record from particular table. To make information of report dynamic we are taking data from where that are being updating regularly. Following image is just give idea how application is interacting with database and report. We have to call data base from application i.e. code file and loads report with the help of dataset.

Let’s start build application for Crystal Report

We have Database: test, Tables: profile, Vehcle, Stored Procedures: getprofile,
getVehcle.

1. Crete new website.
2. Add Asp.Net folder App_Code folder
3. Add new item profile.xsd in App_code folder
4. Open profile.xsd right click on page and Add TableAdapter

1. When you click on TableAdapter option you will be ask about connection string and databse information and click on Next >

1. When u click next u will get following screen, we can select any of the option as requirement but we have already Stored Procedure so select third option and press Next >

    

   

    

2. By clicking Next on from previous one you will get following select your procedure and press Next

    

   

    

3. Choose methods to generate screen as follow, select next

1. Now you will get final screen of Wizard result

    

   

    

And as you click on finish you will get TableAdapter with ‘getprofile’ name and also u can add any TableAdapter

Now your data set is ready to use. Now add new report file to the solution and give in database source this dataset

1. Create new report file
2. You can use formatting report but we have taken here with blank report
3. From Field explorer right click on Database Fields > Database Expert > Create new connection > ADO.NET > give path of Dataset which we created earlier. > you will get following screen

    

    

   

    

4. Select Data Adapter which you want to list and press ok
5. Database fields > Drag and drop fields want to print on report.
6. Report file is ready to use.

    

Now we are going to use both Dataset and report file. Following is process to use that files. Drag and drop report viewer tool to the .aspx file. Bellow code is written in page load event and we have use .vb as language.

Application code file .vb and .cs will have connection string connection string is:

Dim conn As
New System.Data.SqlClient.SqlConnection(“testConnectionString”))

We will use procedures to fetch data from database as in SqlCommand object:

Dim cmd As
New System.Data.SqlClient.SqlCommand(“getprofile”, conn)

cmd.CommandType = Data.CommandType.StoredProcedure

Dim cmdVehi As
New System.Data.SqlClient.SqlCommand(“getVehcle”, conn)

cmdVehi.CommandType = Data.CommandType.StoredProcedure

Load command in data table:

Dim xTable As
New System.Data.DataTable()

Dim xTblProgram As
New System.Data.DataTable()

Dim rdr As System.Data.SqlClient.SqlDataReader

conn.Open()

rdr = cmd.ExecuteReader()

xTable.Load(rdr)

rdr = cmdVehi.ExecuteReader()

xTblProgram.Load(rdr)

conn.Close()

Create object of dataset which we create earlier as we have given name that as ‘profile’:

Dim xsdName As
New profile

Call dataset methods:

For
Each dr As System.Data.DataRow In xTable.Rows

xsdName.getProfile.AddgetProfileRow(Convert.ToInt32(dr(“nameid”)), _

dr(“username”).ToString(), dr(“name”).ToString())

Next

For
Each dr As System.Data.DataRow In xTblProgram.Rows

xsdName.getVehcle.AddgetVehcleRow(Convert.ToInt32(dr(“vhid”)), _

dr(“vahicle”).ToString(), dr(“username”).ToString())

Next

Create object of Report document load report and give data source as dataset object:

Dim rptDocument As
New ReportDocument()

rptDocument.Load(Server.MapPath(“crProfile.rpt”))

rptDocument.SetDataSource(xsdName)

Now give data set object as source to report viewer tool and bind it.

crvNames.ReportSource = rptDocument

crvNames.DataBind()

Now enjoy Report if you finding any difficulty please give comment.

Crystal Report with .Net

Crystal Report is a reporting tool for generating report for the application. Here we will learn step by step.

In first we will create just simple report with current date

Create new website with Ajax-enabled, right now only default.aspx, default.aspx.vb, and web.config, here I have taken VB as language. This is first application so we will go in just depth of it.

Now drag and drop crystal report viewer from tool box to the page

Open CrystalReportViewer Task from triangle squared in image bellow. By clicking that you can get popup of CrystalReportViewer Tasks and from that you can chose report source. We are creating report first time so select option <New report source> rounded in following image.

1. Open CrystalReportViever Tasks
2. Creating new report source

By selecting that option you will get following screen. If report is already created then clicks on <Browse…> else select <new report…>. Again we are creating first report then select <New report…>

Then you will get following screen select option As a Blank Report option for blank report.

When u click OK button then u will get new blank report will be added to your solution and will be open. There is field explorer from where u can drag date to report.

1

2

After finishing this one you can see in your .aspx page some code will be as following. There will be to different tags one is for report viewing and other is for source of report

Now just run your application you will get current date as following

This is just first application for starting of learning Crystal report for them who are just beginners.