Telerik Forums
Reporting Forum
1 answer
38 views
I'm developing an ASP.NET report

My table header is obtained from the incoming data and is not fixed.
So I want to dynamically add Columns and put the content I specify, such as where the picture is circled

But no matter how I adjust it, I can't read my fields.

Even if I use static data for testing, it always tells me
"An error has occurred while processing Table 'table1':
Table Body has 3 rows but 1 are expected."

How should I write report code to achieve the results I want?

Attached is my code Hope you can help me answer it
Thank you very much
Dimitar
Telerik team
 answered on 18 Dec 2024
2 answers
44 views
I have a report created in the desktop designer with a single grouping that I have working correctly. However, I need to display results from a table on the last page of the report only. I cannot insert a table into the page footer that I can see, how can I achieve this? The group footer which allows a table prints at the bottom of every page. 
Ivet
Telerik team
 answered on 18 Dec 2024
1 answer
34 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
105 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
27 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
26 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
710 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
89 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
28 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
33 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.

Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?