Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
80
Grandtotal on a child summary?
posted

I have a hierarchical grid with a parent and 2 children and I have got summaries showing on some fields in one of the children.

Something like this:

Contract

---Invoices

---Estimates

Each of them is bound to a datatable in a dataset.  In the Estimates child I'm showing a quantity column which gets summed for the lines for that contract and that summary works.

Is it possible to show grandtotals for a child column across all the parents?  In my case I need to sum the quantity column for all the Contracts.

If it's not do-able with what's built into the grid and it's members, can I get there by maybe adding an unbound column to the parent that has a formula that sums it's children and then summarize that parent column?

Worst case, I can add textboxes to the form to show a sum from the child datatable but I'd rather not do that...

 

Another question that I have related to this same grid is: can I collapse just one of the children?  Keep showing the Estimates but collapse the Invoices?  Since there is just a + up at the Contract which collapses both children, I'm guessing not.  I've found I can toggle the Band's Hidden property and that doesn't seem cause any problems and it seems fairly quick: If the answer to my question about collapsing is No, are there any problems with toggling the the Hidden property that make it a bad idea?

Thanks,

Andy