Hi,
I have been searching all over for a solution to take promoted columns from an infopath form library and place summary data on a sharepoint page along with data from other sub-sites (I am creating this at the top of the site collection for management). The situation is this: we have an IT helpdesk that includes walk-in and remote support. I need to summarize the data on the infopath forms that are filled out by each. We have several hundred phone calls per day and a form library of 3000+ records. I know I can use a filter web part on the "created" dates to limit the web part, but I have no idea how to summarize the data into a nice dashboard-style page without advanced coding...any ideas on how this can be accomplished or links that would help? We do have WSS3.0 and MOSS 2007 Enterprise, I have full control over the site collection where these different libraries reside, I have excel services if needed to activate somewhere. I need to summarize information like the top 5 departments of the users who came in, top 5 topics for phone calls, average rating of agents by a survey sent out, total calls, total walkins, etc.
Side note -- there are roughly 90 published columns per library.
Second side note -- I have already tried using Access to report the information but it is way too slow to have a query pulling from those different data sets...I really want it to be direct from the web and show the data dynamically for all the managers.
