Hello all,
I have a whole suite of report widgets that our Development wants to run per user. In other words, the Expiring Credit Cards report will show a user only those customers with an expiring credit card for that user (matching an attribute on the customer’s account with their name in Security). I couldn’t find any SQL user that worked because it’s always dbo or some other generic user that runs the SQL procedure. But I got the SSRS reports to run on user based on who ran it in the Gooesoft_report tables. But that same report in a widget doesn’t grab the user (I think because it’s bypassing the Select Report Parameters screen in Tessitura). Does anyone know if there is a way to grab the windows username for the person running the SSRS report from within a Tessitura widget and pass that through the URL of the report?
I have a whole suite of report widgets that our Development wants to run per user. In other words, the Expiring Credit Cards report will show a user only those customers with an expiring credit card for that user (matching an attribute on the customer’s account with their name in Security). I couldn’t find any SQL user that worked because it’s always dbo or some other generic user that runs the SQL procedure. But I got the SSRS reports to run on user based on who ran it in the Gooesoft_report tables.
But that same report in a widget doesn’t grab the user (I think because it’s bypassing the Select Report Parameters screen in Tessitura).
Does anyone know if there is a way to grab the windows username for the person running the SSRS report from within a Tessitura widget and pass that through the URL of the report?
Well, right after I posted that I found the SSRS field User!UserID so I’m seeing it that works.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Stuart McLeodSent: Thursday, September 26, 2013 4:43 PMTo: Stuart McLeodSubject: [Tessitura Technical Forum] Finding the user running a widget
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!