In my Voice of the Customer site, I have several tables. One for customer info, one for issues these customers bring up, and one for comments by the IT folks responding to the customer (plus a few smaller ones). We currently have a .Net page which pulls together the info and displays nice red, yellow, green indicators for those customers contacted within 7 days (green), 14 days (yellow) or longer (red). I got the wonderful web parts from Mark's recent web class with visual indicators and the javascript to turn a dot into a larger rgy circle, etc. My problem is extracting only the latest comment from that comment table and presenting a report (list view) grouping with an RGY for the overall site status as well as an RGY for the latest comment date per customer. I can send a screen shot of the existing tool so you can see where I'm headed if this isn't clear. I've been asked to recreate this with OOTB Sharepoint to eliminate the middle-man whenever we change criteria or whatever.
Stump the Panel » End Users and Information Workers
Need to pull most recent entry by site by customer from comments list
(3 posts)-
srsluvselvis
MemberPosted 6 days ago # -
srsluvselvis
MemberGuess I should add that we are using WSS Sharepoint.
Posted 6 days ago # -
Sounds to me like this will involve modifying the custom aspx page you mentioned or recreating the table with a complex Data View Web Part (SPD).
To start working with this, you'll probably need to create a linked data source in SPD and add a DVWP to a blank page that uses that data source. The XSL involved is not for the fient of heart though.
Posted 5 days ago #
Reply
You must log in to post.