Display Last Level of Hierarchy of a node
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22243
Printed Date: 27 Apr 2024 at 6:06pm
Topic: Display Last Level of Hierarchy of a node
Posted By: TheWatt
Subject: Display Last Level of Hierarchy of a node
Date Posted: 20 Feb 2017 at 6:12am
Dear All,
my report(balance sheet) have a hierarchical structure.
The level of hierarchy differs depending on the node.
e.g
Commercials balance
Asset
fixed capital
xxx
bbb
current capital
aaa
ggg
fff
ccc
Initially i hide HierarchyLevel(GroupingLevel)>3
I have two groups(A and B)
Group B(Group per year/Period) show on drill down only.
My objective is that when i drill down from Group B, i showthe last level of the node
e.g show ggg if it is the last level of the node current asset
Is there a formular to help me identify the last level of a hierarchy?
Thanks in advance
|
Replies:
Posted By: lockwelle
Date Posted: 24 Mar 2017 at 6:55am
you could, maybe, as I not sure what you trying to accomplish.
This is my idea at least;
in the correct group header put a reset like:
shared stringvar lastGroup := "";
in each group header after that put something like
shared stringvar lastGroup := "thisGroup";
then in the appropriate group footer, report back the value:
share stringvar lastGroup
you might need to put some logic into the assignment formula like
if not isnull({table.column}) then lastGroup := "this group";
HTH
|
|