Telerik Forums
Reporting Forum
1 answer
25 views

Hello, we're in the process of migrating from Oracle Reports (since it's no longer supported) and are evaluating Telerik Reporting as a solution. After looking up the the Standalone editor and make a few POC reports, we have a few questions.

For reference :

  • we have ~700 reports that we will migrate over time. They all are "static" reports, meaning that we only want to produce a PDF that will be downloaded by the user at the click of a button.
  • we don't intend to use the Telerik Report Server solution.
  • we want our reports to consume a REST url to get the needed data (which will return a JSON). Which means we probably will have a REST url for each report.

Here are our questions :

  1. What's the difference between the .NET Framework and .NET 6 standalone executables ? Why use one or the other ? Are the report files (.TRDP/.TRDX) produced identical between the two ?
  2. When upgrading Telerik Reporting, we understand that we have to be careful about the version and it's changes. What about the report files ? Do we have to "upgrade" each and every one of them manually each time we upgrade Telerik Reporting ? With ~700 reports, it would be way too much time consuming.
  3. Our development workflow would be the following. Are there any catch we should be aware ? Is it feasible ? 
    1. Create a REST url for the new report
    2. Create the new report with the standalone editor and set it's datasource with the newly created REST url
    3. Push the report on a custom report server
    4. Implement the call to the report in our application

  4. Lastly, what's the best practice for the report versioning ? We'd like to use a GIT to store our report files and show diffs between each revision. I understand I would not be possible with a .TRDP since it's an archive, so should we save and store our report file as .TRDX to achieve this ?

Thanks a lot for your help !

1 answer
27 views

Hello again Dimitar,

If I may follow up with some follow-up questions re: our Angular 16 implementation of Report Viewer v18:

1) I need to add a default  'ALL' option to the combo_box dropdown values.

Would I need to do that in the backend report designer, or is it easy enough on the front end?

In the old v14 javaScript code, we had option 'ALL' directly coded into TelerikViewerv14.js, but I'd like to avoid that.

In the latest telerik-angular-report-viewer "^21.24.305" (not the native angular one), our HTML looks as follows:

<tr-viewer    
    [containerStyle]="viewerContainerStyle"
    [serviceUrl]="serviceUrl"
    [reportSource]="reportSource"
    [viewMode]="'INTERACTIVE'"
    [scaleMode]="'SPECIFIC'"
    [scale]="1.0"
    [templateUrl]="telerikTemplateUrl"
    [parameters]="{
        editors: {
            multiSelect: 'COMBO_BOX',
            singleSelect: 'COMBO_BOX'
        }
    }"
>
</tr-viewer>


import { Component } from "@angular/core";
import { AppConfigService } from "src/app/core/services/app-config.service";
import * as GG from "../core/models/globals";


@Component({
    selector: "app-statistics",
    templateUrl: "./statistics.component.html",
    styleUrls: ["./statistics.component.scss"],
})
export class StatisticsComponent {
    currentPatient: any;
    serviceUrl: string;
    reportSource: any;


    telerikTemplateUrl: string;
    viewerContainerStyle = {
        position: 'relative',
        width: '100%',
        height: '100%',
        ['font-family']: 'ms sans serif'
    };
    
    constructor(private readonly config: AppConfigService) {
        this.serviceUrl = this.config.host + GG.SV_REPORTS;
        this.telerikTemplateUrl = "assets/templates/telerikReportViewerTemplate-18.0.24.305.html";

        this.reportSource = {
            report: "SynReports.ReportCatalog, SynReports",
            parameters: {
                UserID: ...,
                SessionID: ...,
                RootUrl: "",                
            },
        };
    }
}
and we import from our stats.module.ts -
import { TelerikReportingModule } from '@progress/telerik-angular-report-viewer';

2) In the dropdowns, the list is bleeding into the datepicker below it. Would I need a specific version of kendo-theme-material package, for example, with telerik-report-viewer v21.24.305 ?

   In the meantime, I'm looking at overriding some classes coming from the backend css, which is linked in your template, telerikReportViewerTemplate-18.0.24.305.html - but no success in figureout out this div issue.

<link href="{service}resources/font/fonticons-18.0.24.305.css/" rel="stylesheet" />

Thanks,

Bob

Dimitar
Telerik team
 answered on 29 Apr 2024
1 answer
39 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
32 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
40 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
29 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
56 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
49 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
59 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
24 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
Top users last month
Michael
Top achievements
Rank 2
Iron
Wilfred
Top achievements
Rank 1
Alexander
Top achievements
Rank 2
Iron
Iron
Matthew
Top achievements
Rank 1
Iron
ibra
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?