Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  HOME    TRACKER    Visual Basic

Crystal Report :-Can't Open SQl Server

anybody can help me regarding crystal reports ..i am
using back end as SQLSERVER 2000 and my OS is WINDOWS
2000..i am using VB6.0 my problem is i am not able to
open reports it says [20599] can't open SQL SERVER can
any body quickly help me in fixing this problem
thanking you

View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Vb6 + Crystal Report + Cannot Open Sql Server
vb6 + crystal report + cannot open sql server ...?

Crystal Report Cannot Open Sql Server Please Help
crystal report cannot open sql server please help


Crystal Report : Server Has Not Yet Open
HI everybody

I have 3 reports in my app. they are successfully install/distributed to other system. I have one Problem with them

One report get open properly, but other two reports give error that is "SERVER has not yet open". I am using ODBC due to my multi-databases.

My Programming I Change registry Entries of ODBC. I think it is fine because my app is working fine, only two reports give this error. Visual Basic is used.

Please help me.

Crystal Report Error, Server Has Not Yet Been Open !
I use crystal report v8.0 to show report in vb form.

When I run program, I got an error "Server has not yet been opened "

I use ODBC to connect to an Access 97 Database in the report file.
When I preview the report the data is came out .

Does it error on report file or VB code?

If anybody know ,please let me know

Thank you

Crystal Report - Cant Open Sql Server Problem
i'm using VB6 and Microsoft SQL Server.
i have created a crosstab on my report by using crystal report. i get an error when i try to view my report. The error is "Can't Open SQL Server".
i found that if i untick the "Save data with report" and "Verify data on every print" in crystal report,i will get the above error.
Otherwise,i can view the report but the data are unable to refresh.
How can i solve it?

Thanks for helping.

Edited by - yuen on 3/18/2008 6:11:29 AM

Crystal Report Runtime Error 20599 Can Not Open SQL Server
Hi All,

i am using vb 6.0 and crystal reports 8.5 with SQL Server 2000 Database.
below is the code which i have written.

CrystalReport1.ReportTitle = "Payment Analysis per salesman for date range " & DT1.Value & " And " & DT2.Value & ""
sql = "{FinalWeeklydata.Shipmentdate} IN date(" & DT1.Year & "," & DT1.Month & "," & DT1.Day & ") TO date(" & DT2.Year & "," & DT2.Month & "," & DT2.Day & ") " & sql2
CrystalReport1.SelectionFormula = sql
CrystalReport1.ReportFileName = reportfilepath & "
CrystalReport1.Action = 1

can anyone help me on this.


Error In Crystal Report &"Server Has Not Been Open Yet&"
I have a problem. I have my database in a server and i connect to the database with a odbc driver. All my connections in my program are ok, but when i try to open a report in crystal reports the next error appears.

"Server has not been open yet"

Anyone knows what i need to do?

Error In Crystal Report - &"server Has Not Yet Been Open&"
hi experts,
I am building reports using crystal report 8 in my VB application. the datasource is Oracle 8i(8.1.6).
When i built a report using the report expert in Crystal report it has successfully created the report.
But when i ran the application i throws an error (ORA01005) saying - "null password was given; logon denied" and "server has not been yet started"

i have not written any code, i just used the wizard(report expert) and i have give the correct user name and password.

also i did the same thing without wizard, using code. the code which i have written is in the follwoing lines.

Const ConString = "Provider=MSDAORA.1;User ID=gtsc;password=gtsc;Data Source=portal1;Persist Security Info=False"

Private Sub Report_Initialize()
Dim con As ADODB.Connection
Set con = New ADODB.Connection
con.ConnectionString = ConString

Dim rs As ADODB.Recordset

Set rs = New ADODB.Recordset
rs.Open "Select * from emp", con, 3, 2, 1

Database.SetDataSource rs
End Sub


so any body can help me on this issue.
immediate help is required.
thanks in advance.


Error In Crystal Report - &"server Has Not Yet Been Open&"
hi all,
I am building reports using crystal report 8 in my VB application. the datasource is Oracle 8i(8.1.6).
When i built a report using the report expert in Crystal report it has successfully created the report.
But when i ran the application i throws an error (ORA01005) saying - "null password was given; logon denied" and "server has not been yet started"

i have not written any code, i just used the wizard(report expert) and i have give the correct user name and password.

so any body can help me on this issue.
immediate help is required.
thanks in advance.

&"cannot Open Sql Server&" Vb-crystal Report 7.1
Hello !
i'm a bigginer to crystal report 7.1 working with vb6 and sql2000.

i' have created a report in crystal report 7.1 and want to call from vb form.

when i tried this with the following coding using crystal report control i'was getting the error message

"cannot open sql server"

what should i do ? do i need to give the connection string ?
if so show me sample.

With crcontrol
.ReportFileName = App.Path + "
.ParameterFields(0) = "pbcode;" & txtbcode.Text & ";true;"
.WindowState = crptMaximized
.Action = 1
End With

thanks in advance.

Unable To Open The Crystal Report Exported In Crystal Report Format
Sub: Unable to open the Crystal report exported in Crystal Report Format

1)    I have used Oracle Native connection, while designing the report.
2)    I have passed the record set to the report at run time.
3)    Exported the report to Crystal Report Format, But I could n’t able to open report, while opening , the report asks for OLEDB information, even though I used Native connection at design time.
4)    In Crystal Report 8.5, connect driver property, but I am using crystal reports XI and in Visual Basic 6.0, Is there any method or property to convert the connection?. As I have to export report to crystal format and emailed to user, so that user can open it.
Any assistance in this regard is highly appreciated

The code is as follows:
Public Sub Aging_REPORT(strSQL As String, sReportName As String, sDestFileName As String, ReportTitle As String)

On Error GoTo Err
Dim CrAppl As CRAXDRT.Application
Dim crrep As CRAXDRT.Report

Dim rsCrystal As ADODB.Recordset
    Set CrAppl = New CRAXDRT.Application
    Set crrep = CrAppl.OpenReport(sReportName) 'Opens the report
   Set rsCrystal = New ADODB.Recordset
    rsCrystal.Open strSQL, Conn, adOpenStatic, adLockReadOnly
     With crrep
    .Database.LogOnServer "crdb_oracle.dll", strServerName, "", strUserName, strPassword
     .ReportTitle = ReportTitle
     .Database.SetDataSource rsCrystal, 3 'LINK REPORT TO RECORDSET
     .VerifyOnEveryPrint = True
     End With
   With crrep.ExportOptions
    .DestinationType = crEDTDiskFile
    .FormatType = crEFTCrystalReport
    .DiskFileName = sDestFileName
   End With
   crrep.Export (False)
    Set crrep = Nothing
    Set CrAppl = Nothing
    Exit Sub
 MsgBox Err.Description

End Sub


What's Logon Parameter To Oracle Server With Vb To Print Report With Crystal Report
Hi all,

How to write a log on parameter to oralce server with using vb to print a report that using crystal report

is it crystalreport1.connect = "Dsn=servername;uid=username;pwd=password"

and how to use the selectionformula

Crystal Report : How To Open A Report On Pressing Enter Key
Hi all,
I have created a report in Crystal report 7 that displays a list of invoices (with invoice no and customername field in report) on a particular day what i want is when the user click or press enter key on a particular invoice no i should show the details of that invoice. Can anybody suggest how to do this I think we need to use linked sub reports but i have never used such reports please help me on how to do this or suggest any tutorial where i can find such report

My report displays
invoice no. Name
1     aaaa
2     bbbb
3     cccc
4     dddd
5     eeee
6     fffff.

when user click on 2 i need to display the detials of invoice 2 in another report this needs to be done in Crystal report and not in VB


Mind is faster than Wind --- Mahabharat

Crystal, Vb, Xp Pro = Server Not Yet Open
We have a crystal report (v8.5) viewer embedded in a vb6 app, using a vfp ole connection which has been working fine on many installations.

One of our users just got XP Pro, and after reinstalling our program, crystal gets "server not yet open" when attempting to view the report. I've checked the versions of cryst32.ocx, crpaig80.dll, mfc42.dll, msvcrt.dll, craxdrt.dll, crviewer.dll, and all have the same versions as our install & various test machines. And the vfp data is in a local folder. I've also grabbed a copy of their db files and they run fine on my 2K machine.

The only other variable is that they have installed a version of the ADP payroll software that uses an older version of crystal. ADP has supplied them with a modified version of crpe32.dll which allows both versions of crystal to function, but that was in place on their old Windows machines, and worked as advertised, and I've tried putting back the original crpe32.dll from 8.5 and still get the "not yet opened".

This is the only installation I'm aware of that uses XP Pro. And, we've tried it logged in as adminstrator too, so it does not appear to be a permisions problem either. Any ideas?

Server Not Yet Open - Crystal Question
I tried the reporting forum ................

I get this error, not because of a missing ODBC, but because
of permissions. If we use the system administrators login
for the ODBC the report loads with no problem. The current
ODBC is setup for the db owner and it still won't work. Not
too sure what to do.

Open Crystal Report In VB
Hi there!

I have a "little" problem. I have crystal report 9.2 and Vb6 so I tryed to open a report in vb.
I placed the Crystal report viewer on the form but I can't load the report into it.
I used CRViewer91.ReportSource ("c:

Please tell me if I made something wrong

Thank yoy very much

How To Open Crystal Report 8.0 In Vb6.0
hi fellows

     i am a new bie in vb. now a days i am working on reports. i have created some reports using crystal reports 8.0 . now i want to open these reports in my vb forms using ADO. i want my reports to gather information at runtime from the tables developed in Access. i have consulted some books but cudnt find any help .can any body help me plz
any coding plz.plz.plz

thnx in Advance

Crystal Report & Sql Server
Hi everybody

How can i connect my report to a sql server db, using the NT Authentication runtime?

Thanx in advance for your help.


Using Crystal Report With Sql Server
Hello EveryBody

I am trying to use crystal report in vb with sql server, But It is not working Can Any body tell where I am Wrong.

Code I am using is

Public enqhead As New ADODB.Recordset


ssql = "select * from branch "
crsrpt.ReportFileName = "c:cd
crsrpt.WindowState = crptMaximized
crsrpt.Destination = 0
crsrpt.WindowLeft = 100
crsrpt.WindowHeight = 500
crsrpt.WindowState = crptMaximized

enqhead.Open ssql, DataEnvironment1.Connection, adOpenDynamic, adLockPessimistic

crsrpt.Connect = enqhead ''Line where Error is coming
crsrpt.Action = 1

What is wrong in line crsrpt.connect
Can Any body Help

Thanks In Advance


Crystal Report And SQL Server 7.0
Hi all

Can anybody tell me! how to generate a report for data stored in SQL server 7.0?????????????Its very urgent



Crystal Report And Sql Server
Hi Gurus,
I'm using SqlServer 2000 and Crystal report 8 for my application.I need to run this same application at serverral places.So Do i have to do the SET LOCATION from the crystal report at each place beacuase they have different server names.

Dinesh Asanka

Crystal In VB6.0: Error 20599 Cannot Open SQL Server

I have an application in VB6.0 and I send different reports to the window. I do the reports in Crystal Reports 8.5.
When I send to show the reports since the application, I have an error: "20599 Cannot Open SQL Server"

This is the code in VB
repImprime.ReportFileName = gsRuta & "ComprasBPCS.rpt"

repImprime.Connect = "DSN = Compras;UID = " & gsCodUsr & ";PWD =" & sClave & " ;DSQ =Compras" 'i use this connection using ODBC but i use directly connection to database too and is the same problem
sql = "SELECT * "
sql = sql & " From Compras.dbo.VComprasBPCS Compras"
sql = sql & " Where Compras.Proveedor = '" & sProveedorBPCS & "'"
sql = sql & " Order By Compras.Orden ASC"

repImprime.SQLQuery = sql
repImprime.Destination = 0 'see to window
repImprime.WindowMaxButton = True
repImprime.Action = 1 'Error!!!!!.

Could you Help me pleassssseeeee!!!!

Open A Report (Crystal Report 7.0) From VB6
Hi, people!
My name is Ana and I really need to open a report designed in Seagate Crystal Reports 7.0 from Visual Basic 6.0.
I´m looking for the following DLLs "Cpeaut32.dll e Craxdrt.dll".
I´ve read some articles and they talk about the RDC Atomation Server.
PLEASE, would someone help me telling which Dlls I really need in my computer to open, print and email my reports; and send me them attached?

My e-mail address is :

Thank you very much!

Crystal Report No Open MsAccess?
Hi guys

Anybody know how to open from Crystal Report a MSAccess 2000 because anytime I want to open my tables crystal report send a message like this "IDAPI error can not locate ODAPIxx.DLL" then another windows say "Error recognizing file". So is not possibly to open my tables? Anybody had the same error before? What should I do?

I will appreciate any help about his problem.

Thanks and have a nice day everyone.

Open Crystal Report With A Where Clause
I have a Crystal rport that is connected to the right tables and it displays the data just fine with the following code.

Option Explicit

Dim CApp As New CRAXDRT.Application
Dim CReport As CRAXDRT.Report

Private Sub Form_Load()
Set CReport = CApp.OpenReport("P:Crysta~1ToDoList.rpt")
CRViewer1.ReportSource = CReport
CReport.Database.Tables(1).SetLogOnInfo "Titus", "Problem Tracking", "Titus", "password"
CRViewer1.Zoom 100
End Sub

What I want to be able to do, is open this report for specific employees using a where clause that keys on EmpID.

Anyone have any ideas?


Using VB6 To Open Crystal Report And Export It To Pdf
I wrote a script to query up about 50 ids.  Loop thru them and open up the crystal report and pass the ids then export it to pdf format.

I have 2 questions.
1.  Instead of doing the below statements each time is it possible to do a refresh?
    Set Report = crxApplication.OpenReport("test.rpt", 1)
    Set Report = Nothing
    Set crxApplication = Nothing

2.  Sometimes VB closes after it attempts to export. Any ideas?  This occurs just before I set the report = Nothing.  

Need Help!! Urgent. Can't Open Crystal Report In VB6
Hi All,

    I am newbies in integration of Crystal Report 8.5 with VB6 application.

Private Sub Command1_Click()
End Sub

CR is Crystal Report Control.

When i run it, it will prompt me to set the Parameter for crystal Report as usual. After parameter has been set, the report is gone after few milisecond.

Can anyone help me on that?


Crystal Report , Server Has Not Been Opened
hi, when viewing a report (crystal report 8.5) from visual basic i get "server has not been opened", this is becasue i removed the "save data with report" checkbox in the "file" menu because i want the data to be up-to-date when viewing the report.

Note: i am connecting to "Access DB" through ODBC in the "control panel" and my report is logged in to the DB through the menu "Database/Log on - Log off server".

any suggestions?


VB6, Crystal Report 8.5 And SQL Server 2000
hi, i'm newbie in VB+DB+Reporting...
i wanna ask a few thing...

i've seen "most" of other post that has similliar problem but none has solve my problem

ok.. i'm using VB6, CR8.5, and SQL Server2000 (i'm in learning session, so just made little DB with only 2 tables)

in VB i can connect to SQL Server via ADODB and can "browse" via RecordSet...
basicly, anything related to SQL Server has successfully "implemented".

after DB, i wanna use CR in VB (using CRViewer, not CrystalReport).. here is my code :

Dim application As New CRAXDRT.application
Dim rep As New CRAXDRT.Report

Set rep = application.OpenReport("D:wetest.rpt")
repForm.CRViewer1.ReportSource = rep
repForm.CRViewer1.Zoom (98)
repForm.Show vbModal

when the code is run, CRViewer is running, but there is no Server connection.. ("Server has not yet been opened")...

i've try other post before, like adding
application.LogOnServer, but i don't know what should i type in "pDLLName".
and/or use ADODB as rep.database.setdatasource *adodb rs* but still can't connect...

but when i save my "wetest.rpt" with "Save with data", CRViewer can display the report but can't refresh it. it says "Method Refresh in ICrystalReport4 failed"... i assume this cause by no server connection ??

ok, maybe its stupid question, but what kind of compenent/reference used if i want to use Crystal Report "perfectly" ??

anyone can help me ?? THANKS A BUNCH!!

PS : what is "Add Crystal Report.." that everyone talking about ?? i right-click at project, but there is no "Add Crystal Report" thing. And they said they use Wizard... what wizard ??

Crystal Report - Server Not Yet Opened

I'm using Microsoft Oracle ODBC connection. I had create a rpt file in the following mentioned directory with the ODBC "test". it shows properly. Now when I add the CRViewer control, the error comes "SERVER HAS NOT BEEN OPENED". How should i solve this problem??

code snippet are as follows:

Set Appn = CreateObject("CrystalRunTime.Application")
Set Appn = New CRAXDRT.Application
Set cReport = Nothing
Set cReport = Appn.OpenReport("D:ksilvbproj3Report
eport1.rpt", 1)
cReport.MorePrintEngineErrorMessages = True
cReport.EnableParameterPrompting = True
Me.CRViewer1.ReportSource = cReport

Sql Server 2000 + Crystal Report 8.5
I have a field in my database with type of Big Integer.If this field contains 10 number or less crystal report shows its data but if it contains more than 10 number it shows 0.Can you help me to solve this problem?

Helpppppp!!! About Crystal Report And SQL Server
Dear All,

I need help badly.

Question I
I always do my report design on Crystal Report. And the version that I use is Crystal Report ver. 7.0
No problem at all in design time or coding time. But one thing that getting on my nerves. My crystal doesn't want to print out to my printer.
At the first time, when I design it, and try it, it will preview on my screen, and then when I want to print it out, it's okay, my report will print out on my printer.
But, don't know why and how, yesterday, my report didn't want to print out (only preview on screen, but when I want to print it out, it didn't come out on my printer.

Can anybody help me ???

Question II
I already ask about this here, but never got the answer till now. I have a database on SQL Server (ver. 7.0). At the first time when I create the database, I already set the transaction log size into 80 MB, but now I think it's too big just for a transaction log. Now, I want to change it to 20 MB. But, an error occurs. It said that I can't set the size to the little one, I should set to the bigger one.
Could anybody tell me how to change the size into the smaller one ???

Any help will be appreciated. I need it badly. Help...
Thx in advice.

Wen Lie

Connecting Crystal Report To SQL Server
I have an application that uses a number of Crystal Reports to connect against a choice of SQL Servers.

At runtime the Crystal Reports should connect to the same Server/Database that the application is connected to, however I am having trouble producing a report if the Server I try to connect to, is not the Server that I used when designing the Crystal Report.

ie. If I design a report using Server A and try to run the report when connected to Server A, everything works fine.

However, if I try and run the same report when connected to Server B, I get the message 'SQL Server error'.

(The report I am using is nothing complex and the Databases on each Server are identical in design.)

The only thing I am trying to change is the connect property.

rptReport.Connect = "DSN=myDSN;UID=myUID;PWD=myPWD;Database=myDatabase"

If this makes sense, can anyone tell me what I am doing wrong??

Any assistance would be grately appreciated - I've been stewing on this one for about 5 months now.


CRYSTAL REPORT:server Has Not Been Opened-- HELP!!!
hi all,
i m new to crystal reports(version 8.5). and have been struggling with the basic "select Statement" to display all the details of all the records stored in the database on a button click in a vb form.

the databse is Ms Access is password protected...

each time, i try to click on the button, i invariably get this error message prompting -server has not yet been opened'

i m eagerly awaiting ur responses...
thanking in anticiapation...

Crystal Report And SQL Server 2000
Hi All,

Im doing a project in VB6 and SQL server 2000. I want some
reports in Crystal report8/11. The moment i try to run reports
im geting a error msg like unable to connect server. If any one
have some complete code for passing parameter to the crystal
repors, would be greate help. Please remember im using SQL
server 2000 as back end layer.

Or, if any body let me know how to create report with specific
parameter in vb without data environment.

I need these very urgently.

thanks in advance.


SQL Server & Oracle In The Same Crystal Report
I've got to re-design some reports. Currently they are all going against
a sql server database. However, starting this November some of the data
will live in an Oracle datasource with the remainder staying in the departmental
sql server datasource. According to business objects/crystal it is
not recommended to do the join in the report:

I've got several ideas on how to do this:
1) Create a .NET wrapper and pass data from the vb6 application, join the data in the wrapper
     using a data table and return an ADO recordset that can be passed to crystal. I've already
     written a .NET com wrapper to read some JAVA (our blessed language for talking to the data store) web-services
     and pass (via VCOM interop) back to the vb6 program.
2) Re-write the reports to use sub-reports for the Oracle portion. I would need to get direct database
     access for this. I can get access to the Oracle package through iSQL or TOAD -
     don't know if this works within crystal.

Any ideas which would be the best way to go about this? I'm part of a pilot team re-engineering
some applications and want to set some standards on how we should approach this in the future.

jim b

"Sometimes when I reflect back on all the beer I drink I feel ashamed. Then I look into the glass and think about the workers in the brewery and all of their hopes and dreams. If I didn't drink this beer, they might be out of work and their dreams would be shattered. Then I say to myself, "It is better that I drink this beer and let their dreams come true than be selfish and worry about my liver." - ~ Jack Handy

Logon To SQL Server Using VB In Crystal Report
I am using SQL server, crystal report 9 and VB 6 to make a report program.
Now, I need to Logon to the server in the crystal report viewer using VB6.

Below is my current code
Code:Dim crystalApp As CRAXDRT.Application
Dim CRReport As CRAXDRT.Report
Set crystalApp = New CRAXDRT.Application
Set CRReport = crystalApp.OpenReport("Q:IT DeptReportProgramSalesReport.rpt")
frmGenReport.CRViewer.ReportSource = CRReport
frmGenReport.CRViewer.Zoom 100
Set crystalApp = Nothing
Set CRReport = Nothing
Can I pass the logon information to the crystal report viewer?
What should I add?

Edited by - ustreddog on 5/4/2004 8:06:40 PM

Crystal Report - Server Yet Not Opened
I have made application in VB6 with Crystal report8.2. The database is MS-Access. I dont want to set DSN so i used connection string in my coding. connection String is like this:
accessconnect = "DRIVER={Microsoft Access Driver (*.mdb)};" & _
                   "DBQ=sarvayogam.MDB;" & _
                   "DefaultDir=" & App.Path & ";" & _

    Set con = New ADODB.Connection
        con.ConnectionString = accessconnect

For VB coding that works fine. but In report coding I have written one line:

       CRXReport.Database.LogOnServer "pdsodbc.dll", "Kids", " ", " ", " " where Kids is

the DSN name i set from Start->setting->control panel ->ODBC Data Source(32-bit).

but if i install software on the client machine without DSN i get an error:

"Server yet not opened"

can there is any way by which at the time of installation of the software only, DSN is set automatically? or what can i do at the time of package development so that customer need not require to set DSN explicitely to use my software. please help.

How To Connect With Server With Crystal Report
I've got a prog in which i'm using Crystal Report (CRAXRT).I had to design the used reports with ADO in CR7. In VB I will connect the tables this way:

for i = 1 to report.database.tables.count
report.database.table(i).SetLogOnInfo ConnectionString, DB,User,Password
next i


If I do so and run my prog i've got the error message: "Server not connect/opened? yet"
Can anyone tell me how i can open the server from my VB prog?



Connection With Server/ Crystal Report
I had to chang the database driver in my CR-Report from ODBC to ADO /OLEDB for SQL.
Now, if i run my prog, which loads reports dynamically during runtime in a CRViewer, i get following error Message: No connection to server exists.
But if I add my SourceCode following line:

m_report.database.logonserver "pdsmon.dll" , "m_server"

i've got the same Error Message with following error number: -2147192184

Can anyone tell me want i have done wrong?

Thanks in advance


Crystal Report 8.5 With SQL Server 7.0 :Connecting...
Hi Babu,
I am using Crystal Report 8.5 to design my report . I connect to database SQL Server 7.0. But I want to write a code in VB6 to connect Crystal Report to SQL Server so that I can run my application on another PC. Please give me your code. Thank you very much!

Crystal Report Is Not Refreshing For Another Server
i am using this connetion,
"cr.Connect = "ODBC;Driver={SQL Server};UID=user;PWD=pwd;DSQ=datatabase;Data Source=server"
but when ever i changed the server datasource from the vb app, it gives me "Database error:
general SQL Server error,check messages from the sql server". both servers have the same database
please help me it's urgent
thanks saadia


Open Crystal Report File From VB Automatically.
I've been trying to figure out a way to create a VB program that will automatically open a Crystal Report file when I click on that file from Windows Explorer. What I did was make a simple form with a Crystal Report Control on it. Then I associated the *.rpt file type with that program so that when I click on that file type, Windows will launch my program to try and open that Crystal Report file. I figure it must be some kind of DDE solution, I think. It can't be that difficult of a thing to do. I just don't know what I'm doing wrong.

Mario Giannone

Open Crystal Report File From VB Automatically.
I've been trying to figure out a way to create a VB program that will automatically open a Crystal Report file when I click on that file from Windows Explorer. What I did was make a simple form with a Crystal Report Control on it. Then I associated the *.rpt file type with that program so that when I click on that file type, Windows will launch my program to try and open that Crystal Report file. I figure it must be some kind of DDE solution, I think. It can't be that difficult of a thing to do. I just don't know what I'm doing wrong.

Mario Giannone

Open Crystal Report In A VB6 Activex Control

I've created an ActiveX control in VB6 and now I want to include un CR in it.
I can add the CR Viewer Control component but I have a message when I want to add the CR Control component (thread vs multithread).
I think that I can't open a CR in an OCX but I would like someone to confirm that and explain why. AND so, what can I do?

Thank you.

Refrencing 2 Server Table From A Sp For Crystal Report?
Hi, all.
My Comp's Sales Crystal Report needs a stored procedure that have to reference more than 2 tables from different Server..
like following

(ReportSALES : comes from PPP server and
I passed Login info to Crystal Report for PPP server)
Crystal Report generates err..
AS I think, it gives err.. since Crystal Report knows only One Server's login info..

Is it possible? If so, how can I do it?

Thank you all...

Crystal Report Viewer Err - Server Has Not Yet Opened
Hi all.
I'm using the Crystal Reports Viewer in VB 6 with CR I've got the object installed and opening a report but I am having difficulty refreshing the report. When I attempt a refresh, I need to log on to the server to get the data out but do not understand the arguments for the
LogOnServer method (if this is even what I'm supposed to use). Particularly the pDllName but the rest are kind of vague as well.
If there is a better method, feel free to debunk my current effort since I am not certain of the servername and such.

here is my code.

Public Appn As CRAXDRT.Application
Public cReport As CRAXDRT.Report

Private Sub Form_Load()

Set Appn = CreateObject("CrystalRunTime.Application")
Set cReport = Appn.OpenReport("C:Program FilesDisplay BoardPmWorkOrder.rpt")

Appn.LogOnServer "p2ssql.dll", "T01App02", "Maximo", "myID", "myPass"


cReport.RecordSelectionFormula = "{WORKORDER.WOEQ9} like 'T181' and {WORKORDER.SUPERVISOR} = 'PCC' and not ({WORKORDER.STATUS} in ['COMP', 'CLOSE', 'CAN'])"

CRViewer1.ReportSource = cReport

end sub

Also, I've started getting an error telling me that pdssql.dll can't be found. I'm looking straight at the code and it says p2ssql.dll. Why is it fudging the name when it looks for it?
Thanks all

Crystal Report - Unable To Connect To Server
Can any one help me.

I am using Access 2000 Database for my Bill Application (Visual Basic 6 ).

I have created a Report in Crystal Report for Visual Basic (Version 4.6). I want to run this report using VB.

But I am unable to run the report. It is givin error (Unable to connect).

Please Help Me.

How To Connect Crystal Report Through Two Server In My Vb Project
hi all
i'm using vb and calling my cystal report in the project .in crystal report two databases are there with different servers.but its not connecting .i've made ADODB connection globally i.e
option Explicit
Global CN1 As ADODB.Connection
Global CN2 As ADODB.Connection
Public Sub connecttootherdatabase()
Set CN1 = New ADODB.Connection
CN1.Open ("Provider=SQLOLEDB.1;Password=rptuser;Persist Security Info=True;User ID=rptuser;Initial Catalog=SDS;Data Source=myIP1")
Set CN2 = New ADODB.Connection

CN2.Open ("Provider=SQLOLEDB.1;Password=scala;Persist Security Info=True;User ID=scala;Initial Catalog=scalaDB;Data Source=muIP2")
End Sub

and in the form level i'm writing

Private Sub mnuprint_Click()

'CrystalReport1.WindowShowPrintSetupBtn = True = CN1.ConnectionString
CrystalReport1.Connect = CN2.ConnectionString
CrystalReport1.ReportFileName = App.Path & "Reportcredit2.rpt"
CrystalReport1.Action = 1
End Sub

Copyright 2005-08, All rights reserved