Visual Basic :: [HELP] Seagate Crystal Reports: Database Error

Seagate Crystal Reports And VB 6.0
Hello,

I'm using Seagate Crystal Reports 8.0 to create reports in my VB6.0 projects.
For technical reasons I reinstalled the bouth softs.
My problem:
In the menus and in the popopmenus there are no shortcuts anymore to add new reports.
In my old projects, the existing reports can still be opened and be modified but I can simply not create any new reports anymore.

Can someone please explain me where how to resolve this problem ?

Regards

Mario

Seagate Crystal Reports 8.0
Hi!
i am getting a problem with the Seagate Crystal Report Control. I want to change the paper size of the report at runtime based on the fields to be displayed in the report.
there is a property available for the crystal report control. even though i am changing the paper size the out put is set to the papersize set at design time only.
if any body has got solution for this problem please reply me.

Thank You

PAK

Seagate Crystal Reports 7.0 Printing Problems
Hi,
I am using Seagate Crystal Reports 7.0 for reporting through Visual Basic 6.0 Application. The reports are not the same on all systems. Some systems exhibit the following behavior. My reports look fine on screen but when they are printed the fields get truncated. The truncation is at the beginning and not towards the end. I was wondering if anyone could help me figure out what the problem is and how to correct it.
Thanks for your valuable time.
Tim

Setting Page Length In Seagate Crystal Reports 8
I want to set the page height in crystal report to 5.4 inches using vb 6 code how is it possible and group header to 1.56 inches

Report From Seagate Crystal 4.6.1.0 Without Database Table (only Recordset)
I am using Seagate Crystal Reports version 4.6.1.0 .
Unfortuantely my company will not purchase a newer (or better) version of the product. What I want to know is, is it possible (using this version obviously) to create a report initially from a database table and then at a later stage, instead of using the table as the datasource, use a recordset. Why I am asking is because I have many reports (+-20) that need to be written and I do not want a separate table per report. Maybe the gurus out there have a good or better solution - you guys always do...

"The answer is out there, Neo, it’s looking for you. And it will find you, if you want it to."--Trinity to Neo

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: 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!

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.

Seagate Reports Groups Grand Total
Hi,

i have calculate a formula with subtotal of a group and another database field. now i want to make grand total at last with this formula field.
thanks

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.

Seagate Crystal Report 8.5
how do i c/f a running total field to page 2 and calculate that field with the running total of page 2 as grand total please help.

Vb + Seagate Crystal Report
Hi,

I Call A Report From Vb. I Want To Check Weahter This Report Still Open Or User Close The Report. How Is It Possible?

Thanks

Seagate Crystal Report Help
hi there , i am having some problem outputting a time field from a database table in crystal report.The field box only displays a default system time on preview ,but is not able to output the time value as it is in the database .know this is a little off the mark ,but i need help anyway.pleaaasse.
Thanx in advance .
george.

How Can I Add NumberOfPages In Seagate Crystal Report.
I have developing a report in which I already have
"Page n" but I need of "Page n of totN".
Can u help me. then plz. (prefers Coding)

Query About Seagate Crystal Report(unsolved)
actually i am using seagate crystal report & i found every formulas in formula field except SUM. if it gives facility 2 add SUM function then plz let me know with detaile step by step. plz. waiting 4 reply. i want normal report that should display total of perticuler column in page footer section.

Simple Procedure For Using Seagate Crystal Report 8 In VB6
Hello Everybody

Is anybody tell me the procedure to call crystal report 8 in vb6 application with password protected MS access database without using file DSN method.

My code will not refresh the crystal report values when database is updated.

Thanks

Edited by - amolsharma20 on 10/29/2005 1:29:34 PM

How To Put Picture In Seagate Crystal Report 7 During Runtime
I need to put a picture on the report based on the user... I already have a picture on my database my problem is I dont know how to put the picture in the report based on the selected data... Please help thanks in advance

- I am using Seagate Crystal Report 7

Arnold

Create Graph With Seagate Crystal Report
Hi, can anyone teach me how to create graph in VB form by using seagate crystal report. The graph created by using data in Database. Hope explains in details steps. Thanks

Parameter Query In Seagate Crystal Report
Hi,

I have a query in Seagate Crystal Report 8.0.

I want to add two parameters in crystal report using the ' Create Parameter Field' dialog box.

Parameters are

1. startDate : I want that on running the report, default value for this parameter should be the Monday of the current week.

2. endDate : It's default value should be "Friday of the current week or today, whichever comes first."

Please suggest how to achieve this.

Thanks in advance

Ritesh

Seagate Crystal Report 8.0 Hyperlink Crreating Problem
in seagate crystal report 8.0 hyperlink of another crystal report is active but when i generate this report from vb then the link is disable do suggest me what should i do for this??

VB5 And Seagate Crystal Report Designer Component Version 7
I've been having such a problem the past week with this, so I thought I'd post to see if i can get any help. I create and export a report (RTF format) with Seagate's Report Designer Component (Version 7) through my Visual Basic 5.0 project and after I open the document (MS Word), I go to print and get this very troubling/annoying message. I've already tried setting my margins narrower through page setup on the report in VB and no luck so far.

"The margins of section 1 are outside the printable area of the page. Do you want to continue?"

Can anyone help me out with this, I really need to get this resolved for work.

Thanks so much.
- lpjennifer

Seagate/Crystal Report 7.0 Extended DayLight Saving Patches
Are there any Crystal Report 7.0 Extended DayLight saving patches ?

We have seen on the Business Objects site, it shows patches for Crystal Reports 10 & 11 but not for products earlier than CR 10.

I would appreciate if you could let us know link where we can find the Day light saving patches, as we have 100 s of reports running on crystal reports 7.0.

Thanks,

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.

Graph Report In Crystal Reports 8.5 Shows Error (Automation Error. The Object Invoked Has Disconnect
Dear All,

while calling a report containing graph from VB 6.0 I found following error,

"Automation Error. The object invoked has disconnected from its clients"

but when I install crystal reports 8.5 on client machine then the error disappears.

can anybody advice?

Best Regards,Shahzad Anwar 92-345-8237099

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 - 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...

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 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.

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