Click here to Skip to main content
11,641,971 members (59,934 online)
Click here to Skip to main content

Crystal Reports PUSH method using ASP.NET

, 21 Mar 2003 489.1K 80
Rate this:
Please Sign up or sign in to vote.
This article explains how to use PUSH method for drawing reports.

Introduction

This article explains how to use PUSH method for drawing reports. It will also explain how to use user DataSets in an ASP.NET page for reports. There are two types of methods for drawing the reports:

  1. PULL method- the crystal report makes connection with the database, brings the fields data and draws the report.
  2. PUSH method- we create the DataSet, choose fields of the DataSet as report fields and then push it to the crystal report. Here I am going to explain the PUSH method only.

Steps

  1. Create a new ASP.NET project.

    Sample screenshot

  2. Insert new item as DataSet.

    Sample screenshot

  3. Add elements to the DataSet which you want on the report. Save All, then right click on the DataSet filename in the solution explorer and select command "Build and browse".
  4. Then add a new item to the project as “Crystal report” and insert a blank report.
  5. In the server explorer, right click database field and select database expert and expand the project data and select DataSet in the table selector and press OK.

    Sample screenshot

  6. Then drag the fields from the database fields of server explorer in the detail section of the report. Arrange the fields as you want.

    From the toolbox, add crystal report viewer control on to the page. That will add this variable:

    protected CrystalDecisions.Web.CrystalReportViewer CrystalReportViewer1;
  7. Populate the DataSet. Set the report DataSource and CrystalReportViewer report source.
    private void Page_Load(object sender, System.EventArgs e)
    {
    CrystalReport1 report=new CrystalReport1();
    CrystalReportViewer1.Visible=true;
    DataSet ds=new DataSet("Account");//give same name as on 
    //dataset1 table header
    DataTable table=new DataTable("Account");//give same name as on 
    //dataset1 table header 
    table.Columns.Add("Fname",typeof(System.String));
    table.Columns.Add("Lname",typeof(System.String));
    table.Columns.Add("Salary",typeof(System.String)); 
    DataRow row=table.NewRow();
    row["Fname"]="Mathew";
    row["Lname"]="Hayden";
    row["Salary"]="5000$";
    // add to table
    table.Rows.Add(row);
    ds.Tables.Add(table);
    // set report's dataset
    report.SetDataSource(ds);
    // set report source
    CrystalReportViewer1.ReportSource =report;
    }

    The output will be as follows...

    Sample screenshot

Points to be careful of

  1. Give same names on Dataset and the table element name of inserted DataSet.
  2. As and when you modify DataSet, build it again and log off the current connections in report. Set the DataSource location again pointing to new DataSet, otherwise database fields of the report will not take the change.
  3. Setting up DataBind properties of the report viewer can be avoided. It can be done at runtime.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Omkar Bhave M
Software Developer (Senior) Autodesk Inc.
United States United States
my name is omkar bhave. I work in Autodesk Inc. USA.

You may also be interested in...

Comments and Discussions

 
QuestionReport with detail Pin
Ali-1922-Jul-12 20:17
memberAli-1922-Jul-12 20:17 
Very nice example, i have two datatable one with master info and second with details the problem i am facing is that if there are two rows in details then crystal report is showing two reports and i want details in a single report
please help
QuestionAwesome! Pin
chriskellerx1030-Mar-12 4:26
memberchriskellerx1030-Mar-12 4:26 
GeneralMy vote of 3 Pin
jyothi87.u28-Sep-11 4:44
memberjyothi87.u28-Sep-11 4:44 
GeneralProblem loading report wid dataset Pin
Member 449102730-Mar-11 23:15
memberMember 449102730-Mar-11 23:15 
QuestionHow to use an external dataset Pin
arvee200314-Feb-11 5:05
memberarvee200314-Feb-11 5:05 
GeneralCould you please send the project code , I am facing some issue in creating reports object as I am unable to create a New web project in VS2005 Pin
magham14-Dec-10 12:36
membermagham14-Dec-10 12:36 
GeneralMy vote of 5 Pin
magham14-Dec-10 12:33
membermagham14-Dec-10 12:33 
Generali added a crystal report to my window application.. but when i try create an object i cant access it Pin
pooran singh niranjan28-Jun-10 1:47
memberpooran singh niranjan28-Jun-10 1:47 
GeneralRe: Crytal reports Pin
KhanImranKhan26-Jan-10 19:56
memberKhanImranKhan26-Jan-10 19:56 
Generalerror in this line CrystalReport1 report=new CrystalReport1(); Pin
Member 397146816-Apr-09 9:40
memberMember 397146816-Apr-09 9:40 
GeneralRe: error in this line CrystalReport1 report=new CrystalReport1(); Pin
VejeeSachi26-Apr-09 15:36
memberVejeeSachi26-Apr-09 15:36 
GeneralRe: error in this line CrystalReport1 report=new CrystalReport1(); Pin
ashish64198619-May-09 21:40
memberashish64198619-May-09 21:40 
GeneralRe: error in this line CrystalReport1 report=new CrystalReport1(); Pin
wbeetge23-Feb-10 21:16
memberwbeetge23-Feb-10 21:16 
GeneralRe: error in this line CrystalReport1 report=new CrystalReport1(); Pin
Member 449102730-Mar-11 23:24
memberMember 449102730-Mar-11 23:24 
GeneralMY ID [modified] Pin
JAYRAJ GIRI11-Apr-09 3:04
memberJAYRAJ GIRI11-Apr-09 3:04 
Generalcrystal reports Pin
JAYRAJ GIRI26-Mar-09 20:59
memberJAYRAJ GIRI26-Mar-09 20:59 
GeneralDynamically alter the page size of crystal report Pin
dilip51411-Mar-09 21:10
memberdilip51411-Mar-09 21:10 
QuestionDataset with multiple tables Pin
Spunkybabe23-Feb-09 5:53
memberSpunkybabe23-Feb-09 5:53 
QuestionSet Formula field in Crystal report Pin
biswajit nayak15-Nov-08 22:52
memberbiswajit nayak15-Nov-08 22:52 
GeneralCrystal report Pin
Amit S Manekar2-Oct-08 23:06
memberAmit S Manekar2-Oct-08 23:06 
Generalcant access the crystalReport Pin
Slick694-Sep-08 11:27
memberSlick694-Sep-08 11:27 
QuestionCan anyone tell me how to upload ASP.NET application with Crystal report on WEB Pin
Amit Papriwal10-Jul-08 22:14
memberAmit Papriwal10-Jul-08 22:14 
QuestionCrystal Report in asp.net 2005 Facing Problem Pin
GIRISH KUMAR PRAJAPATI9-Jun-08 19:30
memberGIRISH KUMAR PRAJAPATI9-Jun-08 19:30 
QuestionHow to set a fixed height of Crystal report in asp.net Pin
Jhanvy Thaker7-May-08 21:53
memberJhanvy Thaker7-May-08 21:53 
Questionplease help Pin
muthumani12-Feb-08 0:02
membermuthumani12-Feb-08 0:02 
QuestionASP to crystal Reports .rpt NEED HELP Pin
mjelin26-Apr-07 9:10
membermjelin26-Apr-07 9:10 
GeneralQuestion adout PUSH model Pin
Derrick Lasantha11-Mar-07 23:41
memberDerrick Lasantha11-Mar-07 23:41 
QuestionQuestion Pin
iceborg24-Jan-07 4:03
membericeborg24-Jan-07 4:03 
AnswerRe: Question Pin
omkar bhave M24-Jan-07 11:16
memberomkar bhave M24-Jan-07 11:16 
Questionicons missing when report is run Pin
techie_risa8-Jan-07 19:39
membertechie_risa8-Jan-07 19:39 
AnswerRe: icons missing when report is run Pin
sylvesterg24-Jan-07 4:17
membersylvesterg24-Jan-07 4:17 
AnswerRe: icons missing when report is run Pin
prabodhbansal5-Feb-07 1:07
memberprabodhbansal5-Feb-07 1:07 
GeneralHelp , asp.net 1.0 with crystal report Pin
beginhs11-Oct-06 16:58
memberbeginhs11-Oct-06 16:58 
QuestionCannot get specific Line of code Pin
Gaurav Rathod17-Jul-06 20:34
memberGaurav Rathod17-Jul-06 20:34 
GeneralHELP Pin
malemsteen2-Jul-06 0:00
membermalemsteen2-Jul-06 0:00 
GeneralLogon Problem Pin
Muneeeb13-Apr-06 21:00
memberMuneeeb13-Apr-06 21:00 
GeneralKeyup in datagrid in vb.net Pin
Anonymous6-Aug-05 0:48
sussAnonymous6-Aug-05 0:48 
GeneralCrystal report In asp.net Pin
Anonymous6-Aug-05 0:40
sussAnonymous6-Aug-05 0:40 
GeneralPage Scrolling in Crystal Reports 11 .NET Pin
babukabraham@yahoo.com13-Jun-05 5:00
sussbabukabraham@yahoo.com13-Jun-05 5:00 
GeneralCreating Report Dynamically Pin
Dronik10-Apr-05 22:34
memberDronik10-Apr-05 22:34 
GeneralGood Article Pin
norm.net6-Apr-05 4:33
membernorm.net6-Apr-05 4:33 
GeneralPlugging report with Dataset Pin
Anonymous2-Mar-05 11:14
sussAnonymous2-Mar-05 11:14 
GeneralCrystal Report in .Net Pin
GeethP1-Mar-05 21:58
sussGeethP1-Mar-05 21:58 
QuestionHow justify report? Pin
myanonym23-Feb-05 8:50
membermyanonym23-Feb-05 8:50 
AnswerRe: How justify report? Pin
Anonymous21-Sep-05 14:44
sussAnonymous21-Sep-05 14:44 
Generalcrystal report sample Pin
Anonymous25-Nov-04 19:48
sussAnonymous25-Nov-04 19:48 
GeneralManually code the dataset and report bind Pin
cfaulkner1-Nov-04 5:45
membercfaulkner1-Nov-04 5:45 
GeneralRe: Manually code the dataset and report bind Pin
frasse5314-Nov-04 18:10
memberfrasse5314-Nov-04 18:10 
QuestionIf the report having a sub report, how can I do? Pin
Goldsunline5-Oct-04 20:10
memberGoldsunline5-Oct-04 20:10 
GeneralGood article Pin
frasse5320-Sep-04 7:51
memberfrasse5320-Sep-04 7:51 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.150731.1 | Last Updated 22 Mar 2003
Article Copyright 2003 by Omkar Bhave M
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid