Post reply

need a design to implement project to track monthly metrics

  • August 22, 2007 at 3:52 pm

    #174403

    I have a reporting Database, which contains monthly metrics, now i want to develop a page in Sharepoint portal, which pulls all records from this reporting database..

    Now in Sharepoint portal, User should be able to enter reason for not meeting expectations for that month...

    Any suggestions abt how to develop this project would be greatly appreciated.

  • August 22, 2007 at 5:18 pm

    #728748

    As it's not clear what "pull all records out of a database" means, I can assume that you will need to run a select query and get the results in a sharepoint page; If this is the case, write a sql sp that extracts the recordset (records from relevant tables of your database) based on your condition included in "where" clase of the select.

    I hope this is what you've been looking for.

  • August 24, 2007 at 10:45 am

    #729342

    Lot's of possibilities depending on the level of sophistication, budget, look and feel, etc.

    I'd suggest starting with Reporting Services which'll alllow you to build a report integrated back into the portal. Then, if all you need is a simple comment / response page, consider creating a quick "list" in Sharepoint. You can include a link from the report to launch directly to create a new item. As worst, this'll give you a quick POC against which you can develop more specific requirements.

    If you're requiremnents are more extensive (i.e. trigger a business process, edits on fields, etc.) then it'll depend on the specifics.  

    Note: You can implement a fairly sophisticated InfoPath form, that'll integrate fairly well and handle many complex edits. But be prepared for a learning curve and recognize it's still basically client/server technology.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply