• Replies 8 replies
  • Subscribers 339 subscribers
  • Views 60 views
  • Users 0 members are here
Related

Infomaker Custom Tab / Local Table

Sheila Collins
$organization

Hello All,

I'm not sure how to write this clearly but I have a monster of a custom screen with a bunch of calculations (computed fields) based on other computed fields.  Rather than having to recreate these monsters each time I'm creating a report, I'd like to save them back to the local table.  But I'm not sure how to do that.  Do I have the option in Infomaker to use a computed field as a column in the database?  I'm not seeing it. 

Any guidance is a appreciated.

Thank you!

  • $organization

    Can you possibly do everything in the stored procedure and just render the results?

  • $organization

    Without a bit more detail, I would recommend Jon’s suggestion as well.  In general, I try to abstract the data retrieval and processing from the display as much as possible.  It also makes it quite portable for say…migrating to SSRS.

    J

     

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jon Ballinger
    Sent: Tuesday, May 10, 2011 9:32 AM
    To: Ryan Creps
    Subject: Re: [Tessitura Technical Forum] Infomaker Custom Tab / Local Table

     

    Can you possibly do everything in the stored procedure and just render the results?

    From: Sheila Crossman <bounce-sheilacrossman3944@tessituranetwork.com>
    Sent: 5/10/2011 8:00:58 AM

    Hello All,

    I'm not sure how to write this clearly but I have a monster of a custom screen with a bunch of calculations (computed fields) based on other computed fields.  Rather than having to recreate these monsters each time I'm creating a report, I'd like to save them back to the local table.  But I'm not sure how to do that.  Do I have the option in Infomaker to use a computed field as a column in the database?  I'm not seeing it. 

    Any guidance is a appreciated.

    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

    I don’t think so…. Some of the fields used in the calculations are based on input from the user. For example, to calculate the budgeted revenue amount:

     

    Find out how many seats are available to sell based on input of different sections,

    Multiply that by ticket price for each section and sum totals (gross potential)

    Subtract estimated discount amount based on (discount percentage input * calculated gross potential)

    Subtract that amount from gross dollar capacity (cost per seat * # of seats)

    Multiply that by estimated sales percentage input

     

    Blah, blah, blah.   I’d love to do it all in the stored procedure but I’m not sure how without getting these calculated fields back to  it. Does that make sense.

     

    Ryan, I thought I had to use Infomaker when the information is being entered on the custom screen. 

     

    From: Jon Ballinger [mailto:bounce-jonballinger5072@tessituranetwork.com]
    Sent: Tuesday, May 10, 2011 9:32 AM
    To: Sheila Crossman
    Subject: Re: [Tessitura Technical Forum] Infomaker Custom Tab / Local Table

     

    Can you possibly do everything in the stored procedure and just render the results?

    From: Sheila Crossman <bounce-sheilacrossman3944@tessituranetwork.com>
    Sent: 5/10/2011 8:00:58 AM

    Hello All,

    I'm not sure how to write this clearly but I have a monster of a custom screen with a bunch of calculations (computed fields) based on other computed fields.  Rather than having to recreate these monsters each time I'm creating a report, I'd like to save them back to the local table.  But I'm not sure how to do that.  Do I have the option in Infomaker to use a computed field as a column in the database?  I'm not seeing it. 

    Any guidance is a appreciated.

    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

    I guess a second screen for the output?  I was trying to make it just like the excel spreadsheet we’re replacing….

     

    From: Ryan Creps [mailto:bounce-ryancreps9649@tessituranetwork.com]
    Sent: Tuesday, May 10, 2011 9:42 AM
    To: Sheila Crossman
    Subject: RE: [Tessitura Technical Forum] Infomaker Custom Tab / Local Table

     

    Without a bit more detail, I would recommend Jon’s suggestion as well.  In general, I try to abstract the data retrieval and processing from the display as much as possible.  It also makes it quite portable for say…migrating to SSRS.

    J

     

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jon Ballinger
    Sent: Tuesday, May 10, 2011 9:32 AM
    To: Ryan Creps
    Subject: Re: [Tessitura Technical Forum] Infomaker Custom Tab / Local Table

     

    Can you possibly do everything in the stored procedure and just render the results?

    From: Sheila Crossman <bounce-sheilacrossman3944@tessituranetwork.com>
    Sent: 5/10/2011 8:00:58 AM

    Hello All,

    I'm not sure how to write this clearly but I have a monster of a custom screen with a bunch of calculations (computed fields) based on other computed fields.  Rather than having to recreate these monsters each time I'm creating a report, I'd like to save them back to the local table.  But I'm not sure how to do that.  Do I have the option in Infomaker to use a computed field as a column in the database?  I'm not seeing it. 

    Any guidance is a appreciated.

    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!

  • $organization in reply to Sheila Collins

    Unknown said:
    I don’t think so…. Some of the fields used in the calculations are based on input from the user. For example, to calculate the budgeted revenue amount:

    How about making it a report, with all of the user input fields as parameters?

  • $organization in reply to Chris Jensen

    You could also go the route of a web page as a custom tab.  Then you will have all the control that you will need or want.  You can update date based on user events.

  • $organization

    All great ideas.  Lots of fields for parameters.  It’s my first custom tab for input and there are over 140 fields.  (internal, external and notes for all expenses related to a show)  

     

    However I have never created a web page,  it sounds like it may be time to learn.  Recommended reading?

     

    Anyway, thanks for all of the input.  Of course I should have talked to you all first, now I’m on deadline….

     

    From: Jon Ballinger [mailto:bounce-jonballinger5072@tessituranetwork.com]
    Sent: Tuesday, May 10, 2011 10:47 AM
    To: Sheila Crossman
    Subject: RE: [Tessitura Technical Forum] Infomaker Custom Tab / Local Table

     

    You could also go the route of a web page as a custom tab.  Then you will have all the control that you will need or want.  You can update date based on user events.

    From: Chris Jensen <bounce-chrisjensen8841@tessituranetwork.com>
    Sent: 5/10/2011 9:33:05 AM

    Sheila Crossman:

    I don’t think so…. Some of the fields used in the calculations are based on input from the user. For example, to calculate the budgeted revenue amount:

    How about making it a report, with all of the user input fields as parameters?




    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!