Well, the answer may be out there but, I cannot find it. So, here is what I am doing...
I have MOSS 2007 on Windows Server 2003 R2 Enterprise with all the updates.
On my workstation I have Office 2007.
I created a site for the IT department which we use to track tickets, KB articles and the like. This is located at http://it/help
Now, I wanted to utilize the Reports site that comes with MOSS (http://it/Reports
) to create a dashboard and various reports. I figured I'd start with something simple to get my feet wet by, using data from the help site.
For the life of me, I cannot figure out how to get a connection from my tickets list into an excel sheet that will be stored in reports for the dashboard. More specifically, I am stuck at the first part, trying to get the data connection.
Any references or pointers would be appreciated. This day of searching has given me a headache. All I see is how to pull data from the excel file into the list, not the other way around.