I am trying to change report definition dynamically but unable to bind datasource. Could you please help me in binding the datasource dynamically. I amusing LinqtoSQL as datasource.
On click of a button, I am calling the constructor of my report and getting the report document and setting it to InstantReportSource's report document.I am serializing the report document to XML file and making modifying the report definition.After deserializing, how to bind the datasource before inputting the report to report viewer.Thanks
private void button6_Click(object sender, RoutedEventArgs e) { try { ReportViewerWindow rvw = new ReportViewerWindow(); Telerik.Reporting.InstanceReportSource instanceReportSource = new Telerik.Reporting.InstanceReportSource(); instanceReportSource.Parameters.Add("ParamDivisionId", null); instanceReportSource.Parameters.Add("ParamStartDate", new DateTime(2014, 1, 1)); instanceReportSource.Parameters.Add("ParamEndDate", new DateTime(2014, 2, 1).AddMinutes(-1)); instanceReportSource.ReportDocument = new DispatchAnywhere3.Reports.Report1(_user, _repository, _adminRepo); using (System.Xml.XmlWriter xmlWriter = System.Xml.XmlWriter.Create("C:/Temp/XML/ReportInside.xml")) { Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer(); xmlSerializer.Serialize(xmlWriter, instanceReportSource.ReportDocument); } using (System.Xml.XmlWriter xmlWriter = System.Xml.XmlWriter.Create("C:/Temp/XML/ReportInsideSecond.xml")) { XmlDocument document = new XmlDocument(); document.Load("C:/Temp/XML/ReportInside.xml"); XmlNodeList nodes = document.ChildNodes; foreach (XmlNode node in nodes) { if (node.Name == "Report") { XmlNodeList nodes1 = node.ChildNodes; foreach(XmlNode node2 in nodes1) { if (node2.Name == "Style") { node2.Attributes["BackgroundColor"].Value = "Red"; } } } } document.Save(xmlWriter); } Telerik.Reporting.Report report = null; using (System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create("C:/Temp/XML/ReportInsideSecond.xml")) { Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer(); report = xmlSerializer.Deserialize(xmlReader) as Telerik.Reporting.Report ; } rvw.ReportViewer1.ReportSource = new InstanceReportSource { ReportDocument = report }; rvw.ReportViewer1.RefreshReport(); rvw.Show(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "error", MessageBoxButton.OK, MessageBoxImage.Error); } }Hello,
I am evaluating a trial version of the Standalone Report Designer and have two reports I want to link via Drillthrough.
I believe I have followed the correct procedures to select the "interactive" field and set up the corresponding next steps:
Edit Action > Navigate To Report > Select Report Source > URL or File
Both of my reports are published to our telerik server in the same folder / category. However, when I key the URL in the source box, add proper parameters, and preview, I am receiving the following message:
"Unable to get report parameters.
An error has occurred.
'https://telerik.justfab.net/Report/View/LMS_DEV/Department_Overview_Report' report cannot be found."
This is a valid URL for the report I am trying to link to, but assuming from the error message there must be some other way to reference the URL for an existing report that already resides on our server. I tried adding .trdx extension with no success.
Please let me know the proper URL format to use when setting up simple Drillthrough connection between two reports residing on the same server.
Thank you!
I'm working on a calendar report that uses a daily sub-report for each day of the month.
The issue I'm running into is that with auto-scaling, each day scales differently based on the data for that day, meaning that the sub-reports are all displayed using different scales, and so don't lend themselves to side-by-side comparison.
It's impossible to know before run-time what the maximum scale for the entire month will be, so I can't hard set the axis scales either. Is there a way to 'pass in' the required scale to the sub-report along with the other parameters? I tried to put a formula in the CoordinateSystem.YAxis.Scale.Maximum property, but it seems to only accept a hard value and not a formula.
Hi,
In my WPF app, I have a report designed by default for A4 paper and I want to fit it to print on an A5 printer.
I have read threads on this forum about the ViewerPrintScaling (especially this one http://www.telerik.com/forums/dynamic-report-column-size#R757mvc1xkKirZXyJj7MBw) and I tried to used this option.
Here are the results :
- works fine when I generate a pdf file on disk using the ReportProcessor.RenderReport function, then print-it with right-click
- does not work in ReportWiewer (always printed in A4)
- does not work when directly printing using the ReportProcessor.PrintReport function (always printed in A4)
Am I missing something ? When I read the comment of Stef from Telerik Team, I understand that this option is always taken in account, either when rendering or when directly printing...
Thanks by advance for your help,
Aurélien

Hello,
I have a table that runs across multiple page in a report. What I would like to have is:
- at the beginning of the report, add a special row with an initial value.
- at the end of each page, when the table continues to the next page, have a total row of the items at this position.
- at the beginning of each page, when not at the start of the table, have a repetition of the total row of the previous page.
- at the end of the table, have a special total row, that is not the same as the total row for each page.
How can I do this with Telerik Resporting?
Hi all,
New user here (long term crystal user...so be nice please).
I am attempting to create a cross tab report and I am noticing a couple of things. First some background.
Local install of Microsoft SQL 2014.
Query in SQL runs in under 1 sec returning 5707 records.
Telerik is Q3 2015.
If I just put the fields on the report (no crosstab), the report is rendered in ~ 3 seconds (takes a few more seconds to get to 600 pages).
I remove all the data fields and start the CrossTab wizard. I have my Customers in as the rows, Year as the columns (limited to just 2015 via the SQL query) and the sales amounts in my summary field.
Here are my issues:
1. I have sat for 30 minutes and it never displayed a preview.
2. I run an SQL trace and see the exact same query hitting my server every few seconds. That query is the same query I used to build the report.
I am assuming as a new user to the system I have done something horribly wrong.