Page_Load for Crystal Report

Question

0.00/5 (No votes)

See more:

I have a page with CrystalReportViewer on it and a report in the viewer. I am trying to print out the report using a session but no luck so far. I have a code that might your but so far I have errors in the code. This is my first time working with Crystal Reports on this level. I never did the sessions on it before. Here is the code.

C#

using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using CrystalDecisions.Web;
using System.Web.UI.WebControls.WebParts;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Xml.Linq;


namespace SACSCOCLogin1._1
{
    public partial class ReportFormA : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["HotConnectionString"].ConnectionString);
            con.Open();

            SqlCommand comm = new SqlCommand("SELECT * FROM Table55 where INST_ID=" + Session["INST_ID"].ToString(), con);
            comm.CommandType = CommandType.Text; SqlDataAdapter adapter = new SqlDataAdapter();

            adapter.SelectCommand = comm;

            CrystalReportViewer1 dataset = new CrystalReportViewer1();
            adapter.Fill(dataset, "DataTable1");

            CrystalReportViewer1.SetDataSource(dataset);

            CrystalReportViewer1.ReportSource = crystal;

        }   
        
    }
}

This is where my error are in the code

C#

CrystalReportViewer1 dataset = new CrystalReportViewer1();
            adapter.Fill(dataset, "DataTable1");

            CrystalReportViewer1.SetDataSource(dataset);

            CrystalReportViewer1.ReportSource = crystal;

What am I doing wrong? Can this be fixed or should I go another route?

New Updated code not yet working but getting there.

C#

SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["HotConnectionString"].ConnectionString);
            con.Open();

            SqlCommand comm = new SqlCommand("SELECT * FROM Table55 where INST_ID=" + Session["INST_ID"].ToString(), con);
            comm.CommandType = CommandType.Text;
            SqlDataAdapter adapter = new SqlDataAdapter();

            adapter.SelectCommand = comm;

            CrystalReportViewer dataset = new CrystalReportViewer();
            DataTable dt = new DataTable();
            adapter.Fill(dt);

            dataset.SetDataSource(dt);

            CrystalReportViewer1.ReportSource = new CrystalReportViewer();

Posted 10-Feb-14 8:55am

Computer Wiz99

Updated 10-Feb-14 10:06am

v2

Add a Solution

Comments

Richard C Bishop 10-Feb-14 14:56pm

What are the errors?

Computer Wiz99 10-Feb-14 15:01pm

CrystalReportViewer1 on both sides has errors: CrystalReportViewer1'is a 'field' but is used like a 'type'.

SetDataSource error:'CrystalDecisions.Web.CrystalReportViewer' does not contain a definition for 'SetDataSource' and no extension method 'SetDataSource' accepting a first argument of type 'CrystalDecisions.Web.CrystalReportViewer' could be found (are you missing a using directive or an assembly reference?)

crystal error: The name 'crystal' does not exist in the current context

Richard C Bishop 10-Feb-14 15:16pm

You are instantiating CrystalReportViewer1 as "dataset" and then trying to use properties of the CrystalReportViewer class and set them on the class instead of the instantiated object.

Computer Wiz99 10-Feb-14 15:18pm

Ok. What can I do to change it or am I going in the right direction when trying to call the report by using a session?

Richard C Bishop 10-Feb-14 15:19pm

You are close but you want something like this:
CrystalReportViewer1 report = new CrystalReportViewer1(); report.SetDataSource(dataset);

Computer Wiz99 10-Feb-14 15:23pm

Ok. I changed what you typed in but still got the error on CrystalReportViewer1 report = new CrystalReportViewer1();. I took out the 1 and the errors cleared. Should I leave it as that?

Richard C Bishop 10-Feb-14 15:25pm

Yes, remove the 1 if the class does not have that in its name.

Computer Wiz99 10-Feb-14 15:31pm

Should DataTable be something else.

Computer Wiz99 10-Feb-14 15:21pm

The other thing is also, I don't think I have a DataTable. How can I rewrite that?

Richard C Bishop 10-Feb-14 15:23pm

See the solution for an example.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard C Bishop · Answer 1 · 2014-02-10T09:23:00

See also my comments above:

Here is an example of what you can do.

using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using CrystalDecisions.Web;
using System.Web.UI.WebControls.WebParts;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Xml.Linq;
 
namespace SACSCOCLogin1._1
{
    public partial class ReportFormA : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["HotConnectionString"].ConnectionString);
            con.Open();
 
            SqlCommand comm = new SqlCommand("SELECT * FROM Table55 where INST_ID=" + Session["INST_ID"].ToString(), con);
            comm.CommandType = CommandType.Text; 
            SqlDataAdapter adapter = new SqlDataAdapter();
 
            adapter.SelectCommand = comm;
 
            CrystalReportViewer dataset = new CrystalReportViewer();
            DataTable dt = new DataTable();
            adapter.Fill(dt, "DataTable1");
 
            dataset.SetDataSource(dt);
 
            dataset.ReportSource = crystal;
 
        }   
        
    }
}

Computer Wiz99 · Answer 2 · 2014-02-10T09:26:00

Solution 2

C#

CrystalReportViewer report = new CrystalReportViewer();
            adapter.Fill(dataset, "DataTable1");

            report.SetDataSource(dataset);

            CrystalReportViewer1.ReportSource = crystal;

The new code so far. Where the underline is is where the errors are still.

Posted 10-Feb-14 9:26am

Computer Wiz99

Comments

Richard C Bishop 10-Feb-14 15:27pm

Copy and paste my code verbatim. You're a bit off on your code. "Crystal" does not exist anywhere, so that will either need to be created or removed.

Richard C Bishop 10-Feb-14 16:10pm

See this article, maybe it will help you:

http://social.msdn.microsoft.com/Forums/vstudio/en-US/95c2a550-ed28-427e-ab85-f79b19f832f1/datatable-to-crystal-report?forum=csharpgeneral

Computer Wiz99 10-Feb-14 16:12pm

Ok. I will look into it.