Hi,
I have a custom report that I need to add a new field to the report. I've added a new column stored procedure and all works well inside sql server mgmt studio. But I'm having a problem in Infomaker. I am able to connect to the database from inside Infomaker, but not getting anything in the new field when running the report. It appears that Infomaker is not seeing the new column from the stored procedure.
If I run/preview the report in info maker, I get the following error message:
"Select Error: SQLSTATE=42000Microsoft OLEDB Provider for SQL ServerCould not find stored procedure'dbo.LP_YALE_PERFORMACE_CUMULATIVE_SALES_2'
The Stored procedure does exist and is working. One thing I noticed is when browsing the database from within Infomaker, I don't see any of the stored procedures, only system stored procedures. Is there a permissions setting in sql server that will allow Infomaker to see the procedures? Any ideas?
Thanks,
Dave
Hey Dave,
Infomaker is a little odd about updates to procedures, there are two things you're probably going to want to do. One is check under your Database Painter that your SQL connection has extended properties of database=impresario
And then on the actual report, you'll need to go to the column specification and manually append a new row for the column you added:
Hope that helps!