Telerik Forums
Reporting Forum
1 answer
16 views
This started happening this afternoon in our production environment and we have not changed any code prior.  Everything was working fine.  It is unclear searching the forums and Internet what is causing and how to fix.  We are completely down.
Todor
Telerik team
 answered on 24 Apr 2024
1 answer
19 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
26 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
26 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
42 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
34 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
43 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
19 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
39 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
1 answer
17 views

Hello,

  1. We are using Telerik Reporting Q1 2015 SP1 version 9.0.15.324 in our .Net application and so it is installed in our development PCs too. Recently as agency standards, our PC was refreshed with new one. So we needed the Telerik Reporting installed in new PC. But as per new policy, before anything gets installed, the Admin team wants to know whether this version is currently supported by the manufacturer or not?. We do have plans to upgrade this to latest 2024 version, but before that we need the existing version to be installed in the new PC to start with the upgrade.
  2. Also Admin team mentioned there are vulnerabilities shown for Telerik Reporting version prior to 2014. Do we have any justification at this point on this.

Requesting to please let us know at the earliest.

 

Thanks

Fiyaz Ahmed

Todor
Telerik team
 answered on 12 Apr 2024
Top users last month
Patrick
Top achievements
Rank 1
Iron
Iron
Iron
MIS
Top achievements
Rank 1
Ross
Top achievements
Rank 1
Marcin
Top achievements
Rank 1
Iron
Iron
Sean
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?