Custom Assemblies and Accessing report parameters

I am trying to access the datasource's parameters (connection string etc) via
the report, and passing these parameters to a custom assembly at the end of
the report, with the intention of firing off a stored procedure from this
assembly.
The assembly is done, but the connection string is hard coded.
Is there anyway of accessing these parameters direct from the report, or an
interface I can implement to achieve this?Please see my response on your other thread with the same title.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Benugo" <Benugo@.discussions.microsoft.com> wrote in message
news:F65A3AB4-D2FB-456A-8BE3-BD24CD50E5B2@.microsoft.com...
> I am trying to access the datasource's parameters (connection string etc)
via
> the report, and passing these parameters to a custom assembly at the end
of
> the report, with the intention of firing off a stored procedure from this
> assembly.
> The assembly is done, but the connection string is hard coded.
> Is there anyway of accessing these parameters direct from the report, or
an
> interface I can implement to achieve this?

Custom assemblies and accessing report parameters

I am trying to access the datasource parameters (connection string etc)
through the report with the intention of using them to fire off a stored
procedure at the end of the report. The parameters will be passed to a custom
assembly will execute the sp to update several status flags in the database.
The assembly is done and updates the status parameters, however the
connection string is currently hard coded.
Is there any way to access these parameters direct from the report, or an
interface I could implement in my assembly that would allow me access to them?Please see my response on your other thread with the same title.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Benugo" <Benugo@.discussions.microsoft.com> wrote in message
news:484BE97E-55FF-456B-94C7-C7AECE733CF1@.microsoft.com...
> I am trying to access the datasource parameters (connection string etc)
> through the report with the intention of using them to fire off a stored
> procedure at the end of the report. The parameters will be passed to a
custom
> assembly will execute the sp to update several status flags in the
database.
> The assembly is done and updates the status parameters, however the
> connection string is currently hard coded.
> Is there any way to access these parameters direct from the report, or an
> interface I could implement in my assembly that would allow me access to
them?

Custom Assemblies and accessing report connection parameters

I am trying to access the datasource connection properties (connection string
etc) from a report -I will be accessing the information via a custom
assembly, or passing it to a custom assembly with a view to firing a stored
procedure at the end of the report in order to update a number of status
flags including the last page number of a report. The custom assmbly's done,
but has a hard coded connection string - I need to get at the reports
connection string so I fire the sp in the same db as the report's bound to.
Is there any way of accessing this information direct from the report or an
interface I can implement to retrieve it?No, you cannot access this information on RS 2000. The closest you can get
to have this configurable is to add a hidden parameter (requires RS 2000
SP1) and pass this parameter to the custom assembly.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Benugo" <Benugo@.discussions.microsoft.com> wrote in message
news:DBEF289F-B31A-4318-86C0-303AFC35E5A0@.microsoft.com...
> I am trying to access the datasource connection properties (connection
string
> etc) from a report -I will be accessing the information via a custom
> assembly, or passing it to a custom assembly with a view to firing a
stored
> procedure at the end of the report in order to update a number of status
> flags including the last page number of a report. The custom assmbly's
done,
> but has a hard coded connection string - I need to get at the reports
> connection string so I fire the sp in the same db as the report's bound
to.
> Is there any way of accessing this information direct from the report or
an
> interface I can implement to retrieve it?