We use the Report Designer to design a report that we want to access through the browser.
Does the Telerik Report service support Linux installation? What if I could include a link in my reply?
Here is my expression...
= IIF(ReportItem.Parent.DataObject.SoldtoAddress.CustKey = "ADEEL", "M3","") + Fields.RollID
As-is, the expression works. But, if the expression is false and I put anything in the empty quotes, the report won't run and gives the error, "Object reference not set to an instance of an object."
Am I doing something wrong? Thanks!
Ok - pulled my hair out for a couple of days testing out the telerik reporting - the report works as expected, but I am trying to get report viewer object and update the parameters from some bootstrap controls, but just get the following:
Uncaught TypeError: viewer.reportSource is not a function
at HTMLButtonElement.<anonymous> (ReportViewer?type=4:37)
at HTMLButtonElement.dispatch (jquery-3.6.0.min.js:2)
at HTMLButtonElement.v.handle (jquery-3.6.0.min.js:2)
I have hardcoded the parameters to try and test - what I have in the page so far is as follows (using MVC).
It looks like jQuery cant find the report viewer by its id - some help would be appreciated here please and yes the code is quick and dirty :)
@model Platform.Code.ReportParamters
@{
Layout = null;
}
@{
TypeReportSource typeReportSource = Model.ParamReportSource;
typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("YardID", Model.ParamYardID));
typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("StartDate", Model.ParamStartDate));
typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("EndDate", Model.ParamEndDate));
typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("MovementCategoryID", Model.ParamMovementCategory));
typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("Username", Model.ParamUsername));
}
<link href="https://kendo.cdn.telerik.com/2018.2.620/styles/kendo.common.min.css" rel="stylesheet" />
<link href="https://kendo.cdn.telerik.com/2018.2.620/styles/kendo.blueopal.min.css" rel="stylesheet" />
<script src="~/Scripts/jquery-3.6.0.min.js"></script>
<script src="@Url.Content("~/api/reports/resources/js/telerikReportViewer")"></script>
<div class="row">
<button type="button" id="updateReport" class="btn btn-primary">Primary</button>
</div>
@(
Html.TelerikReporting().ReportViewer()
.Id("reportViewer")
.ServiceUrl("/api/reports/")
.ReportSource(typeReportSource)
.ViewMode(ViewMode.Interactive)
.ScaleMode(ScaleMode.Specific)
.Scale(1.0)
)
<script>
$(document).ready(function () {
$('#updateReport').on('click', function () {
var viewer = $('#reportViewer').data('telerik_ReportViewer');
viewer.reportSource({
report: viewer.reportSource().report,
parameters: {
YardID: 1,
StartDate: '2020-06-21T00:00:01',
EndDate: '2021-06-21T23:59:59',
MovementCategoryID: 3,
Username: 'David Smith'
}
});
//setting the HTML5 Viewer's reportSource, causes a refresh automatically
//if you need to force a refresh for other case, use:
//viewer.refreshReport();
});
});
</script>
Hai Telerik Team,
I was testing , the integration of Telerik Reporting in my asp.net Core application.But when i load report from my html page , it shows an error , related to connection string not get properly , the error message is that
An error occurred while loading the data schema for "sqlDataSource1": Unable to establish a connection to the database. Please verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.
Report is loading from designer , using same connection string.When i try to integrate telerik example reports, system shows same error message.
please give me your suggestion to how fixt this issue
I want to set up a conditional format to hide an image if the byte array count < 2. I cannot figure out how to simply deal with collections such as arrays and get a count.
I've tried this, but my report won't preview in the designer:
= Count(=Fields.[Logo])
How do I achieve this?
Thanks in advance.
Goal: Change a trdx's web services data sources from using web service requests to using inline data strings and then render a PDF.
The trdx was created using the Invoice Report Wizard and has two data sources (one for header and one for detail). Both actually call the same web service method but use different data selectors ($.result and $.result.MemberReceiptDetails). I need to replace these calls with inline json strings (again, they'll be identical) and remove the parameters. I see the Report class has a DataSource property but how does this relate to multiple datasources?.
XmlReportSource reportSource = new XmlReportSource();
Report report = GetReportFromResources("Member.DuesReceipt.trdx");
//Change data sources here
StringBuilder builder = new StringBuilder();
using (System.Xml.XmlWriter xmlWriter = System.Xml.XmlWriter.Create(builder))
{
Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer =
new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();
xmlSerializer.Serialize(xmlWriter, report);
}
reportSource.Xml = builder.ToString();
var reportProcessor = new ReportProcessor();
RenderingResult result = reportProcessor.RenderReport("PDF", reportSource, null);
Please refer the snapshot attached.
The telerikReportViewer.js file is not loading properly. I checked the path, its linked correctly (Refer Snapshot : telerikReportViewer1.png)
But still my reports are not loading properly.
It looks like its not about the file path, something else seems to be causing this error.
Please help.
Hello,
I am trying to view a working example of the tr-report viewer, but it does not appear the rest api for the example angular report viewer is working. This is what happens when I run the example application using this serviceUrl: https://demos.telerik.com/reporting/api/reports/
Goal: I want to create a .NET Standard class library with trdx reports so that I can deploy it with projects on various platforms.
I added a trdx file to the new library and made it an embedded resource but could not access it. I then stepped back, simplified, and added the report to a .NET Framework 4.7 Windows Forms app, again as an embedded resource.
public Form1()
{
InitializeComponent();
var a = System.Reflection.Assembly
.GetExecutingAssembly()
.GetManifestResourceStream("Reports.Report1.trdx");
TypeReportSource reportSource = new TypeReportSource();
reportSource.TypeName = "Reports.Report1.trdx";
var reportProcessor = new ReportProcessor();
RenderingResult result = reportProcessor.RenderReport("PDF", reportSource, null);
}
a is populated (as a check) but rendering results in: {"Invalid report type"}