×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!
  • Students Click Here

*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 and VB6

Crystal Reports and VB6

Crystal Reports and VB6

(OP)
I have a vb dataaccess dll that hits a microsoft 2000 database.

I thought I could use crystal reports and this dll to access the data.  

Is there any way I can use code to hit the dll and then post it on the report.  I have tried using the text box in crystal reports to show the data but I get a read only type of error.  Then I tried to use an unbound field control but get some wierd could not creat object error.  I am just wondering if it is possible to create a report without using a DSN or any other control.

Any help would be appreciated.

thanks

RE: Crystal Reports and VB6

If you are doing this within an application, and you can get the data into a recordset, then you can pass the recordset to the report.  The report will probably have to be recreated to accept a recordset, but this way you can get the data however you like.

Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB
http://www.kenhamady.com/

RE: Crystal Reports and VB6

(OP)
Thank you for the reply.  I am using crystal reports through vb using the crystal reports control.  Do you have any suggestions on how to get the data I want.  You suggested using a recordset.  I can get the data into a public recordset using a module to create the public recordset but what do I do with it then.  Every time I add a field or text box to the crystal report it auto fills in the stuff but I want to fill in the box or field on the fly depending which user is logged into the system and what the date is on the form.  I have global variables that keep track of the user and date within vb, is there a way to get at these in crystal reports?

RE: Crystal Reports and VB6

Let me review the concept and see if this works for you.

First you have to create the report using a temporary recordset that has the same columns as the one you will pass.  You can't pass a recordset to just any report.  

Then, once you have the report, you use a command in VB to pass your recordset to the report.  You can generate the recordset any way you want.

Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB
http://www.kenhamady.com/

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