Crystal report is not display output(plz help me for this problem)

hello sir;

exception occur in clinic dst.xsd

brother;
yes . my db file.

ASSALAM-O-ALIKUM SIR;

CAN U SENT ME .RAR FILE OF THIS CODE.

hi,
Iam trying to restore ur db backup in my Sql 2008 server bt iam getting foll error:

"Error when restoring: There is already an object named sysnsobjs in the database."

protected void Button_generate_report_Click(object sender, EventArgs e)
        {
            //Conn.open();
           int regcode=Convert.ToInt32(DropDownList_patient_reg_code.SelectedValue.ToString());
          // patient_emr rpt = new patient_emr();  // It is a Crystal Report Which you made in the 2nd Step
           SqlDataAdapter da = new SqlDataAdapter();
           // DataSet dst = new DataSet();
           clinic_dst dst = new clinic_dst();
            DataTable ds = new DataTable();
            SqlCommand cmd = new SqlCommand("patientrecord",connection.get());
            cmd.CommandType = System.Data.CommandType.StoredProcedure;
            cmd.Parameters.Add("@patient_regcode",SqlDbType.Int).Value=regcode;// DropDownList_patient_reg_code.SelectedValue.ToString();
            da.SelectCommand = cmd;
            da.Fill(dst);
            //CrystalReportViewer_patientrecord.ReportSource= rpt;
            dst.WriteXmlSchema("clinic_dst.xsd");
            DisplayReport(CrystalReportViewer_patientrecord, dst, Server.MapPath("patient_emr.rpt"));
        }


        public void DisplayReport(CrystalReportViewer crv, DataSet ds, String reportname)
        {
            ReportDocument rptdoc = new ReportDocument();
            rptdoc.Load(reportname);
            rptdoc.SetDataSource(ds);
            crv.ReportSource = rptdoc;
            crv.DataBind();


        }
Execute this code first time.
After that comment this line ---- " dst.WriteXmlSchema("clinic_dst.xsd"); "
And then run your code.
At present the data is not displayed as there are no columns in the datatable in the "clinic_dst.xsd" dataset.
Also check this .aspx code

brother;

this is my appli and db backup

can u plz attach ur application & backup of database.

so i will better help u.

brother;

your querry perfectly execute in querry analyzer . but one record comming many time. i just right this query "timeexec patientrecord '0001'"

Sister,

have u checked my query in ur Sql query analyzer.

Plz execute foll line in query analyzer:

exec patientrecord '0001'  (for eg:assume '0001' is [patient reg code] . plz replce with appropriate value)

& Check whether it is showing some result or not.

ASSALAM-O-ALIKUM SIR;

THE PROBLEM OF NAMESPACE HAS BEEN SOLVED. BUT AGAIN CRYSTAL REPORT DOES NOT GENERATE OUTPUT. I AM SENDING MY CODE N STORE PROCEDURE N CRYSTAL REPORT WEB FORM.

THANKS IN ADVANCE FOR MY HELP.

REGARDS
SUMAIRA MANZOOR

Yes you have to include these namespaces to make this code work.

using CrystalDecisions.Web;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

ok. i am writing by the same method. but in the crystalviewer the error occur by the namespace.

 Error 1:
 The type or namespace name 'CrystalReportViewer' could not be found (are you missing a using directive or an assembly reference?) 

protected void Button_generate_report_Click(object sender, EventArgs e)

{

  SqlDataAdapter da = new SqlDataAdapter();

   DataTable ds = new DataTable();

   SqlCommand cmd = new SqlCommand();

   cmd.CommandText = "patientrecord"; // This is the Procedure name which we have created

cmd.CommandType = System.Data.CommandType.StoredProcedure;

cmd.Parameters.Add("@patient_regcode",SqlDbType.Int).Value = DropDownList_patient_reg_code.Text;

cmd.Connection = connection.get();

cmd.CommandType = System.Data.CommandType.StoredProcedure;

da.SelectCommand = cmd;

da.Fill(ds);

DisplayReport(CrystalReportViewer1, ds, Server.MapPath("xyz.rpt"))

}

public void DisplayReport(CrystalReportViewer crv , DataSet ds , String reportname)
{
  ReportDocument rptdoc = new ReportDocument();
 
  rptdoc.Load(reportname);
  rptdoc.SetDataSource(ds);
  crv.ReportSource = rptdoc ;
  crv.DataBind();
 
}

==========

You can use this function with your code.
Once you have filled the dataset using adapter you can call this function.

public void DisplayReport(CrystalReportViewer crv , DataSet ds , String reportname)
{
  ReportDocument rptdoc = new ReportDocument();
 
  rptdoc.Load(reportname);
  rptdoc.SetDataSource(ds);
  crv.ReportSource = rptdoc ;
  crv.DataBind();
 
}
=====================
Call it like,
DisplayReport(CrystalReportViewer1, ds, Server.MapPath("xyz.rpt"))
I hope this will work.

sir;
i used inner join in this store procedures

hello sir;
actually i am sending "patient reg code" through "drop down list box" .in which place in my code i will put dropdown list. secondly , u saw my table in the post, am i writing correct store procedure. i means , i am fetching data from multiple tables . this store procedure correct for this scenario. 

please bhai, help me. because this problem irritate to from i week.

thanks
regards
sumaira

Hi,

have u checked ur stored procedure working properly in Sql Management studio.

In Sql Management studio, run foll query:

exec patientrecord '0001' 
(for eg:0001 is ur 'patient_regcode' parameter. Plz enter valid value in place of '0001')

Then check that this query gives u result or not

Plz let me know.

ASSALAM-O-ALIKUM BROTHER;

YES, I HAVE ERROR IN MY CODE. BUT WHCIH TYPE OF ERROR IN MY CODE.

REGARDS,
SUMAIRA MANZOOR

hi Sumaira,

r u getting some error?