Telerik Forums
Reporting Forum
0 answers
171 views

Hello Telerik Reporting Community,

We have released a new version of Telerik Reporting today, 2024 Q1 (18.0.24.130). Please update your existing installation at your earliest convenience.

You can review the Legacy Installer Vulnerability - Telerik Reporting article to learn more details about why we are recommending customers to update.

To get the new version, take the following steps:

  1. Go to Downloads | Your Account. 
  2. Select Telerik Reporting.
  3. Download the msi installer file, run it, and follow the steps to completion.


Notes

As the KB article explains, the issue pertained only to the old installer component, and not Telerik Reporting contained within the installation package. It does not affect any applications you’re using Telerik Reporting with.

If you have a rare situation where you cannot update the PC installed version, there are various ways to keep a project using an older version of reporting even though the PC has a newer version installed.

  • Copied Assemblies OptionCopy the older version’s DLLs to the project directory, then update the project references to use the copied assemblies (instead of the assemblies in C:/Program files (x86)/Progress/Telerik Reporting [older version]/)

We highly recommend you open a Technical Support Ticket if you have a complex situation and would like to ask questions before updating the PC’s installed version. You can open a Support Ticket here => https://prgress.co/DevToolsSupport.

Lance
Top achievements
Rank 2
 asked on 31 Jan 2024
2 answers
1.4K+ views

Hello Supports,


I want to try and install Nuget packages Telerik.Reporting.Services.AspNetCore for my Asp.net Core project but it isn't found.

when I go to the option "Manage Nuget packages", these are no available the packages to download (see the attached file).
Is it missing from the private nuget feed ?

Thank You.

 

Lance | Manager Technical Support
Telerik team
 updated answer on 31 Jan 2024
0 answers
5 views

I'm relatively new to the Standalone Report Designer, so I apologize if this is expected behavior. I'm connecting to Postgres and have everything set up correctly (AFAIK). If I open the .NET Report Designer via the EXE, the data connection initializes and I get data. However, if I click on a TRDP file to open the designer, the data connection doesn't initialize and I get an "Unable to establish a connection to the database" message with inner exception "Cannot load type for DbProviderTypeName "Npgsql.NpgsqlFactory". Why would opening the EXE directly be any different from opening via TRDP? This feels like a bug, but there may some documentation I just haven't made it to yet.

My current setup:

  • Standalone Report Designer v18.0.24.305
  • Npgsql v6.0.10
  • Npgsql.dll exists in the same directory as Telerik.ReportDesigner.Net.exe
  • Connection string and assembly reference added to Telerik.ReportDesigner.Net.dll.config
  • config file snippet:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <connectionStrings>
        <clear />
        <add name="Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString" connectionString="Data Source=No Local Servers Found!;Initial Catalog=AdventureWorks;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>
        <add name="{theName}" connectionString="{theConnectionString}" providerName="Npgsql" />
    </connectionStrings>
  
    <Telerik.Reporting>
        <AssemblyReferences>
            <add name="Npgsql" />
        </AssemblyReferences>
    </Telerik.Reporting>
</configuration>

1 answer
11 views

In https://docs.telerik.com/reporting/getting-started/first-steps-designing#step-2-create-the-sample-report in step 3, "Click Next to execute the query and the Execute Query... button on the next screen to preview the result. Then, click Finish." (selecting Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString), I get this error message:

Configure SQL Data Source - sqlDataSource1

An error has occurred.
Parameter information cannot be retrieved: Connection
Timeout Expired, The timeout period elapsed while
attempting to consume the pre-login handshake
acknowledgement, This could be because the pre-login
handshake failed or the server was unable to respond back in
time. The duration spent while attempting to connect to this
server was - [Pre-Login] initialization=15089;
handshake=7147;

I have the same problem when trying to create a new connection.

Turning off the Windows Defender firewall for private network and trying again:

Configure SQL Data Source - sqlDataSource3
An error has occurred.
Parameter information cannot be retrieved: Cannot open
database AdventureWorks• requested by the login. The login
failed.
Login failed for user 'xxx•.

Turning on the firewall again, and I still get "The login
failed"

See screenshots.

In the c:\Program Files (x86)\Progress\Telerik Reporting 2024 Q1\Examples\Data\AdventureWorks OLTP\ folder, there is an instawdb.sql that creates and populates the AdventureWorks db. There is no AdventureWorks db in my local SQL server installation. Should I/can I run this script manually?

Or am I doing something else wrong?

 

Todor
Telerik team
 answered on 17 Apr 2024
1 answer
10 views

I have round adhesive labels with a hole in the middle. I would like to design these labels using the report designer. To see the actual shape of my label, I use a background image in Designtime. This way I can place the text boxes around the hole.

How can I hide this background image when printing or previewing?

thanks

Thomas

Momchil
Telerik team
 answered on 17 Apr 2024
1 answer
17 views

Hello,

When attempting to run the following,

ng add @progress/telerik-angular-native-report-viewer

to our Angular 16 project, it's complaining about peer dependencies.

 

C:\dev\git-projects\my-app>ng add @progress/telerik-angular-native-report-viewer

i Using package manager: npm
‼ Unable to find compatible package. Using 'latest' tag.
‼ Package has unmet peer dependencies. Adding the package may not succeed.

 The package @progress/telerik-angular-native-report-viewer@21.24.305 will be installed and executed.
Would you like to proceed? Yes
npm ERR! code ERESOLVE
npm ERR! ERESOLVE unable to resolve dependency tree
npm ERR!
npm ERR! While resolving: ha...y@6.3.45
npm ERR! Found: @progress/kendo-angular-buttons@15.4.0
npm ERR! node_modules/@progress/kendo-angular-buttons
npm ERR!   @progress/kendo-angular-buttons@"^15.4.0" from the root project
npm ERR!
npm ERR! Could not resolve dependency:
npm ERR! peer @progress/kendo-angular-buttons@"14" from @progress/telerik-angular-native-report-viewer@21.24.305
npm ERR! node_modules/@progress/telerik-angular-native-report-viewer
npm ERR!   @progress/telerik-angular-native-report-viewer@"21.24.305" from the root project

----------------------

At first I upgraded kendo-angular-buttons from v15.0 to 15.4.0, but even so, I keep seeing this strange dependency on v14 - i.e. @progress/kendo-angular-buttons@"14" .

I'll post my package dependencies, if it may help:

"dependencies": {
    "@angular-devkit/schematics": "^16.2.12",
    "@angular/animations": "^16.2.12",
    "@angular/cdk": "^16.2.14",
    "@angular/common": "^16.2.12",
    "@angular/compiler": "^16.2.12",
    "@angular/core": "^16.2.12",
    "@angular/forms": "^16.2.12",
    "@angular/localize": "^16.2.12",
    "@angular/material": "^16.2.14",
    "@angular/material-moment-adapter": "^16.2.14",
    "@angular/platform-browser": "^16.2.12",
    "@angular/platform-browser-dynamic": "^16.2.12",
    "@angular/router": "^16.2.12",
    "@angular/service-worker": "^16.2.12",
    "@azure/msal-angular": "^3.0.13",
    "@azure/msal-browser": "^3.10.0",
    "@egjs/hammerjs": "^2.0.17",
    "@ngx-translate/core": "^14.0.0",
    "@ngx-translate/http-loader": "^7.0.0",
    "@okta/okta-angular": "^6.3.2",
    "@okta/okta-auth-js": "^7.5.1",
    "@progress/kendo-angular-buttons": "^15.4.0",
    "@progress/kendo-angular-common": "^15.4.0",
    "@progress/kendo-angular-dateinputs": "^15.4.0",
    "@progress/kendo-angular-dropdowns": "^15.4.0",
    "@progress/kendo-angular-excel-export": "^15.4.0",
    "@progress/kendo-angular-grid": "^15.4.0",
    "@progress/kendo-angular-inputs": "^15.4.0",
    "@progress/kendo-angular-intl": "^15.4.0",
    "@progress/kendo-angular-l10n": "^15.4.0",
    "@progress/kendo-angular-label": "^15.4.0",
    "@progress/kendo-angular-layout": "^15.4.0",
    "@progress/kendo-angular-pdf-export": "^15.4.0",
    "@progress/kendo-angular-popup": "^15.4.0",
    "@progress/kendo-angular-progressbar": "^15.4.0",
    "@progress/kendo-angular-ripple": "^15.4.0",
    "@progress/kendo-angular-treeview": "^15.4.0",
    "@progress/kendo-data-query": "^1.5.4",
    "@progress/kendo-drawing": "^1.9.1",
    "@progress/kendo-licensing": "^1.3.5",
    "@progress/kendo-theme-material": "^3.19.0",
    "ajv": "^6.11.0",
    "bootstrap": "^4.4.1",
    "classlist.js": "^1.1.20150312",
    "core-js": "^3.6.4",
    "css-element-queries": "^1.2.3",
    "d3": "^5.15.0",
    "dexie": "^3.2.4",
    "fast-deep-equal": "^3.1.1",
    "file-saver": "^2.0.2",
    "gl-matrix": "^3.1.0",
    "hammerjs": "^2.0.8",
    "http-status-codes": "^1.3.2",
    "js-base64": "^3.4.5",
    "keycharm": "^0.3.1",
    "ngx-bootstrap": "^11.0.2",
    "ngx-mqtt": "^16.1.0",
    "ngx-toastr": "^17.0.2",
    "npm-run-all": "^4.1.5",
    "popper.js": "^1.16.1",
    "ramda": "0.26.1",
    "rxjs": "^7.8.1",
    "tslib": "^2.0.0",
    "uri-js": "^4.4.1",
    "uuid": "^8.3.0",
    "vis-data": "^7.1.9",
    "vis-network": "^9.1.9",
    "vis-util": "^5.0.7",
    "vkbeautify": "^0.99.3",
    "zone.js": "~0.13.3"
  },
  "devDependencies": {
    "@angular-devkit/build-angular": "^16.2.12",
    "@angular/cli": "^16.2.12",
    "@angular/compiler-cli": "^16.2.12",
    "@angular/language-service": "^16.2.12",
    "@fortawesome/fontawesome-free": "^5.12.1",
    "@progress/kendo-angular-messages": "^1.56.0",
    "@types/d3-array": "^2.0.0",
    "@types/d3-axis": "^1.0.12",
    "@types/d3-brush": "^1.0.10",
    "@types/d3-color": "^1.2.2",
    "@types/d3-scale": "^2.1.1",
    "@types/d3-scale-chromatic": "^1.3.1",
    "@types/d3-selection": "^1.4.1",
    "@types/d3-shape": "^1.3.2",
    "@types/d3-time-format": "^2.1.1",
    "@types/d3-zoom": "^1.7.4",
    "@types/file-saver": "^2.0.1",
    "@types/gl-matrix": "^2.4.5",
    "@types/hammerjs": "^2.0.36",
    "@types/js-base64": "^2.3.1",
    "@types/node": "^18.16.20",
    "@types/ramda": "^0.26.41",
    "@types/vis": "^4.21.14",
    "prettier": "^1.19.1",
    "protractor": "~7.0.0",
    "roboto-fontface": "^0.10.0",
    "ts-node": "^8.6.2",
    "typescript": "~4.9.5"
  }

 

I've tried a few lower versions from npm but nothing works - i.e. https://www.npmjs.com/package/@progress/telerik-angular-native-report-viewer

FYI: I do have the std HTML5 Telerik Report Viewer working on another branch, along with the JQuery npm package - but I uninstalled both. And of course I did that in order to use your native Angular report viewer instead.

Thank you in advance,

Bob

Dimitar
Telerik team
 answered on 16 Apr 2024
0 answers
15 views

I was using the service in Framework 4.8 but migrating to .NET 8 and I'm trying to reference an assembly that uses some functions in the reports.
How do I reference?

he only place I found was this one but it doesn't work.

assemblyReferences Element Configuration - Telerik Reporting

Rudá Cunha
Top achievements
Rank 2
 asked on 15 Apr 2024
1 answer
20 views

Hi,

Maybe you want me refer Assign connection string dynamically using report parameter and bindings - Telerik Reporting .I followed the solution, it didn't work . And then I set the 'ConnectionString' to '@ReportParameters.PFDSConnectionString', it also didn't work, even if I add the '.Value'.Pls refer the error.png

But when I set the connection string to the property 'ConnectionString' , it worked. And I tested the parameter rendering, it's also OK. Pls refer the success.png.

I think the C# code is OK. Because when I use the appsetting.json file to injec the connection string.

Set ConnectionString to 'AcosReportsConnection', It's OK too. Pls refer the appsettings.png.

Because now the connection string come from database depending on different input parameters, I need to set the connection string dynamically.

Now I am very confused.

Do you have any suggestiones? Thanks.

 

1 answer
9 views

Hi there,

Does anyone have an idea why textboxes are not aligning properly in the preview mode?

Telerik Report Designer
Version: 17.2.23.1114
Target Framework: .NET Framework 4

Thank you.

Momchil
Telerik team
 answered on 12 Apr 2024
1 answer
16 views

Hey!

I have been using Telerik's Reporting and UI for MVC (version Q3 2018) for years without issues. I have just renewed my license and upgraded to the most recent release, both reporting and MVC. A lot has changed and lots of stuff got broken after the upgrade. I have been correcting it for the last weeks (it's a big project). 

But Telerik Reporting is giving me the most headaches. After the upgrade, all pages with reports stopped working. I had met every requirement, but  were still receiving "Cannot access the Reporting REST service. (serviceUrl = '/api/reports'). Make sure the service address is correct and enable CORS if needed. (https://enable-cors.org)".

I tested the endpoint '/api/reports/formats', and it failed with some internal errors. I then removed the section <Telerik.Reporting> from my Web.Config file and now it correctly returns a json it a bunch of formats.

Sadly, when I try to open a page with a report I still get "Canno/t access the Reporting REST service..." error. Looking in the browser's network tab I see a request to '/api/reports/version' with a 404 status. I tried opening it manually and got the same 404 error (please remember that /api/reports/formats is working fine!).

I've spent several hours trying to solve this issue but no luck. 

If it helps, here's what's being loaded on the HTML page:


       
    <link href="/Content/bootstrap.css" rel="stylesheet"/>
    <link rel="stylesheet" href="https://kendo.cdn.telerik.com/themes/7.2.0/classic/classic-silver.css" />
    <link rel="stylesheet" href="https://unpkg.com/@progress/kendo-font-icons/dist/index.css" />

    <script src="/Scripts/jquery-1.9.1.js"></script>
    <script src="https://unpkg.com/jszip/dist/jszip.min.js"></script>
    <script src="/Scripts/kendo/2024.1.130/pako_deflate.min.js"></script>
    <script src="/Scripts/kendo/2024.1.130/kendo.all.min.js"></script>
    <script src="/Scripts/kendo/2024.1.130/kendo.aspnetmvc.min.js"></script>
    <script src="/Scripts/kendo/2024.1.130/cultures/kendo.culture.pt-BR.min.js"></script>
    <script src="/Scripts/kendo/2024.1.130/messages/kendo.messages.pt-BR.min.js"></script>
    <script src="/Scripts/jquery.unobtrusive-ajax.min.js"></script>
    <script src="/Scripts/modernizr-2.5.3.js"></script>
    <script src="/Scripts/bootstrap.min.js"></script>
    <script src="/ReportViewer/js/telerikReportViewer.kendo-18.0.24.130.min.js"></script>
    <script src="/ReportViewer/js/telerikReportViewer-18.0.24.130.min.js"></script>
    <script src="/ReportViewer/js/localization.pt-BR.js"></script>

<script type="text/javascript">
    $(document).ready(function () {
        $("#reportViewer1")
            .telerik_ReportViewer({

                // The URL of the service which will serve reports.
                // The URL corresponds to the name of the controller class (ReportsController).
                // For more information on how to configure the service please check http://www.telerik.com/help/reporting/telerik-reporting-rest-conception.html.
                serviceUrl: "/api/reports",

                // The URL for custom report viewer template. The template can be edited -
                // new functionalities can be added and unneeded ones can be removed.
                // For more information please check http://www.telerik.com/help/reporting/html5-report-viewer-templates.html.
                //

                //ReportSource - report description
                reportSource: {
                    // The report can be set to a report file name (trdx report definition)
                    // or CLR type name (report class definition).
                    report: "Mantic.Core.Web.Reports.CancelledSales.CancelledSalesReport, Mantic.Core.Web.Reports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"
                },

                // Specifies whether the viewer is in interactive or print preview mode.
                // PRINT_PREVIEW - Displays the paginated report as if it is printed on paper. Interactivity is not enabled.
                // INTERACTIVE - Displays the report in its original width and height without paging. Additionally interactivity is enabled.
                viewMode: telerikReportViewer.ViewModes.PRINT_PREVIEW,

                // Sets the scale mode of the viewer.
                // Three modes exist currently:
                // FIT_PAGE - The whole report will fit on the page (will zoom in or out), regardless of its width and height.
                // FIT_PAGE_WIDTH - The report will be zoomed in or out so that the width of the screen and the width of the report match.
                // SPECIFIC - Uses the scale to zoom in and out the report.
                scaleMode: telerikReportViewer.ScaleModes.FIT_PAGE_WIDTH,

                // Zoom in and out the report using the scale
                // 1.0 is equal to 100%, i.e. the original size of the report
                scale: 1.0,

                ready: function () {
                    //this.refreshReport();
                },
            });

    });
</script>

And Here is my ReportsController:


namespace Mantic.Core.Web.Views.Report.Controllers
{
    using System.IO;
    using System.Web;
    using System.Web.Mvc;

    using Telerik.Reporting.Cache.File;
    using Telerik.Reporting.Services;
    using Telerik.Reporting.Services.WebApi;

    //The class name determines the service URL. 
    //ReportsController class name defines /api/report/ service URL.
    public class ReportsController : ReportsControllerBase
    {
        static ReportServiceConfiguration configurationInstance;

        static ReportsController()
        {
            //This is the folder that contains the report definitions
            //In this case this is the Reports folder
            var appPath = HttpContext.Current.Server.MapPath("~/");
            var reportsPath = Path.Combine(appPath, "Reports");

            //Add resolver for trdx/trdp report definitions, 
            //then add resolver for class report definitions as fallback resolver; 
            //finally create the resolver and use it in the ReportServiceConfiguration instance.
            var resolver = new ReportFileResolver(reportsPath)
                .AddFallbackResolver(new ReportTypeResolver());

            //Setup the ReportServiceConfiguration
            configurationInstance = new ReportServiceConfiguration
            {
                HostAppId = "Html5App",
                Storage = new FileStorage(),
                ReportResolver = resolver,
                // ReportSharingTimeout = 0,
                // ClientSessionTimeout = 15,
            };
        }

        public ReportsController()
        {
            //Initialize the service configuration
            this.ReportServiceConfiguration = configurationInstance;
        }
    }
}

PS: For upgrading UI for MVC, I've found a guide with breaking changes for each version (that had it) and it made the corrections easier, but I have not found one for the Telerik Reporting.

Todor
Telerik team
 answered on 12 Apr 2024
Top users last month
Dominik
Top achievements
Rank 1
Giuliano
Top achievements
Rank 1
Dominic
Top achievements
Rank 1
Glendys
Top achievements
Rank 1
NoobMaster
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?