Custom Screen Help

Former Member
Former Member $organization

I am trying to create my first custom screen for staff information.  I have created the local table, the Infomaker report and have configured TR_Custom_Tab.  However, I am missing something, because my custom tab now shows ALL of the table entries on the new custom screen, instead of only the information for the constituent record I am looking at.  I’m sure this is something simple that I need to adjust either in my stored procedure or report.  Can someone tell me how to limit the info displayed on the custom screen to only the data that matches the constituent id on the record I am viewing?

 

Thanks in advance,

 

 

Penny Tabor

IT Manager

Midland Center for the Arts

Midland, MI 48640

                            acerp

 

 

Parents
  • Former Member
    Former Member $organization

    Are you passing the customer_no into the stored procedure? Also, make sure your procedure is using the “select distinct” command.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Penny Tabor
    Sent: Monday, September 20, 2010 8:57 AM
    To: Gloria Ormsby
    Subject: [Tessitura Technical Forum] Custom Screen Help

     

    I am trying to create my first custom screen for staff information.  I have created the local table, the Infomaker report and have configured TR_Custom_Tab.  However, I am missing something, because my custom tab now shows ALL of the table entries on the new custom screen, instead of only the information for the constituent record I am looking at.  I’m sure this is something simple that I need to adjust either in my stored procedure or report.  Can someone tell me how to limit the info displayed on the custom screen to only the data that matches the constituent id on the record I am viewing?

     

    Thanks in advance,

     

     

    Penny Tabor

    IT Manager

    Midland Center for the Arts

    Midland, MI 48640

                                acerp

     

     




    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

    Are you passing the customer_no into the stored procedure? Also, make sure your procedure is using the “select distinct” command.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Penny Tabor
    Sent: Monday, September 20, 2010 8:57 AM
    To: Gloria Ormsby
    Subject: [Tessitura Technical Forum] Custom Screen Help

     

    I am trying to create my first custom screen for staff information.  I have created the local table, the Infomaker report and have configured TR_Custom_Tab.  However, I am missing something, because my custom tab now shows ALL of the table entries on the new custom screen, instead of only the information for the constituent record I am looking at.  I’m sure this is something simple that I need to adjust either in my stored procedure or report.  Can someone tell me how to limit the info displayed on the custom screen to only the data that matches the constituent id on the record I am viewing?

     

    Thanks in advance,

     

     

    Penny Tabor

    IT Manager

    Midland Center for the Arts

    Midland, MI 48640

                                acerp

     

     




    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
No Data