Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: How to call procedure in Crystal report 2008 Post Reply Post New Topic
Author Message
Padma
Newbie
Newbie
Avatar

Joined: 09 Sep 2010
Location: India
Online Status: Offline
Posts: 20
Quote Padma Replybullet Topic: How to call procedure in Crystal report 2008
     Posted: 03 Jun 2011 at 12:54am
HI,
 
Im unable to call a procedure in the Crystal Report 2008. Please suggest how it can be done.
 
Thanks,
Padma
priya
IP IP Logged
Dewald
Groupie
Groupie
Avatar

Joined: 02 Jun 2011
Location: South Africa
Online Status: Offline
Posts: 47
Quote Dewald Replybullet Posted: 03 Jun 2011 at 1:44am
Just select it from the Database Expert as if you are connecting to a table.
Dewald Botha
http://www.ITClarity.co.za
IP IP Logged
zach18
Groupie
Groupie
Avatar

Joined: 08 Feb 2011
Online Status: Offline
Posts: 46
Quote zach18 Replybullet Posted: 03 Jun 2011 at 4:40am
you have to make sure you connect to the right server with credentials that have access to run the SP
Using Crystal Report 2008
www.zachtech.us
IP IP Logged
Dewald
Groupie
Groupie
Avatar

Joined: 02 Jun 2011
Location: South Africa
Online Status: Offline
Posts: 47
Quote Dewald Replybullet Posted: 03 Jun 2011 at 4:57am
ZACH18 is correct. With sql you have schemas. If you do not have permission to access the schema, you will not see it in the database expert.
Dewald Botha
http://www.ITClarity.co.za
IP IP Logged
Padma
Newbie
Newbie
Avatar

Joined: 09 Sep 2010
Location: India
Online Status: Offline
Posts: 20
Quote Padma Replybullet Posted: 07 Jun 2011 at 11:43pm
HI thanks for your reply.
 
I tried as per ur instruction, i connected to that schema and im able to see all the stored procedures but im unable to select it. It given error msg "Invalid Argument Provided".
 
Please help me..
 
Padma
priya
IP IP Logged
Dewald
Groupie
Groupie
Avatar

Joined: 02 Jun 2011
Location: South Africa
Online Status: Offline
Posts: 47
Quote Dewald Replybullet Posted: 08 Jun 2011 at 12:01am
can you execute the SP in sql on it's own using the same login credentials?
Dewald Botha
http://www.ITClarity.co.za
IP IP Logged
Padma
Newbie
Newbie
Avatar

Joined: 09 Sep 2010
Location: India
Online Status: Offline
Posts: 20
Quote Padma Replybullet Posted: 08 Jun 2011 at 12:40am
s i can execute it. im not able to call even a single stored procedure whcih contains a select statement.
priya
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.