I have an opportunity to build a report for my client that I would like to be 100% dynamic.
What I mean by that is, if the data in the database changes so with the display on the report.
Ok, so having said that let me explain what I want to do, and if you guys could help me come up with a plan to achieve it, that would be more than welcome.
So I have complete access to the database, so I could grab the data in a stored procedure or create a view to pull it from.
The report itself needs to display users, locations, and # of times a user logs on at a location for a given time period.
Basically I want to display multiple sets of results for a specific user at a specific location.
I saw the following link which looks similar but not exact and wondered if you could point me in a more specific direction. (the link: http://scn.sap.com/thread/3407344)
What I need is more :
Location 1 Location2 (etc...)
User1 1/2/4 2
Basically user1 shows up in location 1 in the months of Mar, Apr, May…1, 2, and 4 times, and shows up in Location2 just 2 times for the same period.
I need to be able to display the multiple results with out displaying user1 multiple times. Not to mention Locations may be added or deleted at any time as well as users.
So both the location Line and the user column need to be dynamic.
Thanks for any thoughts. If you could point me in the right direction, I would be grateful.