ASP.NET - crystal report
Asked By saran vasan
10-Feb-12 02:26 AM
how to create crystal report in asp.net with c Sharp by using dataset and sql stored porcedure.
Somesh Yadav replied to saran vasan

Hi for doing this we need to do 7 steps they are:-
We can create a crystal report.net using the following steps:
- Create a Dataset and define the schema by drag and drop the database table from Server Explorer.
If there are multiple tables then put all the tables within one dataset itself.
STEPS:
Right Click Solution Explorer -> Add -> Add New Item -> choose DataSet under the Categories (Web Project Items - data).
Add new Connection in the Server Explorer and expand the connection to retrieve the database tables and choose the required table and drag and drop it in the Dataset xsd pane.
- Generate Dataset from the Dataset XSD.
STEPS:
Right click on the dataset xsd pane and click Generate Dataset
- Create Crystal Report.
STEPS:
Right Click Solution Explorer -> Add -> Add New Item -> choose Crystal Report under the Categories (Web Project Items).
- Configure the Crystal Report.
STEPS:
- Select Report Layout, ProjectData, ADO.NET DataSets
- Expand ADO.NET DataSets and select the table
- Select the fields
- Create a WebForm and drag and drop the CrystalReportViewer control from the Toolbox(General).
- Put a textbox and button
- Open the Code window of the WebForm and write the following code.
And change the value of the connectionstring variable sqlConn.
For more help refer to the link given below:-
http://www.c-sharpcorner.com/UploadFile/rsubhajit/CrystalReportwithDataSet03012006060655AM/CrystalReportwithDataSet.aspx
I hope this will help you.

Frequently asked Interview Questions in ADO.Net hi friends Any one send frequently asked Important questions in C# .Net, ADO .Net, Asp .Net and Sql Server. . . . . . . . tx in Advance. . . . . . Hi, Find this. . (B)What is an IL? (B)What is a objects in Remoting? (A) What are the ways in which client can create object on server in CAO model? (A) Are CAO stateful in nature? (A) To create objects in CAO
a single.NET DLL contain? Answer1: As many Answer2: One or more What are good ADO.NET object(s) to replace the ADO Recordset object? The differences includes In ADO, the in-memory representation of data is the recordset. In ADO.net, it is the dataset A recordset looks like a single table in ADO In contrast a dataset is a collection of one or more tables in ADO.net ADO is designed primarily for connected access ADO.net the disconnected access to the database is used In ADO you communicate with the database
crystal reports in asp.net I want to add crystal report in asp.net please can u give some good website reference Hi Here are some reference sites: http created in Designer interface. Here are some good links on this http: / / www.beansoftware.com / ASP.NET-Tutorials / Using-Crystal-Reports.aspx http: / / csharpdotnetfreak.blogspot.com / 2009 / 07 / creating-crystal-reports-in-aspnet.html http: / / www.c-sharpcorner.com / uploadfile / mahesh / crystalreportsintroduction11082005014959am / crystalreportsintroduction.aspx http: / / www.highoncoding.com / Articles / 550_Creating_Crystal_Report_in_ASP_NET.aspx Hope this will help Create a Dataset and define the schema by drag and drop the database table from Server Explorer. If there are multiple tables then put all the tables within one dataset itself
Crystal Report can any one tell me how to create crystal report in asp .net 3.5 with c# through code is their is any tutorial please give me link Create a Dataset and define the schema by drag and drop the database table from Server Explorer. If there are multiple tables then put all the tables within one dataset itself. STEPS: Right Click Solution Explorer -> Add -> Add New Item -> choose DataSet under the Categories (Web Project Items - data). Add new Connection in the Server Explorer and expand the connection to retrieve the database tables and choose the required table and dataset xsd pane and click Generate Dataset 3. Create Crystal Report. STEPS:Right Click Solution Explorer -> Add -> Add New Item -> choose Crystal Report under the Categories (Web Project Items). 4. Configure