I want to show my report in report viewer but it dosen't show for me.
This my code:
private void buttonX1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=FADAEILAPTOP-PC;Initial Catalog=ClerksEvaluation;Integrated Security=True");
DataSet a = new DataSet();
DataTable dtbl = new DataTable("DataTable1");
SqlDataAdapter adp = new SqlDataAdapter();
adp.SelectCommand = new SqlCommand();
adp.SelectCommand.Connection = con;
adp.SelectCommand.CommandText = "Report";
adp.SelectCommand.CommandType = CommandType.StoredProcedure;
adp.SelectCommand.Parameters.AddWithValue("@clrk_Name", name.Text);
adp.SelectCommand.Parameters.AddWithValue("@clrk_Family", family.Text);
adp.SelectCommand.Parameters.AddWithValue("@clrk_MelliCode", melli.Text);
SqlDateTime az_d = SqlDateTime.Parse(az.Text);
adp.SelectCommand.Parameters.AddWithValue("@AzTarikh", az_d);
SqlDateTime ela_d = SqlDateTime.Parse(ela.Text);
adp.SelectCommand.Parameters.AddWithValue("@Ela", ela_d);
adp.Fill(a, "DataTable1");
Form1 f1 = new Form1();
ReportDataSource source = new ReportDataSource("datatable1", dtbl);
f1.reportViewer1.Visible = true;
f1.reportViewer1.ProcessingMode = ProcessingMode.Local;
f1.reportViewer1.LocalReport.ReportPath = "Report1.rdlc";
f1.reportViewer1.LocalReport.DataSources.Clear();
f1.reportViewer1.LocalReport.DataSources.Add(source);
f1.reportViewer1.LocalReport.Refresh();
f1.Show();
}
this doesn't have any error.
this is my procedure and it doesn't have error.
this doesn't have any error.
this is my procedure and it doesn't have error.
USE [ClerksEvaluation]
GO
/****** Object: StoredProcedure [dbo].[Report] Script Date: 02/06/2013 09:17:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[Report]
@clrk_NameNvarchar(50),
@clrk_FamilyNvarchar(60),
@clrk_MelliCodeChar(10),
@AzTarikhDate,
@ElaDate
AS
Declare @id int
select @id = clrk_Id from Clerk
where clrk_Name = @clrk_Name and clrk_Family = @clrk_Family and clrk_MelliCode = @clrk_MelliCode
select clrk_Name,clrk_Family,clrk_MelliCode,clrk_FatherName, epcnt_Name, clrke_Percent, clrke_Tozihat, clrke_Date, clrke_Hafteh
from ClerkEvaluation
inner join Clerk on Clerk.clrk_Id = @id
inner join EvaluationPercent on ClerkEvaluation.epcnt_Id = EvaluationPercent.epcnt_Id
where clrke_Date Between @AzTarikh and @Ela
my ReportViewer binded to procedure.
Could you help me?
Could you help me?
7 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Shivi AttriPosted Aug 5, 2013, 3:03 AM
elham deljooeiPosted Feb 17, 2013, 5:55 AM
I did it.
private void buttonX1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=FADAEILAPTOP-PC;Initial Catalog=ClerksEvaluation;Integrated Security=True");
DataSet a = new DataSet();
DataTable dtbl = new DataTable();
SqlDataAdapter adp = new SqlDataAdapter();
adp.SelectCommand = new SqlCommand();
adp.SelectCommand.Connection = con;
adp.SelectCommand.CommandText = "Report";
adp.SelectCommand.CommandType = CommandType.StoredProcedure;
adp.SelectCommand.Parameters.AddWithValue("@clrk_Name", name.Text);
adp.SelectCommand.Parameters.AddWithValue("@clrk_Family", family.Text);
adp.SelectCommand.Parameters.AddWithValue("@clrk_MelliCode", melli.Text);
SqlDateTime az_d = SqlDateTime.Parse(az.Text);
adp.SelectCommand.Parameters.AddWithValue("@AzTarikh", az_d);
SqlDateTime ela_d = SqlDateTime.Parse(ela.Text);
adp.SelectCommand.Parameters.AddWithValue("@Ela", ela_d);
adp.Fill(dtbl);
//SqlCommand cmd = new SqlCommand("report", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@clrk_Name", name.Text);
//cmd.Parameters.AddWithValue("@clrk_Family", name.Text);
//cmd.Parameters.AddWithValue("@clrk_MelliCode", name.Text);
//SqlDateTime az_d = SqlDateTime.Parse(az.Text);
//cmd.Parameters.AddWithValue("@AzTarikh", az_d);
//SqlDateTime ela_d = SqlDateTime.Parse(ela.Text);
//cmd.Parameters.AddWithValue("@Ela", ela_d);
//SqlDataAdapter da = new SqlDataAdapter(cmd);
//DataTable dt = new DataTable();
//da.Fill(dt);
Form1 f1 = new Form1();
//ReportDataSource source = new ReportDataSource("datatable1", dtbl);
f1.reportViewer1.Visible = true;
//f1.reportViewer1.ProcessingMode = ProcessingMode.Local;
//f1.reportViewer1.LocalReport.ReportPath = "Report1.rdlc";
f1.reportViewer1.LocalReport.DataSources.Clear();
ReportDataSource source = new ReportDataSource("DataSet1", dtbl);
f1.reportViewer1.LocalReport.DataSources.Add(source);
f1.reportViewer1.LocalReport.Refresh();
f1.Show();
}
"DataSet1" is name of report's data source. Therefor you can see in Report's smart tag and choose Choose Data Source.
Good luck Friends.
elham deljooeiPosted Feb 8, 2013, 11:55 PM
It's suffix of Report. when you add a Report to your project, it show for you for example Report1.rdlc (name of Your report)
Thx for you read my question.
venkata kumarPosted Feb 8, 2013, 11:31 PM
i dont know rdlc
elham deljooeiPosted Feb 6, 2013, 11:59 PM
I would like to solve this problem...
elham deljooeiPosted Feb 6, 2013, 5:29 AM
if you mean Report1.rdlc (Add new item\ Select Report from list), i can't define an object from it, or Reportviewr1 i can't define an object from it because i put Reportviewer1 into form1.
I don't use crystal report.
Could you help me?
Thx for your help.
venkata kumarPosted Feb 6, 2013, 4:40 AM
Reportname1 _objReport = new Reportname1();
_objReport.Load("@\\Reports\\Reportname1.rpt");
_objReport.SetDataSource(ResultDetails.Tables[0].DefaultView);
crystalReportViewer1.ReportSource = _objReport;
crystalReportViewer1.Refresh();