1. Add .Rdlc Report in Project and Add one DataSet (Containing Image Field Name)
2. Add Header Section in RDLC Report
go to --> menu -->Report -->add Page Header and Page Footer
3. From ToolBox Drag and Drop Text Box in Body Section
example :- Add one text box Name Picture
Select textbox(Picture) go to property change
Value =Convert.ToBase64String(Fields!Picture.Value)
4. Now Display image in Header
use value of textbox(Picture)
5. Write Select Statement
using (SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["Connection"].ToString()))
{
cn.Open();
using (SqlCommand cmd = new SqlCommand("select Picture from tblImage", cn))
{
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
DataSet ds = new DataSet();
da.Fill(ds, "DataSet1_DataTable1");
ReportDataSource rds = new ReportDataSource("DataSet1_DataTable1", ds.Tables[0]);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.Refresh();
}
}
Display Image into RDLC HEADER
Same way You can Display Image in Footer Section.
Eiad DarPosted Mar 14, 2013, 8:58 AM
Thank You for this article, it's really helpful. but how about using multiple datasets which is the most usable case? can I write Like this code for instance?: Value=Convert.ToBase64String(First(Filed!Image1,"myDataSet")) -it's Not working! even it's logically right so what is the issue in this code I also tride to hide the image in converted textbox to base64string, then retrive it in image control as mentioned in MSDN technet in http://technet.microsoft.com/en-us/library/dd220421%28v=sql.105%29.aspx but no use! canyou help me best regards
Vijay KumarPosted Feb 10, 2012, 7:29 AM
I want to draw a line in rdlc whole page. but i dont becouse print data only one line. Please help.