SmpTraining
MIS
Has anyone used this in anger yet? I've dabbled with the feature but I don't think it will solve my requirements. any suggestions welcome.
Requirement:
My client wishes to Reporting from PeopleSoft tables using the 'tree' structures PS makes extensive use of. The trees provide a powerful, flexible structure to the underlying financial data.
The Financial data is held in simple ledger tables with an ID and all other relavent fields.
The "tree" tables contain an ID, and a parent ID. At the bottom of the tree structure (the 'child trees) link to a 'leaf' record that contains a series of account codes covered by the leaf.
E.g.
TREE Table:
ID ParentID LeafID
01
02 01
03 01
04 03 101
05 03 102
LEAF Table:
ID From To
101 900 900
102 920 950
Logical tree structure
01 (level1)
02 (level2)
03 (level2)
04 (level3) Account: 900
05 (level3) Accounts: 920 - 950
Given all the above, if I wanted to report on tree 01 I would like to see infomation about the ledger codes 900, 920-950 grouped and totalled by the various parent levels.
The introduction of Hierarchical Grouping has given me some hope that this report can be produced from within Crytsal but I'm not too sure.
Has anyone tried reporting from PeopleSoft TREE structures using Crystal? Anyone produced sophisticated Hierarchical reports? Sorry for the long question!
Thanks. Steve Phillips, Crystal Consultant
Requirement:
My client wishes to Reporting from PeopleSoft tables using the 'tree' structures PS makes extensive use of. The trees provide a powerful, flexible structure to the underlying financial data.
The Financial data is held in simple ledger tables with an ID and all other relavent fields.
The "tree" tables contain an ID, and a parent ID. At the bottom of the tree structure (the 'child trees) link to a 'leaf' record that contains a series of account codes covered by the leaf.
E.g.
TREE Table:
ID ParentID LeafID
01
02 01
03 01
04 03 101
05 03 102
LEAF Table:
ID From To
101 900 900
102 920 950
Logical tree structure
01 (level1)
02 (level2)
03 (level2)
04 (level3) Account: 900
05 (level3) Accounts: 920 - 950
Given all the above, if I wanted to report on tree 01 I would like to see infomation about the ledger codes 900, 920-950 grouped and totalled by the various parent levels.
The introduction of Hierarchical Grouping has given me some hope that this report can be produced from within Crytsal but I'm not too sure.
Has anyone tried reporting from PeopleSoft TREE structures using Crystal? Anyone produced sophisticated Hierarchical reports? Sorry for the long question!
Thanks. Steve Phillips, Crystal Consultant