Visual Basic :: Changing Database Location In Crystal Reports Ocx

Change The Database Location In Crystal Reports Sub Reports From VB During Runtime
I have several reports that were designed in Crystal Reports that have the DB location changed during runtime. When I move my database, or choose another copy of the DB that has a lot of records in it, my reports don't fire. I need to be able to Verify the database during runtime. I'm usiung VB6.0 and CrystalReports8.5 I've tried using Crystal's "Verify On Every Print" function, but I haven't had any luck. Here is the code I am using.

MyLocation = "C:mydatabase.mdb"
CRPE321.ReportFileName = "c:aptcom
eports eninfo.rpt"
CRPE321.DataFiles(0) = MyLocation
CRPE321.ParameterFields(0) = "ThisKey;" & Who.Text & ";true"
CRPE321.PrintReport

Also, does anyone know if changing the DataFiles location during runtime also effects the subreports. I don't think it does, but any input would be appreciative.

Change The Database Location In Crystal Reports Sub Reports From VB During Runtime
I've created a Report Viewer that displays Crystal Reports 8.5 reports. I have the DB location in Crystal Reports changed during runtime, but I can't get the location to change in the subreports at runtime as well. Also, by using my method of calling the reports, I can't get VB to pass any parameters to the Main report. Below is the code that I am using. I'm using VB 6.0 and CR 8.5

Dim MyNewKey
MyNewKey = Who.Text

' On Error GoTo KeepGoing

MyLocation = GetStringValue("HKEY_LOCAL_MACHINESoftwareAptCom", "AptCom DB Path")
strReportFile = "c:aptcom
eports eninfo.rpt"

Set CRReport = New CRAXDRT.Report
Set CrxApp = CreateObject("crystalruntime.application")
Set CRReport = CrxApp.OpenReport(strReportFile)
' Set CRReport.ParameterFields(0) = "ThisKey;" & MyNewKey & ";true"

' KeepGoing:

For Each dbTable In CRReport.Database.Tables
dbTable.SetLogOnInfo "", MyLocation, "", ""
dbTable.Location = MyLocation
dbTable.SetDataSource MyLocation
Next dbTable
CRReport.Database.Verify

CRReport.SQLQueryString = strSQL

frmReportViewer.Show
frmReportViewer.CRViewer1.ReportSource = CRReport
frmReportViewer.CRViewer1.ViewReport

Set CRReport = Nothing
Set CrxApp = Nothing
Set CRReport = Nothing

>>>>
I've tried using this method:

MyLocation = "C:mydatabase.mdb"
CRPE321.ReportFileName = "c:aptcom
eports eninfo.rpt"
CRPE321.DataFiles(0) = MyLocation
CRPE321.ParameterFields(0) = "ThisKey;" & Who.Text & ";true"
CRPE321.PrintReport

But, I can't get Crystal Reports to verify the database during runtime. The first way verifies the DB, but won't change the DB location of the subreports or pass parameters to the reports.

Any help would be appriciative.

Changing ODBC Driver File Location @ Run Time (Crystal Reports)
I have two reports written in Crystal Reports version 8.0 that use the MS Text ODBC driver as their database. The formatting is appropriate and the reports work fine. However, I am on a mission from my boss to see if I can change the location of the text file on the fly. For example, if it is designed to point to H:Reports and I want to change it to C:Software on the driver, how would I do that? I've explored the Set Location option, but didn't find anything helpful. It appears that the change would have to be on the DSN.

Your assistance is greatly appreciated!
Sherri

Changing Database Name And Location Runtime For Crystal Report
i m devloping one application in vb 6 and ms access , which uses 2 database. at runtime according to condition i want to fetch data from different database. i tried to changed datasource at runtime, it does not give any error but it gets data from the design time database only. my code is as below to change datasource.

Dim sql As String sql = "sElect * from Certificate"

Set adoRs = CreateObject("adodb.recordset")

adoRs.Open sql, "Provider=Microsoft.Jet.OLEDB.4.0;Password='' ;Data Source=" & App.Path
& "gramcommon.mdb;Persist Security Info=false", adOpenKeyset, adLockBatchOptimistic Me.Database.SetDataSource

adoRs adoRs.ActiveConnection Me.Database.AddADOCommand adoRs.ActiveConnection, adoRs.ActiveCommand

Me.Database.Verify Me.VerifyOnEveryPrint = True

pl. help me, if this way or any other way to change database of crystal report with .dsr file exten.
if possible pl mail me on meenxip@yahoo.com

Dynamically Setting Database Location In Crystal Reports Using Vb6
Hi

I am using vb6 as my front end, sql server and crystal reports 8. I am having a problem setting the db location through vb6.
It keeps defaulting to the location that was used when the report was created.
I've been able to solve the problem with vb6+access, vb.net+sql server, vb.net+access.

Changing The Database Path For Crystal Reports
VB 6 Enterprise; OS = Windows XP Professional; Crystal Reports XI Developer Edition

Code:
.
.
.
Set craxreport = craxapp.OpenReport(App.Path & "" & ReportName)
ElseIf ReportName = "ConsolidatedBuyListUpdate.rpt" Then
Set craxreport = craxapp.OpenReport(App.Path & "" & ReportName)
End If
craxreport.DiscardSavedData
CrystalActiveXReportViewer1.Refresh
Call CrystalActiveXReportViewer1_RefreshButtonClicked(True)
CrystalActiveXReportViewer1.ReportSource = craxreport
CrystalActiveXReportViewer1.ViewReport
Set craxreport = Nothing
Thae above is an extract of code I use to call Crystal Reports from a VB 6 application.

My question is: Via VB code, how do I change the path (location) of the database?

When I coded the application, the database, and the CR Design, I put them in a directory called "c:CustomerX". Now I am going to use the VB Product and Deployment Wizard to create my distribution disk. I want the location to be variable. I know this code is NOT correct but I would like it to be something like this:

Code:
cr1.databaselocation = APP.PATH & "BOM.mdb"
Thanks,
Sam

Crystal Reports - Changing The Data Source Or Database. - Urgent
How do I change the data source or database in a Crystal Report - version 4.6.1? (not via VB but in crystal reports itself)

ie
I have made a report using server1 and db1, but now want to change it to server2 db2

In later versions of Crystal this can be done easily, but I do not know how to do it in this version (version that came out with VB5)

Thanks
Natya

Crystal Not Finding New Database Location
I am using Crystal Reports 8 in my VB6 program for reporting. The Crstal Report Viewer control and Activex run time library.

I use the following code to change the database location - however I am still printing from the databse where the report was designed (in other words the loaction doesn't appear to be changing. Any ideas?

'open the main database recordset
rs.Open rSql, connDB, adOpenKeyset, adLockOptimistic, adCmdText
While rs.EOF = False
CrxRpt.Database.SetDataSource rs
rs.MoveNext
Wend

Set Database Location In Crystal Report
In crystal report version 6.0, in the menu Database -> Set Location, I can change the Table name from [DatabaseName].[TableName] to [TableName], and so the report is still work when I point the ODBC to another Database name with same structure.

But would anyone know where of this command in version XI, I don't know how to set it in the menu Database -> Set Datasource Location

Regards
Thomas

Database Location In Crystal Report Designer
Hi

I am using crystal report designer in vb 6. During the creation of report i am giving the path of access database "C: est.mdb"

but after i run my project on another computer, the report gives error

"database not found at location c: est.mdb".

how can i set the path of database through Vb code so that at all computers, where i install my project, report designer should consider the application path for the mdb database.

Crystal Report Database Location Question
VB 6; Crystal Reports XI - Developers Edition

First of all, I am a novice with Crytal Reports. I need to move the database (MS Access) from it's current directory on the "C" drive to a server.

In the CR Design, under Set Database Location, I pointed CR to:

Code:
C:Program FilesBOMom.mdb
This worked fine but now the database needs to be moved to a server. The server address is;

Code:
\10.2.3.4POTrackingPOTrackingBOM.mdb
How do I set the database location on my system to a non-existing location? I want to create the VB executable and copy the rpt's so that I can load it on the customer's system.

Thanks,
Sam

Crystal Report Change The Location Of Database
hi

My name is prince. I have one problem with Crystal report .
we are doing one application using VB and SQlserver 2000, in that we are dynamically creating the database and in the time of logging configure the DSN using SQLConfigDatasourse API.

but the problem is Crystal report not get updating. it willgive the value from the database when we connected at design time.

plz give a better solution.

Crystal Reports Changing Graphics
Hi folks!

I'm trying to look online on how to change a bunch of graphics in a Crystal Reports file during runtime.

I have 8 pictures in my report being used as a placeholder. I would like to change these pictures to something else during runtime.

Does anybody know how to do this?

-xmen64

Setting The Database Location For Crystal Report Through Code
Hello everyone,

I have a Crystal Report which is viewed through a Crystal Report viewer. I'm using Crystal Reports for Visual Studio .NET. I have not been able to figure out how to set the location of the database from VB code.

My code looks something like this... with most of the stuff you don't need to see ignored.

[...]

Dim theReport As New rptImmunizationAll
Dim theSelectFormula as String

[...]

theReport.RecordSelectionFormula = theSelectFormula
frmTheReportViewer.ShowReport(theReport)

... and in my frmTheReportViewer, my code is such:

Public Function ShowReport(ByVal report_in As Object) As Boolean

crvViewer.ReportSource = report_in
Me.ShowDialog()

End Function

crvViewer is a Crystal Reports viewer control in VB.NET

thanks,

How To Change Database Location Of Crystal Report At Run Time.
How to change database Location of Crystal Report at run time.

Crystal Reports- I Need Help Running Reports With A Shared Database.
I am trying to figure out how to use a shared database in crystal reports. I have it set up for my application were I use: App.Path +
"databaseWMdbase.mdb" But in crystal reports it makes you use a drive name. I am trying to use the UNC but when I run it on the computer without the physical database it tells me Database not found... is there a way to set the Location of the database in the form load like you do with ADO? Any help or Ideas would be great.

Changing Report Orientation ; VB6 And Crystal Reports
Hello,

I am using Crystal Report Control (crystl32.ocx) in my VB application. I am able to change printers, but cannot change orientation (shifting from landscape to portrait and vice-versa). How can I change the orientation at runtime? Below is the sample code I have so far.

Please help!

Thanks!

=========================================
Private Sub Command1_Click()

Dim X As Printer

Me.CrystalReport1.ReportFileName = App.Path & "AlertTest.rpt"

For Each X In Printers
If X.DeviceName = "\SCGI_RASHP LaserJet 2200 Series PCL 6" Then

Me.CrystalReport1.PrinterDriver = X.DriverName
Me.CrystalReport1.PrinterName = X.DeviceName
Me.CrystalReport1.PrinterPort = X.Port

Exit For
End If
Next

Me.CrystalReport1.Destination = crptToPrinter
Me.CrystalReport1.Action = 1

Set X = Nothing

End Sub

Changing Printers And Printing Crystal Reports
Hello,

I am trying to print a crystal report in VB6. I used the Crystal Report control and tested it as such:

Private Sub Command1_Click()

Me.CrystalReport1.ReportFileName = "c:AlertTest.rpt"
Me.CrystalReport1.PrinterName = "\Printer1HP LaserJet 2200 Series PCL 6"
Me.CrystalReport1.Destination = crptToPrinter
Me.CrystalReport1.MarginLeft = 1
Me.CrystalReport1.Action = 1

End Sub

Private Sub Command2_Click()
Me.CrystalReport1.ReportFileName = "c:AlertTest.rpt"
Me.CrystalReport1.PrinterName = "\Printer2Hewlett Packard LaserJet 6L"
Me.CrystalReport1.Destination = crptToPrinter
Me.CrystalReport1.MarginLeft = 1
Me.CrystalReport1.Action = 1

End Sub

The problem is, whatever button I click, it prints to the default printer that I have set in my report. What could be the problem? I want the user to be able to select a specified printer and use that printer in printing his report. Please help.

Thanks!

Crystal Reports: Changing Titles And Views
Beginning with Crystal Reports 8.5 and I have a couple basic questions (that I can't find) : IN VB 6.0 I am using the Active X RDC and displaying reports with the Crystal Report Viewer.

1.) How do you add a Report Title and change it at runtime? I want it to display on every page. (When I add one it will not display)

2.) How do you maximize the report when it opens? IE by default every time it opens in the CR Viewer it opens with a view of 47% I want it to open at 75% or at Page Width.

Changing Print Orientation ; VB6 And Crystal Reports
Hello,

   I am using Crystal Report Control (crystl32.ocx) in my VB application. I am able to change printers, but cannot change orientation (shifting from landscape to portrait and vice-versa). How can I change the orientation at runtime? Below is the sample code I have so far.

   Please help!

Thanks!

Code:
Private Sub Command1_Click()

    Dim X As Printer

    Me.CrystalReport1.ReportFileName = App.Path & "AlertTest.rpt"

    For Each X In Printers
       If X.DeviceName = "\SCGI_RASHP LaserJet 2200 Series PCL 6" Then

          Me.CrystalReport1.PrinterDriver = X.DriverName
          Me.CrystalReport1.PrinterName = X.DeviceName
          Me.CrystalReport1.PrinterPort = X.Port

          Exit For
       End If
    Next

    Me.CrystalReport1.Destination = crptToPrinter
    Me.CrystalReport1.Action = 1

    Set X = Nothing

End Sub

Changing Printers And Printing Crystal Reports
Hello,

   I am trying to print a crystal report in VB6. I used the Crystal Report control and tested it as such:

Code:
Private Sub Command1_Click()

    Me.CrystalReport1.ReportFileName = "c:AlertTest.rpt"
    Me.CrystalReport1.PrinterName = "\Printer1HP LaserJet 2200 Series PCL 6"
    Me.CrystalReport1.Destination = crptToPrinter
    Me.CrystalReport1.MarginLeft = 1
    Me.CrystalReport1.Action = 1

End Sub

Private Sub Command2_Click()
    Me.CrystalReport1.ReportFileName = "c:AlertTest.rpt"
    Me.CrystalReport1.PrinterName = "\Printer2Hewlett Packard LaserJet 6L"
    Me.CrystalReport1.Destination = crptToPrinter
    Me.CrystalReport1.MarginLeft = 1
    Me.CrystalReport1.Action = 1

End Sub

The problem is, whatever button I click, it prints to the default printer that I have set in my report. What could be the problem? I want the user to be able to select a specified printer and use that printer in printing his report. Please help.

Thanks!

Changing Data Source Of Crystal Reports At Runtime
hi ,
i am using crystal reports to display some data.
the data which is to be displayed comes from different database tables depending on the users selection.
i am using visual basic 6 to provide selection options to the user.
how can i change the datasource of the crystal reports at runtime..
initially i have build my report using table a. suppose the user wishes to see data from table b then he should be able to do that.. tables a and b have the same structure...

i tried collecting the data from table b in a adodb recordset and
then set the datasource property of the report to point to this recordset. but the report is not displaying any data...

following is the code which i tried and was unsuccessful...
objRec1 is an adodb recordset and crAnalysisReport is my analysis report..

Set objRec1 = objConnmbtemp.Execute("select * from tableb")
crAnalysisReport.Database.SetDataSource objRec1, 3, 1

Crystal Reports: Changing Of LogOnInfo Doesn't Takes Affect
Hi,
I've got a programm in which i can call Reports. Sometimes the specification of the ODBC-Datasource are different from designing to the running system (Database Name, ServerName, Different ODBC-Datasource name and so on).
When i originally created the program with Crystal Reports 8 i've used that piece of code to change the LogOn Informations:

Code:

For Each spTable In m_rpt.Database.Tables
spTable.SetLogOnInfo m_strDSN, , m_strUser, m_strPassword
next

Now I've got complains that no new LogOn-Informations are used and the report still trys to use the original Informations of the designing.
I've seen that the SetLogOnInfo Method is deprecated in Crystal Reports 9. So I've tried to make it this way:

Code:

Set crProperty = spTable.ConnectionProperties("DSN")
crProperty.Value = m_strDSN

Set crProperty = spTable.ConnectionProperties("User ID")
crProperty.Value = m_strUser

Set crProperty = spTable.ConnectionProperties("Password")
crProperty.Value = m_strPassword

But this took also no effect

To make it more clearly, here's an example:
Imagine I've create a report which uses the DSN MYDSN. MYDSN ponts to the Database Database1. Now I shipp my prog and the report to a customer. The customer also got DSN MYDSN. But this DSN point the the Database Database2. If i tries to call the report within my programm the report still tries to connect Database1.

Does anyone got an idea how i can resolve this problem?

Thanks in Advance

Akademos

CrystalReport.Net : Changing Database Name For Integrated Security Reports
Hi guys,

I have a .net application that displays various Crystal reports. I m using SQL Server 2000. All the reports are connected to db with ole db sql provider and with integrated security, I have to change the database name at runtime.

Do you guys know in the object model of the report engine, any property to specify the integrated security.

I am using this line of code to chnage the database name for sql authnetication and it woks fine, but I have to do it for integrated security reports. Help is greatly appreciated

Regards
Emre

Crystal Reports Without A Database?
My program doesn't use a database.
I just want to create reports based on the information I have
in certain forms or files, and i want to put a picture on the report.
that picture should be loaded with loadpicture().
I cant find any kind of IDE in this version of Crystal. I just have some examples running on VB6.
if I double click a report it opens VB6 and crystal is inside, but
I cant create new reports, what happend with components?crystal presents 5 or 6 components and picture object is not present.
There is an image object, I put it on a section, but, I can't use it,
datareport1.image1 or simply image1.something is not working.
I included all the components in the project: crystal reports 8 runtime, crviewer...etc.
Does anyone have some example about it?

Thanks!
Juan.

Crystal Reports 9 Database Problem
Hello I created a Crystal Report from Access Database. And my application wored good. Now when im trying to run the report from another PC, it says that the path to Database is not valid, and is display the original datbase path.

how do i give the path of Access Database to Crystal Report in my code.

Crystal Reports: Database Error
I have installed an application on 18 machines and am having the following error on 2 of them. I am using vb6 as my front-end, Seagate Crystal for my reporting and storing the data in an MS Access Database.

When I try to run my crstal reports from either of those 2 machines I am getting the error:

SeaGate Crystal Reports: Database Error

Microsoft OLD DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified.

I then receive the message:

Server has not yet been opened.

I am confused as I am only experiencing this problem on 2 of the computers.

Any Help Appreciated.

Crystal Reports - Can You Use App.Path To Set The Database?
I just started using Crystal reports and the app I made is shared on a network. I was wondering if I could use the app.path to connect to the database or will I have to map a network drive?

I have tried to use App.Path in the Set.Location under the Database Fields.

Customers!App.Path+ "databaseWMdbase.mdb"

it gives me an error message when I try to use that...

Crystal Reports: Database Error
I'm trying to print data from my SQL 2000 DB from my VB app but when I click the command button to launch my Crystal Reports 8.5 viewer I get the following message:

Crystal Reports: Database Error

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] The column prefix 'tableName' does not match with a table name or alias name used in the query.

I click OK and get this:

Crystal Report Viewer

Error detected by database DLL.

Anybody know what these errors mean and how I go about resolving them? I have no probs navigating and viewing the data in the SQL DB through my VB app so it's not a connection error so I have no idea what's going on. If someone can help I'd appreciate it! THANKS in advance!

Getting Crystal Reports From Access Database
I want to get Crystal Reports based on a user selected date i.e adhoc query from the back-end Access database. I have used the Crystal Report Dialog component. But the reports are not giving in a date format condition. I want immediate reply.

VB6 Crystal Reports Not Rereading The Database
I have two applications VB6 using Access as the database. I have added reports using crystal Reports XI. When I preview a report - looks OK. I close the report and select the same report with different data, I receive the original data in the viewer. i.e. the report has not reread the database, just displayed the original data. I am aware of the 'save data with report' option with reports developed outside of the VB6 environment but this does not seem to be available in VB6. Can someone please assist
Thanks

Using Crystal Reports And Backing Up Database
how do you show a crystal report in VB and how can i use vb to create a backup database?

Crystal Reports - Database Change
How can I change the database of a report in run-time from VB. I use ODBC to access a SQL Server database. I change the database source of ODBC but the report query the initial database.
Thanks.

Verify Database In Crystal Reports From VB
I have several reports that were designed in Crystal Reports that have the DB location changed during runtime. When I move my database, or choose another copy of the DB that has a lot of records in it, my reports don't fire. I need to be able to Verify the database during runtime. I'm usiung VB6.0 and CrystalReports8.5 I've tried using Crystal's "Verify On Every Print" function, but I haven't had any luck. Here is the code I am using.

MyLocation = "C:mydatabase.mdb"
CRPE321.ReportFileName = "c:aptcom
eports eninfo.rpt"
CRPE321.DataFiles(0) = MyLocation
CRPE321.ParameterFields(0) = "ThisKey;" & Who.Text & ";true"
CRPE321.PrintReport

Also, does anyone know if changing the DataFiles location during runtime also effects the subreports. I don't think it does, but any input would be appreciative.

Accessing Database Using Crystal Reports 8.5
Hi,

I am developing an application using VB6, MS-Access2000 & Crystal Report 8.5. When i am password protecting my Access database, the crystal reports are not functioning properly,i.e., the reports are not displayed. I am using the RDC (Report Designer Component) in VB IDE itself. I tried using LogOnServer, but it did not work properly. Might be i didn't use it properly. Someone please help me how exactly can i do this. Any advice is welcome. Thanx.

Changing Database Path At Runtime In Crystal Report
Sir,
I am using CRViewer Control and ICRDesigner control to create/show the Crystal report. My back-end is mdb(Access) database. I want to know the code to set the database path at runtime. Could anyone help me.

Crystal Report : Changing Subreport Database Connection
how to Change main report and Subreport database server connection
and view them In CRViewer ?

thanks

[HELP] Seagate Crystal Reports: Database Error
I work with Crystal Report 7 & VB6 & Access97. After installing program in some of windows, I get the error messages as following when I want to open my report in program.

Seagate Crystal Reports: Database Error
----------------------------------------
Can not initialize OLE.

Seagate Crystal Reports: Database Error
----------------------------------------
Can not create DAO DBEngine.

Seagate Crystal Reports: Database Error
----------------------------------------
Error opening file.
File could not be opened: "Report" at file location "Report"

DataBase, Crystal Reports And Visual Basic
Hi! I work at a Software Publisher and we currently have an application developped in FileMaker. In my own, FileMaker ************************, so do the bosses think the same, since they annonced me this morning that they're looking for a new language. I first thought about VB, that's why I'm here. The application we develop is a Printing Software intended for nurseries. It consists of a Plant database with all the information about plant (including a picture file). It's pretty simple, the user browse trough the plant database, he selects the plant he want to print, select the style of signage he wants and then prints. I wanted to know, what db would be the best for text and picture file? I though of access, would there be anything better? And I thought of using crystal reports to print. Would that be a good idea? ok well, I hope I made myself clear and that you will get the point of the thread. Thank you!

PS.: Since its been a couple of years I havent been Visual Basic'ing.. should I go with Visual Basic of Visual Basic .NET !??? Thank you

Edit by reboot: Would you talk to a customer like that? Please show us the same respect.

Physical Database Not Found (Crystal Reports)
I have a report based on an Access 2000 database, used by an application written in VB6.0. In my PC (developer machine) the application and the report run ok, but when I distribute them, the report doesn't open, and I get the error "Physical database not found.".

I think it is related to files I have to distribute, but I'm not sure which are those files? Could you please help me with this?

Crystal Help said I have to look into DAO 3.5 SDK, but where could I find that?

Any help will be appreciate.
Thanks in advance

Crystal Reports - Physical Database Not Found
I recently installed crystal reports 8 replacing crystal reports designer component 6.0. After packaging my application and installing it on a client, I get "Physical database not found" when I try to print reports. I don't get this on the system that I created the application with or with the old report designer component.

Am I missing a dll or something when packaging?

Thanks in advance

Connectiong With Database Via Crystal Reports Designer In VB
Hi!

Using: CR 9
Visual Basic 6
Pervasive SQL 2000i SP3 database server

I have a visual Basic application that uses Crystal reports. Do I need to connect to Pervasice in VB manualy to refresh my report data or is there a way to have the reports connect to the database. This would probably be a lot easier because it is difined in the reports where they should connect to.
If I need to connect to it manually, what steps do I need to take in order to make everything work properly.

Any help is most welcome!!

Tanja

Crystal Reports 'database Up To Date' Alerts
I am making an app that runs a Crystal Report. When the selected report runs and if the report was made in an earlier version (currently using 9.2) these dam "verify database" msgboxes will make you click okay for each table !!!!!!

"The Database File "XXXXXXX" has changed. Proceeding to fix up the report"

My question is..... is there a way to suppress these warnings ??? Your only option is to click "ok" anyway

Thanks, your GOD like help is needed !!!!!

Patrick

Crystal Reports - Physical Database Not Found
Hi guys,

I have a VB program which access a Crystal report .rpt file. Using VB code I logon to Oracle database, and pass an SQL query. The report works fine.

I was running this VB program as a scheduled task on the server (Windows 2000). I had no problems.

Recently the server was upgraded to Windows 2003. I copied across the VB program and the crystal report file to the new server. It would not work on that server.

It generated "Invalid TLV record". I installed VBRuntime files on the server.
Now it generates VBruntime : Physical database not found error

This works perfect on my local machine.

Any ideas guys ???

[Crystal Reports] How I Can Selected My Database {unresolved}
i have student database with access
in my case if student fail he must retake the study in next semester and i will entered without deleted previous data
my table like this
ID Name /Rank /point /semester
01 Math / D / 1 /1
01 Math / C / 2 /2
01 Math / B / 3 /3
01 english / A / 4 /1
i want the resu lt in crystal report is
ID Name /Rank /point /semester
01 Math / B /3 /1
01 english / A /4 /1
can you help me?
my result like this because i want take the best point in 1 name of study of 1 student and semester is semester where the student take the study for first time

rank and point is like this
a=4,b=3,c=2,d=1,e=0
please help me
thanks

EDIT by johnminkjan -> topictitle

Edited by - albantani on 3/28/2005 7:43:18 PM

Crystal Reports - Relative Database Path
Hi,
Crystal Reports only allows us to choose the absolute path to the database. This works as long as users install the program to the default directory we give them. However, not all users install the program in the default directory. Is there a way using RDC to specify where the database (Access) is located on the machine? I've search multiple sites and forums and found nothing so far.

Thanks,
Scott

Replace Database Field In Crystal Reports
I've linked the crystal report to a database, now i need some help in manipulating the database field. For example,the field consists of "P" (stands for PASS) or "F" (stands for fail) but i want to display PASS / FAIL instead of P/F ...can someone help me on this? do i need to use a formula or something? i'm very very new to crystal reports... Thankx

emails will be welcomed. pls email to this address zijing@singnet.com.sg

Changing Database Location In Crystal Reports Ocx

Hi,I have the following problem.When I change in code the location of the database in my code and set the datafiles(0) property acordinglyI get the "error detected by database dll". Why?If I don't change the location it works fine.VB4-32 and Crystal Reports 4.5