Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal 8.5 & VB 6.0 & Oracle: Passing parameters

Status
Not open for further replies.

deanc24

Programmer
Aug 13, 2003
3
US
I know the subject of passing parameters has been addressed before, but that is actually only part of my problem. I am trying to open a compiled Crystal Report (that has data saved within it), make the connection to the database (DSN-less), pass a parameter, refresh the data, print and close the report. But all of this needs to be done without the use of a Viewer, because I dont want the user to see anything. All the samples I have found with parameters refers to the Viewer. Can this be done without the viewer? I just want the user to hit a button (within my VB app), then go to the printer to get the report. I have created the Crystal Application and Report objects, but I cannot figure out the method to pass a parameter and then refresh the data. I have figured out the print command and can close everything out without saving data. Its the parameter and database connection that has me stumped. Thanks for the help!
 
All the forums and code samples I have found reference a line like: Dim Report As New CrystalReport1. Where in the heck is the CrystalReport1? I have looked high and low. I cant even find it in the Object Browser in VB, and I have almost set a reference to just about every Crystal object there is on my PC.

I also go through the steps to perform the
"m_crxReport.Database.LogOnServer ..." command. When I try to perform this command, it says the server has not yet been opened. Of course not, thats what i am trying to do! Any idea what is going on here? Its very frustrating, and I am not that familiar with Crystal's objects.

I appreciate the assistance!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top