Telerik Forums
Reporting Forum
1 answer
46 views

I have a report having 28 column to display with 13000 records with grouping applied on 3 fields which comes in 890 pages it takes around 2 mins to render.How to improve the performance of the report?

I am binding List<Generic Type> as report data source.

Dimitar
Telerik team
 answered on 06 Sep 2024
1 answer
48 views
1 answer
55 views

Hello Telerik,

I am following the Telerik Virtual Classroom course for Telerik Reporting.  At the end of the Hosting an API Endpoint section the teacher runs the app and sees the Report Viewer Container.   When I launch the app (without errors) I do not see this report container on the Reports.razor page.

Thank you for your assistance.

@page "/report"
@using Telerik.ReportViewer.Blazor

<style>
    .trv-report-viewer {
        width: 100%;
        height: 880px;
    }
</style>
Testing Outside of Div
<div class="dashboard">
    Testing inside of Div
    <ReportViewer ViewerId="rv1"
                  ServiceUrl="api/reports"
                  ReportSource="@(new ReportSourceOptions
                                  {
                                      Report = "rps_dashboard_report.trdp"
                                  })"
                  />

</div>


<link href="css/dashboard.css" rel="stylesheet" />

@code {

}

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 28 Aug 2024
2 answers
97 views

I'm using Q32024 (Trial) in a Blazor Server App, added after initial project creation (existing app, not using the "create Telerik app" wizard)

I have a VERY simple page with just a native report viewer (added via Add new Blazor Component -> Telerik Native Report Viewer Page) pointed to the SampleReport generated when adding this page.

When rendering the page, the report takes over 10s to show. (I'm able to provide a video of this). Any other report has the same issue, both with and without parameters. Subsequent loads are a little bit quicker, but still C5s

Looking in Output, it looks like it's attempting to repeatedly render the report - I have the following block repeated several times (Snipped for brevity, more available);

icrosoft.AspNetCore.Components.Server.Circuits.RemoteRenderer: Debug: Completing batch 32 without error in 32.2212ms.
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 154 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 155 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 156 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 157 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.SignalR.Internal.DefaultHubDispatcher: Trace: InvocationId (null): Sending result of type 'System.Void'.
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 158 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 159 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 160 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 161 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 162 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 163 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 164 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 165 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 166 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 167 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 168 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 169 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 170 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 171 of type Telerik.Blazor.Components.ToolBar.ToolBarToolsFactory
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 118 of type Telerik.Blazor.Components.Common.Popup
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 126 of type Telerik.Blazor.Components.ToolBarButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 127 of type Telerik.Blazor.Components.ToolBarButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 128 of type Telerik.Blazor.Components.ToolBarButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 129 of type Telerik.Blazor.Components.ToolBarButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 130 of type Telerik.Blazor.Components.ToolBarButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 131 of type Telerik.Blazor.Components.ToolBarButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 132 of type Telerik.Blazor.Components.ToolBarTemplateItem
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 133 of type Telerik.Blazor.Components.ToolBarButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 134 of type Telerik.Blazor.Components.ToolBarButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 135 of type Telerik.Blazor.Components.ToolBarToggleButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 136 of type Telerik.Blazor.Components.ToolBarButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 137 of type Telerik.Blazor.Components.ToolBarButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 138 of type Telerik.Blazor.Components.ToolBarButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 139 of type Telerik.Blazor.Components.ToolBarToggleButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 140 of type Telerik.Blazor.Components.ToolBarToggleButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 141 of type Telerik.Blazor.Components.ToolBarButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 142 of type Telerik.Blazor.Components.ToolBarButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 143 of type Telerik.Blazor.Components.ToolBarToggleButton
Microsoft.AspNetCore.Components.RenderTree.Renderer: Debug: Rendering component 144 of type Telerik.Blazor.Components.ToolBarToggleButton

Anyone have any ideas as to why it's doing this or why it's SO slow - as it stands it's unacceptable for me to use, but I'm happy for someone to point out where I may have gone wrong / something I may have missed....

<EDIT>

Looking at the code that's been added by the add item wizard, it's correctly (?) added the TelerikRootComponent to my main layout page, but I also needed to wrap the whole Viewer in ANOTHER root component otherwise I'm seeing an error that no root component is present.

Also, and not sure if this is significant, the Sample Report actually states that

"This is a sample report to demonstrate a working HTML5 Report Viewer and REST Reporting Service with XML report definition (trdx). The report definition is created with the Standalone Report Designer" - I understand that the Blazor native viewer is built on top of the HTML5 viewer, but this seemed odd (doubly since it wasn't actually created by the standalone designer but I guess that's the "original" source of the report!

I've also noticed that despite the fact I've set @bind-ParametersAreaVisble to a false value, it still shows (sample report has a date param), even though I'm specifying the parameter;

public ReportSourceOptions ReportSource { get; set; } = new ReportSourceOptions { Report = "sampleReport.trdp", Parameters = new Dictionary<string, object> 

    {"Date", DateTime.Today}
}};

I've also tried passing as a simple string in the format "12/08/2024" - interestingly, in both cases, the value I specify for the parameter is actually shown in the parameter editor

</EDIT>

Richard
Top achievements
Rank 1
Iron
Iron
 answered on 28 Aug 2024
1 answer
64 views
how to sum a column of a table and show the result in a separate text box?
Ivet
Telerik team
 answered on 26 Aug 2024
1 answer
71 views
Please see attached image.  I'm having trouble setting second level grouping across multiple fields/columns.

I'm successfully grouping on the facility.  However, I need to group (not repeat) the highlighted values. 

I'm able to do this be controlling the data to passed in to the report, but the result is just empty cells, so it looks like data is missing.

I need to achieve this through the report designer so the grid cell lines are not repeated for the second level grouping (like it does for the facility)?

How do I achieve this through the designer?  Step instructions please? 
Ivet
Telerik team
 answered on 20 Aug 2024
1 answer
116 views

I have installed the trial report. I tried with standalone report designer for a nested report. I need to filter the table data based on the parent Id of report detail section. Picture is given below.

The report dataSource is SqlDataSourceMain and Table DataSource is sqlDataSourceDetail

I do not want user input parameter for filtering. The report will be filterd based on the parent Id on the Report Detail Section.

I also need similar filter for Graph for each Site_id parent value.

 

I am looking forward to the solution asap.

Thanks

Zillur

 

 

 

 

Ivet
Telerik team
 answered on 19 Aug 2024
1 answer
125 views
I am using Telerik reporting using .NET as backend APIs and Angular for front-end report viewer.

Now I have updated the version on both side, and its working fine generally. 
But randomly I am getting this error of version mismatch while I try to generate report.

'The version of the Report Viewer '16.0.22.225' does not match the version of the Reporting REST Service '17.2.23.1114'. Please make sure both are running same version'

I know that the error statement suggests that the backend and frontend library versions don't match and must be aligned.
But the config I have updated works the majority time and successfully generates reports. But this error comes randomly.
So I am confused about how it is getting an older version of Report Viewer (16.0.22.225) even though I have updated the viewer configuration (^20.23.1010).

I have updated both side's versions below :

Server Side :

OLD:
 <PackageReference Include="Telerik.Reporting" Version="16.0.22.225" />
 <PackageReference Include="Telerik.Reporting.Services.AspNetCore" Version="16.0.22.225" />
 <PackageReference Include="Telerik.Reporting.WebServiceDataSource" Version="16.0.22.225" />

NEW:
 <PackageReference Include="Telerik.Reporting" Version="17.2.23.1114" />
 <PackageReference Include="Telerik.Reporting.Services.AspNetCore" Version="17.2.23.1114" />
 <PackageReference Include="Telerik.Reporting.WebServiceDataSource" Version="17.2.23.1114" />


Client side :

OLD:
"@progress/telerik-angular-report-viewer": "^15.22.225"

NEW:
"@progress/telerik-angular-report-viewer": "^20.23.1010"
Dimitar
Telerik team
 answered on 19 Aug 2024
1 answer
126 views

I'm working to transition rdlc reports from .net 4 to .net 6 with telerik reporting, and trying to reuse or convert as much of the old system as I can

I've got a report created in the standalone report designer with the dataset that matches the old report, and I've got the report service configured

I would like to populate my dataset through a service method based on parameters passed from a previous screen. The issue is that I cannot see a way to pass a populated data set through the front end of the HTML5 report viewer, and the documentation on the site for the Form_Load methods use a reportViewer1 variable that seems to be a Microsoft web forms reportviewer control that has no contemporary in .net core

I've looked into the NeedDataSource and ItemDataBinding events as well as using a service method to return the populated dataset as the Object Data Source, however I cannot create a service without passing parameters as the .net core dependency injection model directs, and that creates errors with the report designer attempting to dynamically generate the service

It seems like the only path forwards is to scrap the Object Data Source and try to rewrite all report logic as stored procedures. Am I missing something? Is there a way that I can pass a populated DataSet to the report to use as the data source? Is there any way I can pass a singleton service instance to return the populated dataset?

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 15 Aug 2024
16 answers
997 views
I have a multi-value parameter, @CountryID, that can also be set to null.  

I have a sql database query that uses this parameter like such:

"select * from Countries where CountryID is null or CountryID in (@CountryID)

Running the report, everything works as expected when I set the parameter value to NULL or to a single value.  However, if I set it equal to two or more values I get the following error:

An error has occurred while processing Table 'crosstab1': An expression of non-boolean type specified in a context where a condition is expected, near ','.

What am I missing?  How do I configure the parameter and/or adjust the query so that it works with NULL, single values and multiple values?

Thanks!
Jon
Top achievements
Rank 1
Iron
Iron
 updated answer on 14 Aug 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?