Telerik Forums
Reporting Forum
1 answer
168 views

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

Neli
Telerik team
 answered on 16 Apr 2019
3 answers
898 views

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.
  <!--
  <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?

Marcel
Top achievements
Rank 1
 answered on 16 Apr 2019
1 answer
246 views

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)

Todor
Telerik team
 answered on 15 Apr 2019
1 answer
367 views

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

 

Neli
Telerik team
 answered on 15 Apr 2019
19 answers
5.0K+ views
Hello,

I'm having trouble adding a new line to a textbox in a report. I'd like to have a textbox that displays up to 3 different fields on different lines. i"m setting the string "line 1 \r\n line 2 \r\n line 3" i tried a few different combinations. I would like to avoid putting it in the edit expressions if possible. I got it to work for the html side easy enough using <br> but the winform side is the one i'm having troubles with. I'm using Telerik Reporting Q1 2009 release.

Thanks much,
~Boots
Rod
Top achievements
Rank 1
 answered on 12 Apr 2019
1 answer
105 views
I have a WPF report and I don't know how to add a NeeDataSource to it. When I select the report (blue box in top left corner of designer) I see that there is a NeedDataSource setting in the properties box (the "lightning bolt" icon is selected), but when I click on the dropdown it is empty. Please advise how to add a NeedDataSource to it. Thank you. Jon
Jonathan
Top achievements
Rank 1
 answered on 12 Apr 2019
3 answers
826 views

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

Neli
Telerik team
 answered on 12 Apr 2019
3 answers
290 views

 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.

 

Todor
Telerik team
 answered on 12 Apr 2019
2 answers
282 views

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

James
Top achievements
Rank 1
Iron
 answered on 11 Apr 2019
3 answers
111 views

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?

Silviya
Telerik team
 answered on 11 Apr 2019
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?