Hi All

I have SSRS Reports displaying a few metrics sometimes users want to
update comments on these metrics like we display in a tablix the name
of the metric, month, year and the value of the metric and users want
to update some comments on this.

I know in one of the SQL User group meetings I saw someone demo
updating data from SSRS into SQL DB appreciate if any of you can
kindly share the how to on implementing this.

Thanks
Karen

KarenM
Hmm, render the report to EXCEL then issue SQL statement to update the 
tables



"KarenM" <karenmiddleol@yahoo.com> wrote in message 
news:62f07295-4a0f-4cdf-b1dc-c7341c9829bb@b9g2000pri.googlegroups.com...
> Hi All
>
> I have SSRS Reports displaying a few metrics sometimes users want to
> update comments on these metrics like we display in a tablix the name
> of the metric, month, year and the value of the metric and users want
> to update some comments on this.
>
> I know in one of the SQL User group meetings I saw someone demo
> updating data from SSRS into SQL DB appreciate if any of you can
> kindly share the how to on implementing this.
>
> Thanks
> Karen 

Karen

Embed the report into a report viewer control in an asp.net web page. Then 
add a comments box with 'Save' button beneath it. You can then access the 
report parameters (metric, month, year etc) and save the comments along with 
the report data. When you run this in SSRS you can include a box to pick up 
the comments relevant to the report parameters.

hth

Jeremy

"KarenM" <karenmiddleol@yahoo.com> wrote in message 
news:62f07295-4a0f-4cdf-b1dc-c7341c9829bb@b9g2000pri.googlegroups.com...
> Hi All
>
> I have SSRS Reports displaying a few metrics sometimes users want to
> update comments on these metrics like we display in a tablix the name
> of the metric, month, year and the value of the metric and users want
> to update some comments on this.
>
> I know in one of the SQL User group meetings I saw someone demo
> updating data from SSRS into SQL DB appreciate if any of you can
> kindly share the how to on implementing this.
>
> Thanks
> Karen