Notifications
Clear all
Topic starter
Hi All,
Does anyone know how to access a stored procedure in crystal reports? There is a stored procedure we've been told exists in the database but I can't find in crystal report stored procedure area. I've run a SQL command to bring in views and tables before but never for stored procedures. Is this the same command? I'm not too great with SQL so i wanted to ask before I tried anything...
Thanks
Mike
Posted : July 8, 2015 7:30 am
Stored procedures are found under Programmability in SQL. I'm not sure how to access in Crystal unfortunately since I rarely use Crystal.
Posted : July 8, 2015 7:38 am
I have created stored procedures within Crystal, but they will not execute when the report is called from Centricity.
Posted : July 8, 2015 8:28 am
Topic starter
I want to run it from crystal itself not out of the EMR so that shouldn't be an issue. The command I've used to access hidden tables/views in crystal is:
Grant all on “tablename” to report;
Commit;
To access the stored procedure would it be the same command just replace tablename with the stored procedure name? As an example we did not have the USR table access in crystal and had to use the USRINFO view for a while. After we tried to report on the credentialed status of users we found that this hidden table (USR) existed but wasn't available in crystal for us. Running:
Grant all on USR to report;
Commit;
Gave us the access (report is our reporting user name).
Thanks
Mike
Posted : July 8, 2015 8:41 am
Try... GRANT EXECUTE ON dbo.[proc name] TO report.
GRANT ALL is deprecated so its use should be avoided, but it should still work in this case according to BOL.
Posted : July 9, 2015 4:44 am
Topic starter
Hi All,
Thanks for the information. Ron I am going to use that command you gave but our organization is very cautious with SQL commands so I have to run it through the approval channels. Once done and if I can report with it as I hope I can I will post an update/some information.
Thanks
Mike
Posted : July 10, 2015 3:17 am
