Add commentary to report interactively

Hi Gurus

I have a requirement for users to be able to enter commentary against SSRS reports either at a line level or report level.

To give an example, a user may see a value on a report against line "Bike Sales". They should then be able to input a comment by some mechanism against that line which will be displayed in subsequent versions of the report.

We're on SQL 2012 and reports are surfaced in SP 2010.

Our current thought is:

• The Line Item has an embedded URL that when clicked launches a custom SharePoint screen to capture the comment, passing a parameter to identify user, report, report line, etc.


• The comment then gets sent to a data store (either a database or SharePoint list)


• Next refresh of the report picks up the comment and displays it in the right place on the report
  

There's also some security and workflow requirements but I'll skip those for now.

The question is:

1. is there a better way of doing this?


2. has someone already written a product that can do this?

Appreciate your brain time!

Cheers, BI Monkey

---

James Beresford @ www.bimonkey.com & @BI_Monkey

SSIS / MSBI Consultant in Sydney, Australia

SSIS ETL Execution Control and Management Framework @ SSIS ETL Framework on Codeplex