I want to be able to save report parameters the user has chosen and save them. Later the user can select the saved report and I'll run the report and fill in the (many) parameters at run-time. I came across this post written almost 2 years ago:

http://www.telerik.com/community/forums/reporting/telerik-reporting/saving-report-criteria.aspx#1736100

Does the Telerik Report Viewer expose an event or object which would allow me to grab these values? The only workaround I could see was to grab the data from the drop downs themselves. Using jQuery I wrote this as a simple test on a button click:

    $("iframe[id$='ParametersArea']").contents().find("select").each(function (index) {
        alert(  $(this).val() + " | disabled: " +  $(this).is(':disabled') + " | id: " + this.id);
    });

The only other option is to build my own Parameter sections from scratch (20 reports with up to 8 parameters each, oh joy).

Please let me know if anything has changed in the past to years in this regard,

Thank you

My report pulls 6 months, on the first to the last day for each month, of data from the past using a data picker and will use all 6 for one of the graphs, but I also want to use only the last full month of data for all of the rest of the graphs so I need to filter the 6 months to get that data.  I am trying to filter only the data for the last month using the date from the parameter but for this I will need the date parts because I want from the first day of the month to the last day of the month.  Can someone please give me an idea how I can do this?

ie.

Date Picker chooses 3/5/2019 meaning getting data for all days in each month of Oct, Nov, Dec, Jan, Feb, Mar

One report uses all 6 months

All other reports use only data from March

Any help would be greatly appreciated.

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)

 

I also created an app.config file with the connection strings

 

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

 

Hello,

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

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.