Discussion:
TreeView Report
(too old to reply)
unknown
2009-04-29 20:00:30 UTC
Permalink
Is it possible to sum columns in a treeview report similar
to the way you could sum groups? For example: I have a
report that shows posted balances on TreeView Level 1.
TreeView Level 2 breaks down TreeView Level 1 and shows all
transactions that make up those posted balances. What I
want to do:

TreeView Level 1 - posted balance = $100
TreeView Level 2......postage - $50.00
TreeView Level 2......supplies - $50.00

TreeView Level 1 - posted balance - $200
TreeView Level 2......equipment - $100
TreeView Level 2......software - $100

Total TreeView Level 1: posted balance - $300

Is it possible to sum TreeViews? Nothing I tried has worked
and I can't find any documentation.

Thanks,
embartscher
Terry Dykstra [TeamSybase]
2009-04-29 22:24:39 UTC
Permalink
Definitely. It works exactly the same as a regular grouped report.
In the header for each treeview level add the desired sum functions.
In the summary add the sum for level 1.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by unknown
Is it possible to sum columns in a treeview report similar
to the way you could sum groups? For example: I have a
report that shows posted balances on TreeView Level 1.
TreeView Level 2 breaks down TreeView Level 1 and shows all
transactions that make up those posted balances. What I
TreeView Level 1 - posted balance = $100
TreeView Level 2......postage - $50.00
TreeView Level 2......supplies - $50.00
TreeView Level 1 - posted balance - $200
TreeView Level 2......equipment - $100
TreeView Level 2......software - $100
Total TreeView Level 1: posted balance - $300
Is it possible to sum TreeViews? Nothing I tried has worked
and I can't find any documentation.
Thanks,
embartscher
unknown
2009-04-30 03:19:08 UTC
Permalink
Thank you for responding.

In the header Treeview level 1, I have the column:
posted_balance
In the summary, I added the following computed field:
sum(posted_balance for level 1)
I get the following: Expression not valid

Can you tell what I am doing wrong?
Post by Terry Dykstra [TeamSybase]
Definitely. It works exactly the same as a regular
grouped report. In the header for each treeview level add
the desired sum functions. In the summary add the sum for
level 1.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement
possible to sum columns in a treeview report similar to
the way you could sum groups? For example: I have a
report that shows posted balances on TreeView Level 1.
TreeView Level 2 breaks down TreeView Level 1 and shows
all transactions that make up those posted balances.
TreeView Level 1 - posted balance = $100
TreeView Level 2......postage - $50.00
TreeView Level 2......supplies - $50.00
TreeView Level 1 - posted balance - $200
TreeView Level 2......equipment - $100
TreeView Level 2......software - $100
Total TreeView Level 1: posted balance - $300
Is it possible to sum TreeViews? Nothing I tried has
worked and I can't find any documentation.
Thanks,
embartscher
Terry Dykstra [TeamSybase]
2009-04-30 14:47:58 UTC
Permalink
sum(posted_balance for group 1)

A treeview is identical to a grouped report. It just looks differently, but
the same functionality applies.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by unknown
Thank you for responding.
posted_balance
sum(posted_balance for level 1)
I get the following: Expression not valid
Can you tell what I am doing wrong?
Post by Terry Dykstra [TeamSybase]
Definitely. It works exactly the same as a regular
grouped report. In the header for each treeview level add
the desired sum functions. In the summary add the sum for
level 1.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement
possible to sum columns in a treeview report similar to
the way you could sum groups? For example: I have a
report that shows posted balances on TreeView Level 1.
TreeView Level 2 breaks down TreeView Level 1 and shows
all transactions that make up those posted balances.
TreeView Level 1 - posted balance = $100
TreeView Level 2......postage - $50.00
TreeView Level 2......supplies - $50.00
TreeView Level 1 - posted balance - $200
TreeView Level 2......equipment - $100
TreeView Level 2......software - $100
Total TreeView Level 1: posted balance - $300
Is it possible to sum TreeViews? Nothing I tried has
worked and I can't find any documentation.
Thanks,
embartscher
unknown
2009-04-30 17:01:26 UTC
Permalink
Thanks! I hd tried that but it didn't work so knowing that
it should work....I played around with it and got it to work
on level 2 which accomplishes the same thing.

Thanks for your help!
Post by Terry Dykstra [TeamSybase]
sum(posted_balance for group 1)
A treeview is identical to a grouped report. It just
looks differently, but the same functionality applies.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement
for responding. >
Post by unknown
posted_balance
sum(posted_balance for level 1)
I get the following: Expression not valid
Can you tell what I am doing wrong?
Post by Terry Dykstra [TeamSybase]
Definitely. It works exactly the same as a regular
grouped report. In the header for each treeview level
add >> the desired sum functions. In the summary add the
sum for >> level 1.
Post by unknown
Post by Terry Dykstra [TeamSybase]
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by unknown
possible to sum columns in a treeview report similar
to >> > the way you could sum groups? For example: I
have a >> > report that shows posted balances on TreeView
Level 1. >> TreeView Level 2 breaks down TreeView Level 1
and shows >> > all transactions that make up those posted
Post by unknown
Post by Terry Dykstra [TeamSybase]
Post by unknown
TreeView Level 1 - posted balance = $100
TreeView Level 2......postage - $50.00
TreeView Level 2......supplies - $50.00
TreeView Level 1 - posted balance - $200
TreeView Level 2......equipment - $100
TreeView Level 2......software - $100
Total TreeView Level 1: posted balance - $300
Is it possible to sum TreeViews? Nothing I tried has
worked and I can't find any documentation.
Thanks,
embartscher
Loading...