private void detail_ItemDataBound(object sender, EventArgs e){ Telerik.Reporting.Processing.DetailSection detail = (Telerik.Reporting.Processing.DetailSection)sender; Telerik.Reporting.Processing.TextBox txtHierarchicalEntityID = (Telerik.Reporting.Processing.TextBox)detail.ChildElements.Find("txtHierarchicalEntityID", true)[0]; Telerik.Reporting.Processing.Table tblReport = (Telerik.Reporting.Processing.Table)detail.ChildElements.Find("tblReport", true)[0]; int hierarchicalEntityID = Convert.ToInt32(txtHierarchicalEntityID.Text); dsReporting dsBindingData = new dsReporting(); foreach (dsReporting.AssessmentResultsChartRow currRow in dsRaw.AssessmentResultsChart.Rows) if ((int)currRow["HierarchicalEntityID"] == hierarchicalEntityID) dsBindingData.AssessmentResultsChart.ImportRow(currRow); dsBindingData.AcceptChanges(); tblReport.DataSource = dsBindingData.AssessmentResultsChart;}private void chart1_NeedDataSource(object sender, EventArgs e) { Telerik.Reporting.Processing.Chart procChart = sender as Telerik.Reporting.Processing.Chart; string sql = @"SELECT COUNT(l.[LookupID]) as 'AUSStatusCnt',l.[ClientLookupValue] as 'AUSStatus' FROM [AUS] a INNER JOIN [Organization] o ON a.[OrganizationID]=o.[OrganizationID] INNER JOIN [Lookup] l ON l.[LookupID] = a.[AUSStatusID] where a.[AUSID] in ([dbo].[udf_GetLastAUSStatus](a.[AUSParentID])) AND a.[OrganizationID]=@OrganizationID AND l.[LookupTypeID]=13 and l.[Active]=1 AND a.[UpdatedByDate] >= DATEADD(d,-90,GETDATE()) GROUP BY l.ClientLookupValue,l.LookupID"; SqlConnection sqlCnn = new SqlConnection(); sqlCnn.ConnectionString = ConfigurationManager.ConnectionStrings["appConnString"].ConnectionString; try { DataSet ds = new DataSet(); SqlCommand sqlCmd = new SqlCommand(sql,sqlCnn); sqlCmd.Parameters.Add("@OrganizationID",SqlDbType.Int); sqlCmd.Parameters["@OrganizationID"].Value = int.Parse(Report.ReportParameters["OrganizationID"].Value.ToString()); SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd); adapter.Fill(ds); procChart.DataSource = ds; chart1.Series[0].DataLabelsColumn = "AUSStatusCnt"; chart1.Series[0].DataYColumn = "AUSStatusCnt"; chart1.Legend.Visible = false; chart1.PlotArea.XAxis.DataLabelsColumn = "AUSStatus"; chart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 0; chart1.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Color = System.Drawing.Color.DarkSlateBlue; chart1.PlotArea.Appearance.Dimensions.Margins.Bottom = Telerik.Reporting.Charting.Styles.Unit.Percentage(20); chart1.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Font = new System.Drawing.Font("Arial", 10,FontStyle.Bold); adapter.Dispose(); sqlCmd.Dispose(); sqlCnn.Close(); } catch (Exception ex) { MessageBox.Show("Error loading report! "); } }Friend I have query in Drillthrough Report I have two report Rone and Rtwo , I add report two as Drillthrough Report so when we open Rone we can go at Rtwo.
Now I want to know how I can come back again , when it open Drillthrough Report , Rtwo , how I can come back again on previous report , Rone.
I hope my question is clear.
Thanks
I'm wokring on an application for a client that wants some high res print media PDFs generated. I am trying to use telerik reports for this.
I have all my elements added to the report using cm so the elements will all fit correctly on the page. However when adding the images i have into picture boxes, I have them exported based on 300 dpi, and telerik reports seems to default to 96 dpi, so they do not fit in the designer. If i reduce them to 96 dpi the do fit but come of rat shit on the PDF and when printed (and yes i have read this article http://blogs.telerik.com/blogs/posts/09-01-07/the_strange_case_of_adobe_acrobat_or_why_do_images_in_telerik_reports_get_fuzzy_when_exported_to_pdf.aspx).
Can someone please tell me how to specific the pixels per inch/cm for telerik reports?
Thanks,
Joel