I just finished off a set of reports with a update/insert stored procedure.
so maybe this might work for you too.
I made a report with the update/insert stored procedure that confirms the
update/insert with the used parameters.
That specific report is called from the "select" report as a subreport.
Depending how your security is set, the function "created by" might be
handled by a statement in the stored procedure: "get user".
OR using the policies table from reportserver database.
(Didn't figure out that one out yet)
[quoted text, click to view] "mshumaker" wrote:
> Is there a better way to do this? Perhaps a custom data processing extension?
>
> I also need to update a database table with values "created" by the report.
> Essentially I want to store off values from detailed/sub reports to be used
> by a summary report.
>
> Thanks,
> Matt
>
> "Lukasz Pawlowski [MSFT]" wrote:
>
> > Though you can call statements that up date your database, there are several
> > problems with this:
> > 1) this can be a security issue - if you store credentials someone with
> > lesser credentials can now update your database
> > 2) RS does not guarantee that the query will be executed at any specific
> > time. As such, it might be that the other quireies have not yet have run
> > when you expected them to have been already exedcuted.
> >
> > -Lukasz
> >
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> >
> > "CC" <CC@discussions.microsoft.com> wrote in message
> > news:16AB79F9-608A-42B2-A9B5-9B4874C7DE53@microsoft.com...
> > > eCan you call a stored procedure from a report that will update the
> > > database?
> > > I want to update som tables when a report has finished generating.
> > >
> > > I tried to call the update stored procedure from my code (Cold Fusion),
> > > but
> > > the update code was executing before the report call, so the report
> > > queries
> > > were not getting any data since the data had already been updated.
> > >
> > > Thanks!
> >
> >
