• Registered: 2016-07-28
  • Posts: 1,038

Topic: Multi running balance with tree

I have a tree and table grid for displaying running balance.


What I like to do and couldn't is that each tree items (nods) has their own running balance to display on one table grid.


For instance:
If I select the Main01 node on treeview, table grid should display only Main01  running balance with its transactions;
If I select the Child01 node on treeview, table grid should display only Child01 running balance with its transactions and so on.


Please see the attached sample project, which displays same running balance.

Post's attachments

Attachment icon Running Balance tView.zip 5.94 kb, 264 downloads since 2019-09-17 

Adam
God... please help me become the person my dog thinks I am.

2 Reply by derek (edited by derek 2019-09-17 17:30:42)

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,685

Re: Multi running balance with tree

Hi Adam,
Does this fix it for you? (see attached).
When I was doing a test, I found it was possible to create a transaction record with a null transactions.id_transtree so I stuck a line of script in to stop it happening (but you may be taking care of this elsewhere, in which case just delete it)
Derek.

Post's attachments

Attachment icon Running Balance tView.zip 339.31 kb, 334 downloads since 2019-09-17 

  • Registered: 2016-07-28
  • Posts: 1,038

Re: Multi running balance with tree

Hi Derek,
As always perfect solution.
Thank you very much........
Truly appreciated............

Adam
God... please help me become the person my dog thinks I am.