how to sum a column of a table and show the result in a separate text box?

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? 

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

 

 

 

 

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"

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?

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!

Hello Telerik,

Please see the below 2 errors and 3 screenshots.   Thank you in advance for your assistance.

When I try to install Telerik.Reporting.Services.AspNetCore.Trial.18.1.24.709 I get the below errors.

 

When I try to install Telerik.UI.for.Blazor.Trial.6.1.0.nupkg  I get the below errors

 

 

This is the screenshot from the Virtual Classroom for Telerik Reporting.

Hi，

I want to pass parameters to the report so that the font size in the Style of the report can be set according to the content of the parameters. For example, if the parameter ReportFontSize=9, then the font size of the content in the Label control and Table control in the report will be 9pt. Is there a way to achieve this currently?

Hi 

I wanted to setup Telerik report in on of my asp.net web from application i am getting issue in-order to setup this please help me.

Hi , we are reading some worksheet data using  Telerik.Web.Spreadsheet and most of the time it works fine but  also few times it fails and gives us the following error messsage 

Not supported to value: /xl/worksheets/sheet1.xml'  I have 2 examples one works fine and other is not. can you please guide us why one file is failing and other is not?

 

Kind Regards