Can Essential Calculate be used to compute values across a dataset?

I've read that Essential Calculate can perform calculations on data that is in a DataTable, but I'd really like to be able to perform calculations across a hierarchical structure of objects. This could a DataSet, or a graph of ADO.NET entity objects, or some custom objects that I roll on my own.

The idea is something like this. I have a graph of objects, similar to those below:

Account
(
AccountID,
Name,
OrderTotals
)

PurchaseOrder
(
OrderID,
AccountID,
OrderTotal
)

PurchaseOrderItem
(
OrderID,
ItemID,
ItemPrice
)

An account has multiple orders and orders have multiple items. What I want to do is use CalcEngine (or some other Essential Calculate object, CalcQuick?) to perform calculations across this hierarchical dataset.

Can this sort of thing be done? One idea I had was to create a CalcWorkbook and add sheets that represent the various levels of the object graph and then use calculations between the sheets. Just an idea.

Any other thoughts?

Hi Sean,

Please refer the following browser samples shipped with our products and let me know if this helps.


..\\My Documents\Syncfusion\EssentialStudio\{version}\Windows\Calculate.Windows\Samples\2.0\DataGridCalculator

..\\My Documents\Syncfusion\EssentialStudio\{version}\Windows\Calculate.Windows\Samples\2.0\GridDataBoundGridCalculator

..\\My Documents\Syncfusion\EssentialStudio\{version}\Windows\Calculate.Windows\Samples\2.0\TabbedPanelGrids

..\\My Documents\Syncfusion\EssentialStudio\{version}\Windows\Calculate.Windows\Samples\2.0\WorkingWithCalcQuick

..\\My Documents\Syncfusion\EssentialStudio\{version}\Windows\Calculate.Windows\Samples\2.0\XlsFileUsingExcelRW

Regards,
Jisha

Jisha,

Thanks for the links. I'll take a look at the samples and see if I can bend them to do what I need.

Regards,

Sean