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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can you Help me in VB6 with RDC getting Repots ??

Status
Not open for further replies.

ksraju6

Programmer
Jul 12, 2001
22
US
Hi,

I am having a specific problem .

I have more than 20 Reports which are to be called from the VB environment. 4 of those reports have more than 50000 records and more than 4 parameters . When i am calling any of the reports using crystal viewer . The report is not opening and says "server has not yet been opened" .
My questions are:

1) Do i need to give the logon information in my vb ? Or it will take from the reportdesigner ( since i added the existing report to my project)
Incase i need to give the server information i.e ODBC where shall i give. can you give me some sample code.

2) why the Report is not asking for the parameters when i call from the vb environment using crystal viewer.

3) Why am I not getting the refress icon(the Yellow one) on my report ?

Pl. do help me

Is there any easiest way to access the reports thru vb other than using common dialogue control ??


Raj
732-277-8181
njsales@keyusa.com
 
You need to call either .SetLogonInfo or .LogonServer to establish a connection to the database before viewing the report.

You need to fill the report's parameters with data before viewing the report in the report viewer.

There are a lot of examples at:
Type "Visual Basic RDC Examples" to Ask Jeeves. Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top