• Replies 5 replies
  • Subscribers 336 subscribers
  • Views 32 views
  • Users 0 members are here
Related

Change the Stored Proc a report uses

Former Member
Former Member $organization

Hi All,

 

I’ve made some edits to a stored procedure that a report uses, thereby creating a copy of the procedure. I need to switch the report to point to my new stored procedure and I can’t find info anywhere on how to change that. Can anyone help me?

 

Thanks!

Adrienne

 

Adrienne Steer | Database and Accounts Manager
Kitchener-Waterloo Symphony kwsymphony.ca
Conrad Centre for the Performing Arts
36 King St W | Kitchener ON  N2G 1A3

519.745.4711 x 285
asteer@kwsymphony.on.ca

 

Cirque de la Symphonie

Apr 26 | 8 pm & 27 | 2:30 & 8 pm
Centre In The Square

Daring aerial acrobatics, dazzling juggling & breathtaking feats of strength with glorious music by the KWS
Great seats still available for the matinée! Buy Now

 

2013/14 Season on sale now

Subscribe by April 30 and SAVE 6%!

Do Something Great Tonight!

KWS Patron Services: 519.745.4711 | 888.745.4717 Subscribe Now

 

Parents
  • Former Member
    Former Member $organization

    Hi Jason et al,

     

    Yes, it’s an infomaker report. We’re on Tess 11.0.4 and Infomaker 12.

     

    Adrienne

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jason Song
    Sent: April-26-13 2:36 PM
    To: Adrienne Steer
    Subject: RE: [Tessitura Technical Forum] Change the Stored Proc a report uses

     

    Is this on an Infomaker report?  What version of Tess are you running?

     

     

    Jason Song

    IT Manager

    Scottsdale Cultural Council

    P 480.425.5340

    C 480.529.4653

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Adrienne Steer
    Sent: Friday, April 26, 2013 11:14 AM
    To: Jason Song
    Subject: [Tessitura Technical Forum] Change the Stored Proc a report uses

     

    Hi All,

     

    I’ve made some edits to a stored procedure that a report uses, thereby creating a copy of the procedure. I need to switch the report to point to my new stored procedure and I can’t find info anywhere on how to change that. Can anyone help me?

     

    Thanks!

    Adrienne

     

    Adrienne Steer | Database and Accounts Manager
    Kitchener-Waterloo Symphony     kwsymphony.ca
    Conrad Centre for the Performing Arts
    36 King St W | Kitchener ON  N2G 1A3

    519.745.4711 x 285
    asteer@kwsymphony.on.ca

     

    Cirque de la Symphonie

    Apr 26 | 8 pm & 27 | 2:30 & 8 pm
    Centre In The Square

    Daring aerial acrobatics, dazzling juggling & breathtaking feats of strength with glorious music by the KWS
    Great seats still available for the matinée!     Buy Now

     

    2013/14 Season on sale now

    Subscribe by April 30 and SAVE 6%!

    Do Something Great Tonight!

    KWS Patron Services: 519.745.4711 | 888.745.4717 Subscribe Now

     




    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!

Reply
  • Former Member
    Former Member $organization

    Hi Jason et al,

     

    Yes, it’s an infomaker report. We’re on Tess 11.0.4 and Infomaker 12.

     

    Adrienne

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jason Song
    Sent: April-26-13 2:36 PM
    To: Adrienne Steer
    Subject: RE: [Tessitura Technical Forum] Change the Stored Proc a report uses

     

    Is this on an Infomaker report?  What version of Tess are you running?

     

     

    Jason Song

    IT Manager

    Scottsdale Cultural Council

    P 480.425.5340

    C 480.529.4653

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Adrienne Steer
    Sent: Friday, April 26, 2013 11:14 AM
    To: Jason Song
    Subject: [Tessitura Technical Forum] Change the Stored Proc a report uses

     

    Hi All,

     

    I’ve made some edits to a stored procedure that a report uses, thereby creating a copy of the procedure. I need to switch the report to point to my new stored procedure and I can’t find info anywhere on how to change that. Can anyone help me?

     

    Thanks!

    Adrienne

     

    Adrienne Steer | Database and Accounts Manager
    Kitchener-Waterloo Symphony     kwsymphony.ca
    Conrad Centre for the Performing Arts
    36 King St W | Kitchener ON  N2G 1A3

    519.745.4711 x 285
    asteer@kwsymphony.on.ca

     

    Cirque de la Symphonie

    Apr 26 | 8 pm & 27 | 2:30 & 8 pm
    Centre In The Square

    Daring aerial acrobatics, dazzling juggling & breathtaking feats of strength with glorious music by the KWS
    Great seats still available for the matinée!     Buy Now

     

    2013/14 Season on sale now

    Subscribe by April 30 and SAVE 6%!

    Do Something Great Tonight!

    KWS Patron Services: 519.745.4711 | 888.745.4717 Subscribe Now

     




    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!

Children
  • $organization in reply to Former Member

    First I would recommend coping the infomaker object and renaming it. But, when you have the infomaker report open, you should see the Column Specification window on the bottom of the screen. Right click -> chose stored procedures. The Modify Stored Procedure Data source window will open. You click Procedures button and choose your new procedure in the list or Edit the execute statement.

    Travis