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

[Administrator]

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?

[Jisha Joy]

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

[Administrator]

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