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
In the query or procedure that serves as the datawindow datasource, you need to make sure that you are filtering for the current constituent ID (customer_no). In a SQL Query, you can use the parameter @id_key like this:
Select some, columns, that, you, use, for , your, custom, screen
From LT_MY_CUSTOM_TABLE
Where customer_no = @id_key
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Penny TaborSent: Monday, 20 September 2010 8:57 AMTo: Ryan CrepsSubject: [Tessitura Technical Forum] Custom Screen Help
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!