×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Crystal Reports 10 and Pervasive Stored Procedures

Crystal Reports 10 and Pervasive Stored Procedures

Crystal Reports 10 and Pervasive Stored Procedures

(OP)
Hello,

I am wondering if it is possible to use stored procedures created in pervasive 8.6 to be used as a data source in Crystal 10 standard edition.  
I did mark the Stored Procedures option in Crystal, but I cannot see any stored procedure when I connect to the ddf file.
Any help would be appreciated.
thanks.

RE: Crystal Reports 10 and Pervasive Stored Procedures

A few questions:
- Do you have Stored Procedures(SPs) in the Pervasive database?  
- Why do you want to use an SP?  There's typically no performance improvement in using SPs.  

Also, are you using the ODBC driver in Crystal Reports or are you using the Btrieve option?  If it's the Btrieve option, you may not be able to use SPs since SPs are a SQL construct and aren't available through the Btrieve interface.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Crystal Reports 10 and Pervasive Stored Procedures

(OP)
Thank you for your quick reply Mirtheil.  My ultimate goal is to use a stored procedure in a shipping label report that will allow the user to skip a specified number of labels before printing the records.  I read somewhere that I could use a union query in a stored procedure (although the example used an SQL server).  I was trying to use the btrieve option in Crystal.
Any suggestions are greatly appreciated.

Thanks.

RE: Crystal Reports 10 and Pervasive Stored Procedures

The fact that you are using the Btrieve option may limit you. I don't have Crystal 10 so I can't try it but you might try using ODBC (and creating an ODBC DSN pointing to the data) and check for the SPs.  
You'll need to make sure you have an SP defined in the PSQL database.  PSQL doesn't use (or give an advantage to SPs).  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Crystal Reports 10 and Pervasive Stored Procedures

ODBC is definately required to see the SP in crystal.  

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

RE: Crystal Reports 10 and Pervasive Stored Procedures

(OP)
Thanks Mirtheil.  Unfortunately I need the professional version of Crystal to use ODBC.  I do have the SP defined in the PSQL and I can run in in the PCC.  Any other suggestions?

RE: Crystal Reports 10 and Pervasive Stored Procedures

What edition of crystal are you using?  Standard?

I have written a label report that skips a specified # of labels (from a parameter prompt) and I did not need an SP to accomplish this.    Maybe you can explain what you are trying to do.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

RE: Crystal Reports 10 and Pervasive Stored Procedures

(OP)
Hi dgillz,

I am using the Standard edition of Crystal. I was hoping to create the report based on the SP because I thought it might be easier than creating all the extra detail section with conditional suppressions and the parameter prompt (that is what I did previously).  Did your report use a different method for skipping labels?

RE: Crystal Reports 10 and Pervasive Stored Procedures

No that is exactly the method I used.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close