private void assessmentsTable
_ItemDataBound(object sender, EventArgs e){ if (m_HasRecords) { Telerik.Reporting.Processing.Table tab = (Telerik.Reporting.Processing.Table)sender; Telerik.Reporting.Processing.ProcessingElement[] elems = tab.ChildElements.Find("textBox16", true); for (int i = 0; i < elems.Length; i++) { DataTable dt_assessments = GetAssessments(); Telerik.Reporting.Processing.TextBox assessmentID = (Telerik.Reporting.Processing.TextBox)tab.ChildElements.Find("textBox16", true).GetValue(i); Telerik.Reporting.Processing.SubReport rep1 = (Telerik.Reporting.Processing.SubReport)tab.ChildElements.Find("subReport1", true).GetValue(i); //Telerik.Reporting.SubReport rep2 = (Telerik.Reporting.SubReport)tab.ChildElements.Find("subReport2", true).GetValue(i); DataTable dt_photos = GetPhotos(); LoadPhotos(dt_photos, assessmentID.Value.ToString(), m_Counter++, table2.Height.Value + 10, rep1);private void LoadPhotos(DataTable dt_photos, string assessmentID, int i, float height, Telerik.Reporting.Processing.SubReport subReport1){ DataView dv = new DataView(dt_photos, "photoSourceID='" + assessmentID.ToString() + "'", "PhotoDateTime", DataViewRowState.CurrentRows); subReport1.Report.DataSource = new RMReports.AssessmentPhotos(dv, m_PhotoDirectory, m_EventID.ToString()); subReport1.Location = new PointU(new Unit(0.5, UnitType.Inch), new Unit(m_CurrentYLocation + height + 1, UnitType.Inch)); subReport1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(7.9999217987060547, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.900000274181366, Telerik.Reporting.Drawing.UnitType.Inch));}public AssessmentPhotos(DataView dt_photos, string photo_directory, string eventid){ /// <summary> /// Required for telerik Reporting designer support /// </summary> InitializeComponent(); // // TODO: Add any constructor code after InitializeComponent call // m_PhotoDirectory = photo_directory; m_EventID = eventid; LoadPhotos(dt_photos);}private void LoadPhotos(DataView dt_photos){ table2.DataSource = dt_photos;}ReportTemplate.DetailSection1.ColumnCount = 2
ReportTemplate.Width =
New Telerik.Reporting.Drawing.Unit(3, Telerik.Reporting.Drawing.UnitType.Inch)
ReportTemplate.DataSource = dtReportData
ReportViewer1.Report = ReportTemplate
ReportViewer1.RefreshReport()
THanks
Quan
Hello,
I need to be able to present a user with, say, a list of check boxes which represent individual reports. The user checks reports of interest and clicks "export" button. Then, in code behind, I need to be able to dynamically create the multiple selected reports and export each report into an individual Excel worksheet within a single workbook. The user is then prompted to save the workbook as a result of the browser detected content type.
I have seen an example of this export capability, but it was in conjunction with an existing Report Viewer control already on the page.
If this is not possible, I think my next solution might be to add Report Viewer control to page design time, then populate it with reports selected by user via the check boxes. Then, from Report Viewer export utility, create the multiple worksheet/single workbook file.
Thanks in advance for your time.
Jason