Hi All!
I'm currently making a custom report and am having trouble with AP_GET_SESSION_CONTEXT. I have everything loading properly, rendering, etc, but anytime I try to add the SetSessionContext dataset from the report template I get a "Dataset missing required child element: Fields" error.
I also receive the same error when I try to render the report template. I've tried multiple default settings with no luck. as well as trying a shared/embedded dataset, using a query vs. stored procedure call, with no luck.
Anyone encounter this before? I'm using BIDS and SQL 2008 R2.
Change the Query Type to Text in the Dataset setup and enter this directly in the text query field:
EXEC AP_SET_SESSION_CONTEXT @UserId, @UserGroup
Don’t select Stored Procedure as it expects a result set and is failing because this procedure doesn’t return any results.
+Ryan Creps
+Tessitura Network
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Court Laslop Sent: Wednesday, June 5, 2013 9:55 AM To: Ryan Creps Subject: [Tessitura Technical Forum] Session Context Fields
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!
Thanks Ryan!
That did the trick!
One question though: I currently have it setup as an embedded dataset (and it works). I'm guessing that it can't be setup as a shared dataset: is that correct?
Court