×
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

Jobs

Newbie ? about CR7 and VB6

Newbie ? about CR7 and VB6

Newbie ? about CR7 and VB6

(OP)
I have a very basic question that I am sure all of you know how to do.  I am very new at this so please excuse my ignorance.  I have a report that I have designed and can use manually that gets its information from a SQL server.  I want to make a VB app to run the report because it needs to run at 1:00 and eventually there will be 39 reports run from the app.  The question I have is what statements and where do I need to put them to have VB log into the SQL server and have the output exported to an HTML file in a specified location.  One other issue I can see is how do I keep the other reports from starting before the one before it is finished?  Thanks.

Dave

RE: Newbie ? about CR7 and VB6

You can create a batch VB application (no GUI forms) that connects to SQL Server, runs the report / exports the report to a destination directory.  You could run execute multiple reports, one after another, in the batch VB app.

You should also think about making the VB application flexible, in that it reads from a SQL Server table what reports to run, what format to export each report to, and the location of where the file export is to be saved.

RE: Newbie ? about CR7 and VB6

(OP)
Those are good ideas, but I still do not know the statements that log into the server or tell the report where to export and how.  Any ideas?  That is a really good idea about the table of reports.  Thanks.

Dave

RE: Newbie ? about CR7 and VB6

You can go to:

http://support.crystaldecisions.net/fix/ask.asp

and type "Visual Basic Example" to Ask Jeeves.  The results of the query will lead you to a lot of zip files of small apps in VB / Crystal.

The manuals that come with the Crystal Reports Developer Edition are very good as well.

RE: Newbie ? about CR7 and VB6

(OP)
Thanks for your help.

Dave

RE: Newbie ? about CR7 and VB6

There are a series of articles in Crystal Clear, our free newsletter for CR designers.  Go to www.chelseatech.co.nz/pubs.htm for back issues.

The first decision to make is to use the RDC or OCX.  The OCX is easier but don't give you as much control over your report.  With the OCX, the connection to the DB is..
crObject.Connect="DSN=myDB;uid=me;pwd=mypassword"

the RDC needs a few more lines.

I've already written a report scheduler so would be happy to share ideas.

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