Change Picturebox Value from XmlReportSource at runtime

[Joao]

Hi,

I need to modify, when loading, a picturebox value from a report generated in TRDX and kept in a DB.

I know that's maybe because my knowlage is limitated... but after several tries and too many hours searching I can't find the correct way. Anyone can help??

I'm develloping in asp.net webforms, c#, VS2013.

Here'a a code snippet of my question:

 

XmlReportSource mapa = new XmlReportSource();
string xml = dal.LeMapa(connection, Session["Report"].ToString());
mapa.Xml = xml.Replace("DBDev",connection);
mapa.Parameters.Add("Sigla", Session["Sigla"].ToString());
ReportViewer.ReportSource = mapa;

XmlReportSource instanceReportSource = (XmlReportSource)this.ReportViewer.ReportSource;
Report report = (Report)instanceReportSource.ToString();
PictureBox img = report.Items.Find("logo", true)[0] as PictureBox;
DataTable dt = dal.LeLogoEmpresa(Connection);
if (dt.Rows.Count > 0)
    foreach (DataRow dr in dt.Rows)
    {
        img.Value = dr["Logotipo"];
        img.MimeType = dr["ImgTip"].ToString();
        break;
}

How canI find the picturebox??

Thanks.

[Joao]

It's more easy to modify the report markup before linking it as a reportsource. It's done!

Thanks anyway.

[Stef]

Hi Joao,

Modifying the XML is valid approach, where you will have to check if the XML structure is the same on upgrade.
The recommended approach is to use an expression as PictureBox.Value.

• The expression can contain a string report parameter that points the image's file path. Then you can pass the path to the image through the XmlReportSource.Parameters collection that maps values to the report's ReportParameters collection by key;
• The expression can be a user function that gets the required image when the report is processed (Previewing a report definition that uses an external assembly).

I hope this helps.

Regards,
Stef
Telerik by Progress