Post reply

change connection string on shared datasource at report runtime

  • June 12, 2018 at 9:55 am

    #406679

    I'd like to be able to identify the report associated with a particular SQL SPID. If I could append an attribute like application name to the SSRS report shared datasource at runtime, I'd be able to see that application name in the SQL server connection information. Is there a way to update the shared datasource application name per report?

    Thanks!

  • June 20, 2018 at 2:03 pm

    #1994718

    Not sure if I understand what you are trying to accomplish, but have you thought about the execution log?  It's in the report server database (dbo.ExecutionLog3).  

    Here is a sample query:

    select top 10 *
    from dbo.ExecutionLog3
    order by TimeStart desc

  • June 20, 2018 at 3:28 pm

    #1994742

    jmeerdink - Tuesday, June 12, 2018 9:55 AM

    I'd like to be able to identify the report associated with a particular SQL SPID. If I could append an attribute like application name to the SSRS report shared datasource at runtime, I'd be able to see that application name in the SQL server connection information. Is there a way to update the shared datasource application name per report?

    Thanks!

    Frankly, I doubt it...  A shared datasource is not likely to be able to be updated by any given report user, so you should look at alternatives.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply