Telerik report designer - substraction of sub total from 2 tables

[n/a]

I have attached the Telerik report design SS, as I have used 2 tables Lease and credit, and from this, I want to subtract the subtotal between lease and credit and show it in the grand total. But I am stuck in that, I have tried lots of solutions but I am not achieving my result.
Please share your suggestions, it will be very helpful.

Thank you in advance.

[Todor]

Hi Danny,

In Telerik Reporting, each data item, for example, a table, has its own DataSource and can access only its data fields. The report items may access also their parent data scopes through the ReportItem.Parent.DataSource property - see How to use the ReportItem.DataObject property in expressions.

It is not possible though to access the data or report item values from one table to another table. For that reason, you need to use a workaround to achieve the requirement for making an aggregate from the two data sources.

For example, you may combine the DataSources and use the result data set to display its grand total.

Regards,
Todor
Progress Telerik