• Replies 3 replies
  • Subscribers 337 subscribers
  • Views 53 views
  • Users 0 members are here
Related

SSRS and AP_Get_Parameter_Values

Sheila Collins
$organization

Hello,

Can someone please walk me thru setting this up in SSRS? I have a problem everytime and though I've managed to get it to work before, I struggle this time (actually everytime). 

I must be missing something! I've tried adding the @request_id in the parameters window, I've tried not adding it there and just putting it in the parameters tab of the dataset, etc..

Thanks,

Sheila

  • $organization
    Sheila, if you download the sample reports from last year's webinar or from this year's conference (from my prelude presentation), there is a v8.0 and v9.0 "report template" that shows how I use this procedure to display Tessitura parameter values in a report.

    ________________________________

    From: Tessitura Technical Forum on behalf of Sheila Crossman
    Sent: Thu 10/8/2009 9:31 AM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] SSRS and AP_Get_Parameter_Values



    Hello,

    Can someone please walk me thru setting this up in SSRS? I have a problem everytime and though I've managed to get it to work before, I struggle this time (actually everytime).

    I must be missing something! I've tried adding the @request_id in the parameters window, I've tried not adding it there and just putting it in the parameters tab of the dataset, etc..

    Thanks,

    Sheila




    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!
  • $organization in reply to Ryan Creps (Past Staff Member)
    Thanks Ryan. I have my own example to follow, and I did get it to work. Not sure what I did differently - I have problems when trying to get the fields populated for the parameter dataset.



    Sheila


    -----Original Message-----
    From: Ryan Creps [mailto:bounce-ryancreps9649@tessituranetwork.com]
    Sent: Thursday, October 08, 2009 11:22 AM
    To: Sheila Crossman
    Subject: RE: [Tessitura Technical Forum] SSRS and AP_Get_Parameter_Values

    Sheila, if you download the sample reports from last year's webinar or from this year's conference (from my prelude presentation), there is a v8.0 and v9.0 "report template" that shows how I use this procedure to display Tessitura parameter values in a report.

    ________________________________

    From: Tessitura Technical Forum on behalf of Sheila Crossman
    Sent: Thu 10/8/2009 9:31 AM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] SSRS and AP_Get_Parameter_Values



    Hello,

    Can someone please walk me thru setting this up in SSRS? I have a problem everytime and though I've managed to get it to work before, I struggle this time (actually everytime).

    I must be missing something! I've tried adding the @request_id in the parameters window, I've tried not adding it there and just putting it in the parameters tab of the dataset, etc..

    Thanks,

    Sheila




    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!


    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!
  • $organization in reply to Sheila Collins
    There are other parameters in the procedure that can be used to pull the last report request parameter values without knowing the request id. These can simply be passed as NULL when refreshing/populating the dataset. In the parameters tab of the dataset, they can be hardcoded with NULL values using "=System.DBNull.Value".

    ________________________________

    From: Tessitura Technical Forum on behalf of Sheila Crossman
    Sent: Thu 10/8/2009 2:31 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] SSRS and AP_Get_Parameter_Values



    Thanks Ryan. I have my own example to follow, and I did get it to work. Not sure what I did differently - I have problems when trying to get the fields populated for the parameter dataset.



    Sheila


    -----Original Message-----
    From: Ryan Creps [mailto:bounce-ryancreps9649@tessituranetwork.com]
    Sent: Thursday, October 08, 2009 11:22 AM
    To: Sheila Crossman
    Subject: RE: [Tessitura Technical Forum] SSRS and AP_Get_Parameter_Values

    Sheila, if you download the sample reports from last year's webinar or from this year's conference (from my prelude presentation), there is a v8.0 and v9.0 "report template" that shows how I use this procedure to display Tessitura parameter values in a report.

    ________________________________

    From: Tessitura Technical Forum on behalf of Sheila Crossman
    Sent: Thu 10/8/2009 9:31 AM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] SSRS and AP_Get_Parameter_Values



    Hello,

    Can someone please walk me thru setting this up in SSRS? I have a problem everytime and though I've managed to get it to work before, I struggle this time (actually everytime).

    I must be missing something! I've tried adding the @request_id in the parameters window, I've tried not adding it there and just putting it in the parameters tab of the dataset, etc..

    Thanks,

    Sheila




    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!


    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!


    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!