Visual Basic :: Crystal Reports - Physical Database Not Found

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
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 Report : 'Physical Database Not Found'
Hi

I am using Crystal Report Viewer control to display the report, when the form(containing crystal report viewer control) is load, it gives the error 'Physical database not found'. But everything runs better on my developement machine. What is the meaning of that error.

Please help

Physical Database Not Found-Crystal Report 8.5
Hi Folks,
I am developing an application in VB6.0 and using seagate crystal
report 8.5 for my reports. I am using ADO with ODBC connection
to Ms Access 2003 database. I have a laptop (IBM Thinkpad r51)
for development.
Now everything works so perfect on my Laptop. However when I
packaged the application and installed it on a second desktop
(or any other desktop) all the forms for the application works
perfect except that my reports does not open (can not be viewed
at all). The report form only opens with an error message that
says: Physical Database not found. The reports were designed
within VB6.0 using the crystal report designer and report
viewer. can any one help me with the solution to this problem.
Thanks. cheers.

Crystal Report 8.0 - Physical Database File Not Found
hi friends,
I m using crystal report 8,0 as reproting tool.
I have added new crystal report 8 and from crystal expert i have designed my crystal report from vb6 IDE.

it's working fine on my system ,
but when i make exe and install on client system it's giving me message that
"Physical database file path not found". and viewer is not displaying any data.

where m i wrong ??
Pls help me exact and more reliable method to use crystal report ??

thanx

It May seem Impossible, But Possibly We don't know the way how to reach there ????

VB/Crystal Report Error&" Physical Database Not Found&"
Hi all,
I have a VB 6.0 front end application that uses Crystal Report 8.5 and a text file as my database.

I am trying to run this application on a non-developer machine (that doesn't have MS Visual Studio, or Crystal Report).

I have setup the ODBC DSN for the text file (MS Text Driver) on the client PC,and also used Visual Studio Installer to run the VB executable from the client PC.

I placed all the dependent DLL's,MSM's and OCX's on that machine, but I get an error: "PHYSICIAL DATABASE NOT FOUND" although the VB form opens up.The crystal report doesn't open up.

Can someone please help, or let me know what I'm missing?

Thanks.

Physical Database Not Found
Did I miss anything here? I use the PDW to pack dan distribute my VB application. It uses Crystal Report for the reporting part. I'd included the p2ssql.dll, ntwdblib.dll, sscsdk80.dll and pg32conv.dll files. Few years back, I encountered the same problem and seems like the four dlls helped to solve the problem. But not anymore. When I try to open crystal report, it says Physical Database not Found.
Any idea? Anybody?
Thanks.

Physical Database Not Found
Error Message
Run-Time Error -2147192191
Physical database not found

I finished my program and installed it on a workstation.

But when I run the application, It loads but when I try to get it to connect to the SQL Server, I get the error message listed above.
Any ideas?

I know the server is up, my machine could access it fine.
Same log-in
I also was able to my an access database and import data from the SQL server into access on the client machine. I just can't the
application to work.

Thanks

he9ap00

Physical Database Not Found
I have just completed a VB 6 program which contains a number of reports. I am using Crystal Reports 8.5 and an Access 2000 database.

The program runs fine on my machine (I have Windows XP) but when I try to run it on a user machine I get the error "Physical database not found.".

I searched Crystal Report's knowledge base and their forums and the only thing that was suggested is to place the file p2soledb.dll in the Windows/System32 folder of the user machine.

Unfortunately, that didn't help. Has anyone any oyher suggestions?

Physical Database Not Found
I am using SQL 2000 and Crystal Reports 8.5 Developer and I
wrote a report that gets an ADO recordset set at runtime. There
is no problem running the query and printing out the report on
my system, but on another users system it gives a "Physical
Database Not Found" error. The app and report are located on a
network share with no security on it.

This is some of the code...

VB Code:
'ADO objects are populated and open.Set crxApp = New CRAXDRT.ApplicationSet moReport = New CRAXDRT.Report Set moReport = crxApp.OpenReport(App.Path & "MyReport.rpt", 1)moReport.Database.SetDataSource goRs, 3, 1moReport.DisplayProgressDialog = TruemoReport.PrintOut True, 1
I'm at a loss on this one.

Thanks in advance for any help.

Physical Database Not Found
hi friends,
I am developing on project in VB6/Access.
While running one report in crystal 8.5, I am having error 'physical database not found'.

In crystal help it is said that
---
The program is unable to locate either a DLL or the database. Check to make certain that the directories that hold these files are listed in the path statement.
---
but I have checked my database file. Even checked set location, it is ok. Is there any way I can get the name of the dll file missing. Is it possible with on error. How to use it. Or any other better solution.

Pls note that I am getting this error only after running my EXE file on any other machine & not mine.

Thanks in advance

Physical Database Not Found
hi to all

hoping for your assistance with this problem of mine

backend : msaccess

frontend : vb6

report utility: cyrstal report 8.5

problem: physical database not found

              after installing the project on pc with no crystal report this ERROR occured when i
              viewed the report

Physical Database Not Found
Hi,
I have developed an application using crystal report 8.5, VB 6.0 and Microsoft Access 2003....I create a setup and install to my client's computer.. It runs on Win XP, everything works properly...but when i run my report, it shows me an error "Physical Database Not Found".
Anyone can help me to solve this problem? I'm using ADODB/OLEDB in VB...
I need it urgently...
Urgently

Physical Database Not Found Error?
I know this is the wrong forum to post this message but I'm not getting any help and I need it quick. I'm using Crystal Reports and I get the error message: Physical Database not found. What could be causing this? I have my database and reports in the proper directory locations. It only happens on a certain computer to. The reports run fine my desktop computer.

Thanks,

Blake

Physical Database Not Found: Seems Like A Challenge
I have a Visual Basic 6.0 application, that
uses a SQL Server 7.0 database on the net server, and Crystal
Reports 8.5. It runs OK in my machine, but
when I install in a client machine, and try
to run the reports, the CR viewer comes up
blank and the error message "Physical
Database Not Found" is displayed. Does
anybody know of a solution for this problem?
Please Help!!

Error - Physical DataBase Not Found?
When i run my application on client system, all forms are coming correctly except the crystal reports. When i try to open the crystal reports it is giving me the error that "Physical database not found". But it run perfectly on my computer, where i deveoped the application. I am using VB6 and Crystal report8.5 and Ms-Access(xp) as my database. And i am creating the .msi file using the visual studio installer to distribute the application. While creating the .msi file i copied "craxdrt.dll, craxddrt.dll, crviewer.dll, crystl32.ocx and dao360.dll" files and when it install in client PC it is storing to their system directory. can anyone please help me to solve this problem.

&"physical Database Not Found&"
ive written an application with vb6 and CR 8.5 DE. it contains reports base on a database of employees. when i click the report button it works fine on pcs which have CR installed on them but if they dont have CR i get a message "physical database not found". im pretty sure i installed all the crx dlls in the package so i dont know what the problem is
thanks!

Crystal Reports In VB App, No Tables Found
I have a new problem with the same app since I was last here in July. Please, someone help.

I am opening a Crystal Report from VB. It opens fine. Here is the code that works so far:

Set crApp = New CRAXDRT.Application
Set crApp = CreateObject("CrystalRuntime.application")Set oCDO = CreateObject("CrystalDataObject.CrystalComObject")
Set crRpt = New CRAXDRT.Report

Set crRpt = crApp.OpenReport(DirPath & "DSR_With_Work_Tables_Batch_Prod.rpt")

crRpt.DiscardSavedData
crRpt.PaperOrientation = crLandscape

Okay, up to this point everything is cool. I had problems before with permissions and connecting to the tables, but that was solved with the following code:

For i = 1 To crRpt.Database.Tables.Count
crRpt.Database.Tables(i).SetLogOnInfo "", "", "sa", "white"
Next i

That worked beautifully - until they reloaded the Operating System on our test machine. (all of these problems, by the way, have been on the TEST machine.)

Anyway, problems started again, with the program freezing. By putting some hokey error messages in, I discoved that when it got to this line

For i = 1 To crRpt.Database.Tables.Count

that the Tables.Count was now = 0 ' (ZERO !!!! AHHHHHH!!)

So of course it couldn't set the permissions on the tables because it wasn't finding them !!! AHHHHHH !!!

The program's ODBC connectivity is working fine. It is writing calculations to that same database. I have double-checked the report to make sure that it is pointed to the right database. (And it is openig the report!) I have opened up the ODBC.dsn in notepad to make sure it's correct. I have walked through the ODBC and tested the data source.

I don't know what's wrong, and I don't know what to do. I am thinking at this point that I need to somehow point that report to the database source, but I am floundering through the different options by doing this

CrRpt.Database.SetDataSource ......

and at this point I get confused. I don't know if I am on the right track.

Please, someone help.

In Desperate Need,

lauriemc

Crystal Reports: File Not Found
hi there all trying to load a crystal report and i get this message
Quote: crystal reports viewer: file not found

this has somthing to do with the subreport that i have in it,
if i delete the subreport the report will load with no problems.

can some one help here ???

Physical Datbase Not Found???
Hi

I'm using crystalreport 8.5 I've created a report using rdc using active data connections the problem is when i'm on my design station every thing works fine but when I install the application on my test PC i get the error physical database not found I've tried everything changed the report database from ole DB to database nothing worked.

i think that there is some components that are missing in my installation but i can't pinpoint them, because when i change the location of the db in my design station it works fine, so i've roled out the possibility of wrong database location.

any one encountered this problem before???
help

BR

Error: Physical Data Not Found
hi folks,
i have developed an application using vb
6.0,crystal reports 8.5 and access 2000.I have created
an exe using package and deployement wizard.
I m using report designer control and CRviewer
to view my reports.When i install my application at my
clients machine and execute my report , it shows an
error, that Physical data noth found, OTOH all my
forms get the data from the database.I m using a
system dsn to connect to the database.
can anybody tell what the problem is ? .why is
the report not able to get data from the database.

thanks in advance
rajiv mukhi

Whats This Error ? Physical File Not Found?
hi

i have desgin one school application. and i have installed it in few systesms in the schools. in some schools its working fine, but in some systems i am getting this error : pdsodbc.dll file missed or not found. or posodbc.dll file was not found.

i have a crystal report. so when i trying to open this report its giving this error. and the application is closing .
but when i checked in my system the file was not found. but the application was executing fine.

thanks in adv.

thanks
---------------------------------------------
Srinivas.

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.

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.

Member Or Data Member Not Found/Crystal Reports
hi

have been programming in VB6 for 8+ years but haven't touched it for a few years so I'm a little rusty. Here's the situation:

I got a new (work) laptop, installed VB6, then Crystal Reports 7 then did the upgrade to 8.0. When I try to compile my program now, I get the following error: Compile Error: Member or data member not found. and it's referring to the area in red, below:

strPrintSelect = "{Invoice.Invoice_Number} = '" & gstrHoldOrdInvClaimNumber & "'"
crptSingleInvoicePrint.Database.Tables (1).SetLogOnInfo "SandGSQL_ODBC", "SandGSQL", "sa", "****"
crptSingleInvoicePrint.RecordSelectionFormula = strPrintSelect
crptSingleInvoicePrint.PaperOrientation = crLandscape
crptSingleInvoicePrint.PrinterSetup frmDocFlowDisplay.hWnd

this program has been being used for years so I know the code is okay. I don't have any "missing" references in the project, and when I go to the Object Browser, the PrinterSetup method of Report (under CRAXDRT) is there -- but it does NOT come up as an option after I type the "." after "crptSingleInvoicePrint" in the code area.

Please help! I'm pulling my hair out! Thanks in advance for your help!

(ps. I did look here but nothing I found helped )

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.

[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"

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

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.

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] 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 acordingly
I 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

Printing Database Data In Crystal Reports
I'm working on a database program and want the program to print the data just entered to several crystal reports. I need some help with the code or some directions for reading how it would be done.

How To Connect To External Database From Crystal Reports?
I'm trying to connect to external database using ODBC. I'm not too familiar with ODBC. Please help!!

Setting Database Source For Crystal Reports Through VB 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.. I've found people with similar problems, but no solution as of yet.

thanks,