Click here to Skip to main content
15,914,767 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
Hi,
I want to develop a Report using RDLC in Window Application using C#.


Please anyone attach sample coding .



Thanks,
Posted

Try these Articles
RDLC Reports
Reporting in C#
 
Share this answer
 
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
List<class1> lt = new List<class1>();

private void Form1_Load(object sender, EventArgs e)
{

this.reportViewer1.RefreshReport();
}

private void button1_Click(object sender, EventArgs e)
{
SqlConnection cnn = new SqlConnection("server=.;user id=sa;password=123;database=harish");
string str = "SELECT [ItemStoneID],[ItemCode],[StoneWt],[StoneCarats],[StonePrice],[StoneCost],[StoneID],[Quantity] FROM [dbo].[ItemStoneDetails] where Cast(LastUpdatedAt as date) between'" + textBox1.Text + "' and '" + textBox2.Text + "'";
SqlDataAdapter da = new SqlDataAdapter(str, cnn);
long dataRows = 0;
DataTable dt = new DataTable();
DataSet ds = new System.Data.DataSet();
da.Fill(ds, "ItemStoneDetails");

dt = ds.Tables["ItemStoneDetails"];
dataRows = ds.Tables["ItemStoneDetails"].Rows.Count - 1;
Class1 stone = new Class1();
for (int i = 0; i <= dataRows; i++)
{
stone.Carat = Convert.ToDouble(ds.Tables["ItemStoneDetails"].Rows[i].ItemArray.GetValue(3));
stone.Cost = Convert.ToDouble(ds.Tables["ItemStoneDetails"].Rows[i].ItemArray.GetValue(5));
stone.Price = Convert.ToDouble(ds.Tables["ItemStoneDetails"].Rows[i].ItemArray.GetValue(4));
stone.StoneWt = Convert.ToDouble(ds.Tables["ItemStoneDetails"].Rows[i].ItemArray.GetValue(2));
stone.Quantity = Convert.ToInt32(ds.Tables["ItemStoneDetails"].Rows[i].ItemArray.GetValue(7));
stone.Name = ds.Tables["ItemStoneDetails"].Rows[i].ItemArray.GetValue(1).ToString();
lt.Add(stone);
}

reportViewer1.LocalReport.ReportEmbeddedResource = "Report1.rdlc";


Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", lt);

reportViewer1.LocalReport.ReportEmbeddedResource = "Report1.rdlc";
Microsoft.Reporting.WinForms.ReportDataSource datasource = new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", lt);
Microsoft.Reporting.WinForms.ReportDataSource("DataSet2", dsBNCReportImagesData.Tables[0]);
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.DataSources.Add(datasource);


}
}
 
Share this answer
 
Comments
Deepu S Nair 29-Jan-15 0:47am    
This Question is more than 2 years old.

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900