Hi
We're using dynamic column sorting in telerik report. But every time we click on the sort button the report calls the data source. Is there a way to avoid it. This happens when we render the report in different format(csv, pdf) too.
Regards,
Majar
I have an Angular / Asp.Net Core web application. The report viewer component is working in the Angular application. Parameters are passed correctly. But when the report is loaded I get the error message in the viewer:
An error has occurred while processing Table 'crosstab1': Invalid key value.
The passed parameters values are displayed in textboxes so the report is loaded and rendered.
I guess it has something to do with the connection string that cannot be found.I created the report in the Report Designer application (so no class library/project which contains the reports) and the name of the connection string is "Reports" in the designer.
In the appsettings.json file I added an entry into the ConnectionStrings section with the name "Reports" (just as in the examples)
"ConnectionStrings": [
{"name": "Reports", "connectionString": "Data Source=.;Initial Catalog=DatabaseName;Integrated Security=True", "providerName": "System.Data.SqlClient" }
]
I also created an app.config file with the connection strings
<?
xml
version
=
"1.0"
encoding
=
"utf-8"
?>
<
configuration
>
<!-- To customize the asp.net core module uncomment and edit the following section.
For more info see https://go.microsoft.com/fwlink/?linkid=838655 -->
<!--
<
system.webServer
>
<
handlers
>
<
remove
name
=
"aspNetCore"
/>
<
add
name
=
"aspNetCore"
path
=
"*"
verb
=
"*"
modules
=
"AspNetCoreModule"
resourceType
=
"Unspecified"
/>
</
handlers
>
<
aspNetCore
processPath
=
"%LAUNCHER_PATH%"
arguments
=
"%LAUNCHER_ARGS%"
stdoutLogEnabled
=
"false"
stdoutLogFile
=
".\logs\stdout"
/>
</
system.webServer
>
-->
<
connectionStrings
>
<
add
name
=
"Reports"
connectionString
=
"Data Source=.;Initial Catalog=DatabaseName;Integrated Security=True"
providerName
=
"System.Data.SqlClient"
/>
</
connectionStrings
>
</
configuration
>
It seems that the Report Engine cannot find the connection string. Or does the Report Engine use another name for finding the connection string?
Hello Telerik Team
This is my Response
{
"Response": null,
"Response": null,
"Response": {
"Response": {
"Response": [
{
"Response": [
{
"Response": [
{
"Response": [
{
"Response": 35,
"Response": 2,
"Response": 2,
"Response": 31,
}
],
"Response": 5,
"Response": null,
"Response": "789",
},
],
"Response": 0,
"Response": null,
"Response": "45",
},
],
"Response": 9,
"Response": null,
"Response": "712",
},
],
"Response": "xyz",
"Response": "XYZ",
"Response": "XYZ",
"Response": "12",
"Response": "123",
}
}
}
Now i want to show this response in this design (My Design: Report should Look Like this)
I tried to design report using table but it looks like this (Actual Report: Report Created Using Table)
Also Tried with Crosstab but it was not looking good
i show your Demo Product Catalog ( https://demos.telerik.com/reporting/product-catalog?&skinName=default ) but it is just showing result it is not showing how can i do this.
I want to show my data same as you show in your demo.
also help me to show Icon as my design have (image: Report should Look Like this)
Hi,
I am generating report using Telerik Reporting v13.0
But facing some issue with sorting Crosstab.
Please find attached screens, where I have grouped Crosstab by "City" and wanted Sorting by "Name" ASC but that is not working
Grouped by City - Philadelphia (that is working)
But under this Group all record should sort by name
- CUP
- Globant
- Cognizant
Expected order should be Cognizant then CUP and then Globant , but that is not working
Thank you!
Prashant
How can I use the expression editor or some other means to assign a string to a numeric value. For example, I have status integer values that would show up in the legend of my chart but I want the proper string for those values. There are about 12 different status values with associated strings. How can I make this happen? I don't have a database table with the string values to join.
Thanks
I want telerik-reporting call angularjs
I've added the following libraries:Telerik.Reporting.dll,Telerik.Reporting.Services.WebApi.dll,Telerik.Reporting.XpsRendering.dll,Telerik.ReportViewer.Mvc.dll
file js:
$('#ReportViewer1').telerik_ReportViewer(
{
error: function (data) {
alert(data);
},
reportSource: {
report: '/Reports/Dashboard.trdx'
},
serviceUrl: '/api/reports/',
templateUrl: '/ReportViewer/templates/telerikReportViewerTemplate.html',
ready: function () {
this.refreshReport();
}
});
ReportsController:
protected override IReportResolver CreateReportResolver()
{
var reportsPath = HttpContext.Current.Server.MapPath("~/Reports");
return new ReportFileResolver(reportsPath)
.AddFallbackResolver(new ReportTypeResolver());
}
protected override ICache CreateCache()
{
return Telerik.Reporting.Services.Engine.CacheFactory.CreateFileCache();
}
Global.cs:
public static void RegisterGlobalFilters(GlobalFilterCollection filters)
{
filters.Add(new HandleErrorAttribute());
}
public static void RegisterRoutes(RouteCollection routes)
{
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.MapHttpRoute(
name: "DefaultApi",
routeTemplate: "api/{controller}/{id}",
defaults: new { id = RouteParameter.Optional }
);
}
protected override void Application_Start(object sender, EventArgs e)
{
IocManager.Instance.IocContainer.AddFacility<LoggingFacility>(f => f.UseLog4Net().WithConfig("log4net.config"));
ReportsControllerConfiguration.RegisterRoutes(GlobalConfiguration.Configuration);
base.Application_Start(sender, e);
}
but its not working
who can help me
thanks a lots.
I am new to Telerik reporting and trying to figure out how to create a line chart to display the data that is attached in the first attachment. I want the line chart to follow the data in the dataset. The second screen shot is how I have the report set up and the third screen shot is the designer preview once I complete the report setup. The fourth screen show is the preview button preview, which is obviously not correct either. I thought I had an understanding of how to do this but I guess I don't. Please help me understand how to set this up.
James Wallace
We have successful integrated Telerik Reporting into our product and this is running as expected at a number of client sites. However, the integration is failing at a single client site. Our solution uses the ReportViewer control which we've added to a basic .aspx page. As part of our investigation we removed all the code-behind, and established that it was the following tag that was preventing the page from loading.
<telerik:ReportViewer runat="server" ID="ReportViewer1"Width="100%" Height="700px" BorderStyle="None" > </telerik:ReportViewer>
The error message doesn't reveal anything other than an error has occurred.
The .aspx page exists within a SharePoint site, and we have confirmed that the<SafeControl> tags are correct, and that the Telerik DLLs are correctly present in the GAC. As part of the investigation we installed the Telerik Designer and ran the failing reports successfully in the designer, preview the clients data in the report.
I would guess there is some security setting in the browser that is preventing the ReportViewer control from loading. Is there any configuration or restrictions for this component? Are there any Telerik logs that may reveal what the error is?