• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 19 views
  • Users 0 members are here
Related

Profile Trace for SSRS Report?

Doug Jones
$organization

Having problems returning results to an SSRS report from both Tessitura and BIDS.  How can I setup my trace so that I can see the parameter values being passed through tessitura to SSRS?

We are in a 64-bit SQL Server 2008 R2 Evironment

Thanks.

-doug

  • $organization

    The trace event called RPC Completed is what was needed to capture the parms being used.

    -doug

  • $organization

    If you’re on a production environment with a lot of traffic, you may want to filter that trace down to the logins being used.  You could filter on both the user’s dblogin in Tessitura as well as the Shared Data Source credentials in SSRS.

     

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Doug Jones
    Sent: Saturday, May 21, 2011 11:32 PM
    To: Ryan Creps
    Subject: Re: [Tessitura Technical Forum] Profile Trace for SSRS Report?

     

    The trace event called RPC Completed is what was needed to capture the parms being used.

    -doug

    From: Doug Jones <bounce-dougjones6811@tessituranetwork.com>
    Sent: 5/20/2011 7:51:50 PM

    Having problems returning results to an SSRS report from both Tessitura and BIDS.  How can I setup my trace so that I can see the parameter values being passed through tessitura to SSRS?

    We are in a 64-bit SQL Server 2008 R2 Evironment

    Thanks.

    -doug




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!