So, by doing that the system will go out retrieve those additional values, and as you can see on the left hand side, it created a report tree. Now you have not only the total report but have now location 2, department 1 within location 2, department 2 within location 2, et cetera. Now, my buddy over in Atlanta took this report, and we’ve mentioned earlier how you can leverage reports and use them as a starting point for creating a new report.
So my buddy took this report and decided to expand on it and do something different and make it look better. So, what was done was to add more information to make this much more user friendly. Now it is a report that could be shared with everyone, and people could clearly understand the information that was being presented to them.
So, location 2 is not only location 2, but its called Grandwater, and location 3 is not just called location 3, it's called Memorial. So my buddy added these labels, and now you could see for Grandwater, here’s the total, and you can drill down using the tree, and look in and see what was sales department totals that roll up into Grandwater. What’s the finance department totals that roll up into Grandwater? What’s the corporate IT charges?
Now, you could send this to someone using this format, but again leveraging Excel you have our opportunity to do an output in Microsoft Office so you could do it in a PDF or choose the format you like. In this case the format that was selected was Excel. What your receive in Excel is the break out tree will be your first worksheet. You are getting a report book, and the report book will include all of these values.