Prev: Page header fields on multiple pages
Next: How to retrieve thresholds from the database
From: KarenM on 11 Mar 2010 07:56
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
From: Uri Dimant on 11 Mar 2010 08:43
KarenM
Hmm, render the report to EXCEL then issue SQL statement to update the
tables



"KarenM" <karenmiddleol(a)yahoo.com> wrote in message
news:62f07295-4a0f-4cdf-b1dc-c7341c9829bb(a)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


From: jezmondo on 14 Mar 2010 14:19
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(a)yahoo.com> wrote in message
news:62f07295-4a0f-4cdf-b1dc-c7341c9829bb(a)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

 | 
Pages: 1
Prev: Page header fields on multiple pages
Next: How to retrieve thresholds from the database