Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Stored Procedure

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

4 Users

0 Reactions

68 Views

RSS

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

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

SLHV

(@slhv)

Posts: 478

Honorable Member

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

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

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

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

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

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

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

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0