CR 8.0 with MS SQL Server - database changing 
Author Message
 CR 8.0 with MS SQL Server - database changing

Hi all

I am having problems while attempting to change the name of the SQL Server
and the database name in a report.

I have developed a report and used 'Convert Database Driver' to connect to
an SQL Server (as it was ODBC previously). That works fine in the Crystal
Report itself.

However, when I have tried to put this report onto a VB form, I ran into

I have a CRViewer control on the form.
I am trying to do the following ( as suggested on the knowledge base
http://www.*-*-*.com/ )

'general section of the form
Dim Appn As New CRAXDRT.Application
Dim cReport As CRAXDRT.Report

' button click section
For i = 1 To cReport.Database.Tables.Count
        cReport.Database.Tables(1).SetLogOnInfo dbConfig.ServerName,
dbConfig.UserName, dbConfig.Password
CRView.ReportSource = cReport
However, this it seems has no effect what so ever. The report will continue
opening the database with which it was originally created. Is there any
restriction on how to go about connecting to different SQL Servers during

In addition. Is there anything that needs to be done so that the report will
not show whatever is the saved data inside it?

There's  another section that passes in the parameter (note that there's no
parameter on the report - i just alter the condition for the selection
formula), but it work at times and at other it does not. For example, the
report source was previosly ODBC which I have then converted (as mentioned
above) into SQL Server based report. With ODBC in place, the passing in of
the condition worked well, after the conversion to SQL Server, I am unable
to pass in a condition using the following code:

strSelectionFormula = "{r_RFDReceivedByDateForCustomerForwarder.RFDDate} in
Date(..."yyyy,m,d") to Date(...)"
cReport.RecordSelectionFormula = strSelectionFormula

My question is if there's any additional constraints if the driver is not
ODBC (using the System DSN) when it comes to modifications to the selection

Thanx in advance

Fri, 21 May 2004 11:49:53 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Complicated Record Handling on MS Sql server and MS Accesses Databases

2. change database name and server for cr Rep at runytime

3. CR Enterprise 8.0 - Cannot login CR console

4. Using a dll that referenced CR 8.5 files on a machine that has CR 8.0

5. Synchronizing changes between MS Access and SQL Server

6. Database DLL error when runing storeprocedure on MS SQL Server

7. Determing available database servers (MS SQL)

8. List of MS SQL Server & Oracle Databases

9. How do I connect to a ms sql server 7 access database

10. Opening split MS Access Database under Crystal 8.0

11. Dynamic change Sql Server Database

12. Changing SQL Server Databases


Powered by phpBB® Forum Software