Dim x As New DataTable
Dim dr As DataRow
x.Columns.Add(
"Col1")
x.Columns.Add(
"Col2")
dr = x.NewRow
dr(
"Col1") = "test1"
dr(
"Col2") = "test2"
x.Rows.Add(dr)
Dim g As New Report6
g.ObjectDataSource1.DataSource = x
ReportViewer11.Report = g
I have never really used data sets and tables before, generally everything is done using sql querys odbcdatareaders connected to grids and so forth.
Is this the best way forward, or am I missing something more basic or straight forward?
Shane
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