Assigning a stored procedure to an infomaker object

Ryan,

The stored procedure TP_ORDER_ACK is the basis of my custom procedure all I did was add a hold_until_dt column. I took the infomaker object d_order_acknowledgement copied it to my local library added a header and text boxes and added the hold_until_dt. The issue is the infomaker object will not recognize the column until it is “reassociate” with the stored procedure that pulls this data, however I am unable to do that, so I thought I’d reach out to the community for assistance.

Am I off my rocker in thinking I can associate the report to a new stored procedure, will I need to create a new infomaker object?

Thank you have a good day!

Naomi Williams

Naomi, I'm not sure which report you are attempting to customize.  If the original datawindow was constructed using a SQL statement and not a stored procedure, I'm afraid you'll need to build a new datawindow.  Once the type of datasource has been determined for a datawindow (SQL Query, Stored Procedure, etc), it cannot be changed.

This is not, however, as hard as it sounds.  If your dataset contains the same column specifications as the original report with any additional columns added to the end of the column specifications, you should be able to create a brand new datawindow with the new stored procedure.  Once you create the new datawindow, press CTRL+A to select all of the objects in the Layout, and delete them.  Build any groups as needed, and space out the header, summary, group and detail bands as they appear on the original report.  Now go to the original datawindow, press CTRL+A to select all of the objects, move to the new datawindow and paste.  If all of the columns are named the same, the copy of objects from one to the other should be seamless.

Hope that makes sense!

-Ryan

Ryan,

The stored procedure TP_ORDER_ACK is the basis of my custom procedure all I did was add a hold_until_dt column. I took the infomaker object d_order_acknowledgement copied it to my local library added a header and text boxes and added the hold_until_dt. The issue is the infomaker object will not recognize the column until it is “reassociate” with the stored procedure that pulls this data, however I am unable to do that, so I thought I’d reach out to the community for assistance.

Am I off my rocker in thinking I can associate the report to a new stored procedure, will I need to create a new infomaker object?

Thank you have a good day!

Naomi Williams

Naomi, I'm not sure which report you are attempting to customize.  If the original datawindow was constructed using a SQL statement and not a stored procedure, I'm afraid you'll need to build a new datawindow.  Once the type of datasource has been determined for a datawindow (SQL Query, Stored Procedure, etc), it cannot be changed.

This is not, however, as hard as it sounds.  If your dataset contains the same column specifications as the original report with any additional columns added to the end of the column specifications, you should be able to create a brand new datawindow with the new stored procedure.  Once you create the new datawindow, press CTRL+A to select all of the objects in the Layout, and delete them.  Build any groups as needed, and space out the header, summary, group and detail bands as they appear on the original report.  Now go to the original datawindow, press CTRL+A to select all of the objects, move to the new datawindow and paste.  If all of the columns are named the same, the copy of objects from one to the other should be seamless.

Hope that makes sense!

-Ryan

Team,

I have made a modification to a standard tessitura report saved it as a custom report,  however it will not allow me to point the infomaker object to the new stored procedure. When I select the column specifications I can usually right click and select stored procedure and change where the data needs to come from however this is not working is there other way to point this infomaker object to the new stored procedure? The infomaker object is perfect and I would hate to have to create another infomaker object.

Thanks in advance!

Naomi

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Shared Reports Forum. You may reply to this message to post to the forum or visit the site to search, read and post to the forums.