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
namespace ReportingTest2{ [System.ComponentModel.DataObject()] public class UrenSpecificatieDS : List<UrenSpecificatieItemObj> { [System.ComponentModel.DataObjectMethod(System.ComponentModel.DataObjectMethodType.Select)] public List<UrenSpecificatieItemObj> GetUrenBetweenDates(DateTime beginDate, DateTime endDate) { if (beginDate != null && endDate != null) { using (SPSite site = new SPSite("http://devserver")) { using (SPWeb web = site.OpenWeb()) { SPList spUrenSpecificatieList = web.Lists["HourRegistration"]; SPQuery query = new SPQuery(); query.Query = "<Query><Where><And><Geq>" + "<FieldRef Name=\"Date\" /><Value IncludeTimeValue=\"TRUE\" Type=\"DateTime\">2011-04-01T02:18:48Z</Value>" + "</Geq><Leq>" + "<FieldRef Name=\"Date\" /><Value IncludeTimeValue=\"TRUE\" Type=\"DateTime\">2011-04-24T02:18:50Z</Value>" + "</Leq></And></Where></Query>"; foreach (SPItem item in spUrenSpecificatieList.GetItems(query)) { UrenSpecificatieItemObj ur = new UrenSpecificatieItemObj(); ur._Date = getDateField(item, "Date"); string[] split = { ";#" }; ur.Company = getStringField(item, "Company").Split(split, StringSplitOptions.None)[1]; ur.Hours = getDecField(item, "Hours"); ur.Distance = getDecField(item, "Distance"); ur.Description = getStringField(item, "Title"); this.Add(ur); } } } return this; } return null; }// omitted the helper methods.}