Telerik Forums
Reporting Forum
1 answer
41 views

A couple of questions regarding tables..

I know how to get a total for a column, but the row shows the cell grids for all columns in that "total" row. Table total row.jpg

Is there a way to suppress that and show text that says Total similar to something like in Preferred table total.jpg  It doesn't have to appear immediately below the row.

I also have a need to sometimes charge a sales tax so need something that looks like in Alternate table total.jpg.  This would be determined by a field that is in an "Invoice Header" data source.

I don't know how to reference the =Sum(Fields.ShiftTotal) from the table, outside the table

If the total row is a couple of separate boxes, I can then put the tax into a hidden box and display when required.

 

I guess an alternative would be to have the total in the Invoice Header data source rather than calculated from the Invoice Detail data source

Dimitar
Telerik team
 answered on 17 Dec 2024
2 answers
141 views

Hi,

I am using Telerik Reporting version 17.1.23.718 on an Ubuntu 22.04 VPS. Initially, I faced an issue where reports were not displayed in the viewer, but I resolved it by adding the System.Drawing.Common NuGet package to my project.

Currently, the Telerik Report Viewer displays the report correctly, including Arabic text rendered with the Times New Roman font. However, I am facing a problem with the exported PDF and the print preview:

  • The Arabic text does not display correctly in these outputs.
  • The font used in the report is Times New Roman, and I have installed it on the server.

I have attached screenshots to demonstrate the issue.

  • Attachment 1: Viewer displaying the report correctly.
  • Attachment 2: Incorrect rendering in PDF export and print preview.

Please advise on how to resolve this issue.

Arifullah
Top achievements
Rank 2
Iron
Iron
Iron
 answered on 14 Dec 2024
1 answer
32 views

I have the Angular Report Viewer configurated with the Authorization Token option, 

<ng-container>
  <tr-viewer
    [containerStyle]="viewerContainerStyle"
    [serviceUrl]="serviceUrl"
    [authenticationToken]="authenticationToken"
    [reportSource]="reportSource"
    [viewMode]="'INTERACTIVE'"
    [scaleMode]="'SPECIFIC'"
    [scale]="1.0"
    [parametersAreaVisible]="true">
  </tr-viewer>
</ng-container>

 

When I preview the report, it works fine, but when I export the report, the page is redirected to https://.../api/reports/clients/29647efbe45/instances/18eaf5b1936/documents/b86a87758c11f7b9cd832a?response-content-disposition=attachment and in this redirection is not including the authorization header

 

Thanks a lot, Ariel

Dimitar
Telerik team
 answered on 13 Dec 2024
1 answer
33 views

hello team, 

I have a report created in web designer and store the data in the database (binary). Now I want it to become sub report in my master report, I am using UriReportSource, then type the subreport name in the Uri text box, it does not work, it shows it could not find the subreport name, do we have any idea or solution to custom the path or load subreport here?

Thank u.

7 answers
728 views

I'm using the new Angular Report Viewer. My Component allows the user to change different parameters to generate the report. The first time the report runs, everything is fine. When a new set of parameters are selected, requesting the report still shows the report with the initial parameters.

In the prior version, I was able to get this to work by doing this in my ts file:

const v1 = $('#reportViewer1').data('telerik_ReportViewer');
v1.reportSource(requestedReportSource)
v1.refreshReport();

Where requestedReportSource contained the new report parameters.

In the new TelerikReportViewerComponent, I see there' a setReportSource() method, but I'm unable to get the right JSON parameter format to be passed to the method.

Any examples on how to update the ReportSource for the component would be appreciated.

Bob

 

 

Bhavika
Top achievements
Rank 2
Iron
Iron
Iron
 answered on 11 Dec 2024
1 answer
109 views

Hello folks,

I am working on an project that use a .NET 8 Web API as the backend and an Angular frontend to render telerik reports. Everything was working fine until we decided to upgrade Telerik.Reporting.Services.AspNetCore to version 18.3.24.1112

We also updated the following package in our frontend app. 

"@progress/telerik-angular-report-viewer": "^24.24.1112"

 

and updated the version from telerikReportViewerTemplate to match the version from our Reporting.Services package from the backend.

 <tr-viewer
    [containerStyle]="viewerContainerStyle"
    [serviceUrl]="noAuth ? openServiceUrl : telerikReportOptionParameters.serviceUrl"
    [authenticationToken]="noAuth ? null : telerikReportOptionParameters.authToken"
    [viewMode]="telerikReportOptionParameters.viewMode"
    [scaleMode]="telerikReportOptionParameters.scale"
    [scale]="1.0"
    [pageMode]="'SINGLE_PAGE'"
    [templateUrl]="
      (noAuth ? openServiceUrl : telerikReportOptionParameters.serviceUrl) +
      '/resources/templates/telerikReportViewerTemplate-18.3.24.1112.html'
    "
    [reportSource]="{ report: reportParams.trdxName, parameters: reportParams }"
    [exportBegin]="exportBegin.bind(thisComponent)"
    [exportEnd]="exportEnd.bind(thisComponent)"
    [printBegin]="printBegin.bind(thisComponent)"
    [printEnd]="printEnd.bind(thisComponent)"
    [renderingBegin]="renderingBegin.bind(thisComponent)"
    [renderingEnd]="renderingEnd.bind(thisComponent)"
    [pageReady]="pageReady.bind(thisComponent)"
  ></tr-viewer>

 

Now whenever we try to show any of our reports, we get the error: Could not find stored procedure 'sp_tr_GetInstancesByKey'

Our connection string hasn't changed and when I look at our database I can see these related stored procedures, but not the one mentioned in the error message.



Does anybody know what the problem might be?

Mila
Top achievements
Rank 1
Iron
 answered on 11 Dec 2024
1 answer
38 views

Hi,

When i create a table that has either conditional formatting to hide row visibility or uses Data > Bindings to hide row visibility it works well when exporting to PDF. 

When exporting to Powerpoint the rows that are supposed to be hidden do not show any data but there is still  blank space between the visible rows.

Is there a work around for this or is this a bug?

 

Thanks

Steve

Ivet
Telerik team
 answered on 10 Dec 2024
1 answer
53 views

This is basically a repeat of what other users have asked:

https://www.telerik.com/forums/any-way-to-prevent-auto-loading-when-parameters-are-present

https://www.telerik.com/forums/how-to-disable-report-auto-preview

https://www.telerik.com/forums/how-prevent-report-from-running-on-page-load

The gist of the Telerik team's recommendation is to not provide default values for parameters.

In addition to the rebuttal by the developers (generally speaking, they want to provide default or suggested values to end-users), we have a slightly more generic case. We have users running reports that span months of data. In most cases we have start and end date parameters. The users will sometimes want to see the data from current month AND THEN switch to same month of last year.

They select the start date and the report immediately executes spanning 13 months. The user has to wait until the report is loaded completely to immediately discard the result by setting the end date.

Adding the "AutoRun=false" option would be immensely useful here. Or at least wait for e.g. 5 seconds of user inactivity before executing the report.

1 answer
38 views

Hello everyone,

I'm facing an issue with creating diagrams using reporting. Could you please advise me on how to create a diagram from a web reporting designer?

I deeply appreciate any advice or solutions you can offer. Thank you!

1 answer
42 views
I have designed a report in the standalone designer which needs to display numbers, letters and special characters (<,>) in table cells. It displays the letters and numbers but not the < or >. It shows &lt; rather than <. How can I format the cells to show all of the characters?
Toya
Top achievements
Rank 1
Iron
Iron
 answered on 06 Dec 2024
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?