Custom Screen Help

I figured it out…I was using a SQL statement with more than one retrieval argument…made new stored procedure and now it works.  Thanks anyway.

Penny

Also, even though I have my local table specified in the tr_custom_tab as the update table, and have edit/insert/delete and select permissions on the local table, I cannot edit the new custom tab.  If I click the “Add” button, I get the following error:

I do have the column id_key in my local table, but I did notice that it created it to allow nulls.  I tried to uncheck the box on the table to not allow nulls, but it gave me an error when I tried to save the change.

Any ideas?

Penny

That worked perfect!  Now, one more question…in the  tr_custom_tab table, I have checked the box” standard look” which I understood would make the background of the custom screen match the typical beige color of the other Tessitura windows, but my new custom screen background is white.  Do I need to change the color in my Infomaker report?

Penny

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

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

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!

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!

I figured it out…I was using a SQL statement with more than one retrieval argument…made new stored procedure and now it works.  Thanks anyway.

Penny

Also, even though I have my local table specified in the tr_custom_tab as the update table, and have edit/insert/delete and select permissions on the local table, I cannot edit the new custom tab.  If I click the “Add” button, I get the following error:

I do have the column id_key in my local table, but I did notice that it created it to allow nulls.  I tried to uncheck the box on the table to not allow nulls, but it gave me an error when I tried to save the change.

Any ideas?

Penny

That worked perfect!  Now, one more question…in the  tr_custom_tab table, I have checked the box” standard look” which I understood would make the background of the custom screen match the typical beige color of the other Tessitura windows, but my new custom screen background is white.  Do I need to change the color in my Infomaker report?

Penny

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

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

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!

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!