I am looking to build a stored procedure into an infomaker report. I have to use infomaker because the function I will utilize it for in Tessitura does not support the SSRS reports. My hope is to use this procedure on an existing report I created, but my first issue is that the stored procedure is not showing up in Procedures and Functions in Objects. Even when I try to create a new object, the procedure doesn't show up. I am currently working in Test and I double checked to make sure the procedure is in Test and infomaker is connected to test.
Is there more I have to do in the database to deploy this procedure to infomaker? Once its there is it even possible to change the procedure used for an existing report, or must it be built from scratch?
Hi Jesse -
Have you created a database profile in InfoMaker? This is what connects IM to your database.Go under Tools>Database Profiles. Highlight OLE Microsoft OLE DB and click New...Give the profile a name - "Tessitura" will do.Select Provider SQLOLEDBDefine your datasource - this will likely be UNEBTEST\UNEB for you.give a SQL login and passwordIn the Extended Properties, put:database=impresario
If you have all this in place and you're still not seeing your procedure (but can see other standard Tessitura ones), make sure the owner on the procedure is dbo.
If you're having trouble finding how to associate a procedure with a particular datawindow, right-click in the Column Specifications window and select "Stored Procedure". If you're working on a format from scratch, you should see that option there. If you do not see this option when right-clicking in Column Specifications, you may be working from a sample format that does not directly call a stored procedure (such as acknowledgements, renewals or confirmations). Those types of formats do the data collection in a special application window and pass a pre-defined set of columns to the format for display. A window will come up that says Modify Stored Procedure Data Source and have a window for the execute statement. A button called Procedures... should be to the right.
If you don't already have a copy of the InfoMaker user guide, you can download it from my profile. If this doesn't help you, I'll be happy to discuss it further with you in a help ticket.
Thanks for the help. It was simply an issue of granting execution rights to the dbo and then it appeared in infomaker. I was working off a sample format from before, so I decided to just create a new freeform report to build upon. However, my stored procedure works off a single parameter, order_no, and the stored procedure can yield multiple rows for one order and the free form report will only show information for the first row. There are some columns that each row has the same information and I hope to only show these once, but some column rows yield different information and I wanted the report to show all these values but can't figure out how. I checked your profile and was having trouble finding the infomaker guide there. I can look through this, but if I can't find what I'm looking for, would you prefer I open a help ticket and ask for you?
Found it. It took me a while to figure out that IMUG stood for infomaker user guide.