April 9, 2010 at 5:54 am
Hi *,
I have to create a report about our users and their departments.
The problem I have is the structure of the departments.
I have only a string with the department name and no parent-child-values.
Imagine this table:
Department, Name, Account
I need a drilldown for the department split by " " as long it can be splitted, for example
"AB C DE FG" would be AB -> CDE -> FG
"AB C" would be AB -> C
I would like to have the subtotals so I can see that the department "AB C DE FG" has 4 accounts but the department "AB C" have 35 accounts in sum.
How can I do this splitting with the drilldown?
I hope you can help me!
Thanks!
April 19, 2010 at 8:04 am
Looks like you would be best doing this in SQL first, before it gets into your dataset in the report.
April 19, 2010 at 10:53 am
I've done this with a parent-child hierarchy. I have splitted the department string and built a hierarchical table with it. Thanks for your help!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply