Looking for Report development suggestions

[bcla]

Hello all,  

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                                                            

                                                        User2                                    

                                                        User3 (etc...)

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.

[JWiseman · Accepted solution]

hi BL,

the easiest way to do this is to Insert a Cross-tab.

1) in the Cross-tab Expert, drag your location field into the Columns dialogue and then the Date field into the Columns dialogue.

2) click on the Date field in the Columns dialogue and then change the Group Options to For Each Month in the "Column will be printed" select menu

3) drag your user field into the Rows dialogue

4) drag the field that you are using for the count (1/2/4) into the Summarized Fields dialogue and ensure that the summary type is Count

5) in the Customize Style tab there are a lot of options such as suppressing the Subtotal for the 2nd Column field, moving the Totals, getting rid of the cell margins, hiding the lines, etc.

this method would change the columns and rows  based on the data coming in so no stored proc required.

-jamie

[bcla · Accepted solution]

Thanks Jamie, this has me headed in the right direction.

I just need to finalize the summary section. Thanks, B