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!
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 AMTo: 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
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!
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?
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.