Crystal Syntax Problem

I have created a Crystal Report with a section that needs to be suppressed when there is no data. I used an "if then else" statement using the basic syntax of Crystal on the suppress control option of a textbox.

The code is as follows:

if {GetData;1.Complaint} = "" then
formula = True
else
formula = false
end if

Most of the time it works just fine, however on occasion I get the following error:

Error in formula <Object_Visibility>.
if {GetData;1.Complaint} = "" then

Exception Target Site: []N

I am not sure what causes this error. As a note this Report is used in conjuction with Sql Server and a VB.NET application. Any help given is greatly appreciated.Make sure that the condition does not return null value|||It could return a null value. What can I do in the Crystal Report to account for that? Any help given is greatly appreciated.|||Try this

if {GetData;1.Complaint} = "" or isnull({GetData;1.Complaint}) = True then
formula = True
else
formula = false
end if|||It still gave me the same error. Not sure what to do. Any theories?sql

Crystal Reports LIcensing

Hi.

I am trying to establish which version of Crystal Reports I need to use.

I wish to use Crystal Reports within a Visual Basic 6 application. The report(s) will be viewed and printable from the application. I also need to distribute the VB6 application for 5 users.

I understand that in one version, the licensing for runtime requirements changed. I am trying to find out at which version it changed.

I really need to be able to do this with no runtime licensing requirements for the distributable DLLs, OCXs etc.

I have an inclination that it's either version 7, 8 or 8.5 ??

Can anyone please help and advise me as to which version I should be using?

Thanks in advance,
Darren

email: darren@.darrenbrook.fsnet.co.ukIn my Crystal Reports 8.5 book (one I bought from the bookstore, not the users manual), it said something about new licensing in version 8.5. I don't have the book with me right now, but from what I remember, it only involves paying royalties to Crystal if you use the embeddable designer that allows the user to create reports at runtime. I'm also pretty sure that you need to purchase the developer edition in order to distribute it to you clients.

Please keep in mind that this infomation may not be completely accurate, it's just what I remember reading. Your best bet is to contact Crystal and ask them.

Here's Crystal's website:
http://support.businessobjects.com

Crystal Reports 4.6 not working in XP

My application uses Crystal Reports 4.6 & Visual Basic 6.0. The database is in MS Access 97.

It works on Windows 95, 98, NT 4.0, 2000. My users just upgraded to Windows XP.
But, in Windows XP the report is not shown and no error with .PrintReport(). When I tried with .Action = 1, it shows 2 errors.

1)
Runtime error '5':
Invalid procedure call or argument

2)
Error Number: 20535
Unable to connect: incorrect session parameters.

And the application terminates!

This is the code.

With crwReport
.Destination = crptToWindow
.WindowTitle = "Bill"
.WindowState = crptMaximized
.ReportFileName = "D:\reports\Bill.rpt"
.DataFiles(0) = "D:\client.mdb"
.Action = 1
End With

I have tried creating setup from Package & Deployment Wizard and Visual Studio Installer 1.1 but neither work for Crystal Reports...

I tried to install Crystal Reports 4.6 on user's machine but still it is not working!

The only ultimate solution I got is to install Visual Studio 6.0 on user's machine. Heck, thats a lame way... and my client can't afford it.

Isn't there any other better way??i had the same problem and i was able to get it to work by doing this: download the update here: http://www.randem.com/support.html
Automatic OS Updater for MDAC/JET/DCOM

this is the update that the computer needs for access runtime files and vb files... i installed this on the other xp computer and it fixxed the errors i was havin openin the reports... i stuggld with this for a long time
hope this works...

Crystal Reports

Hello out there,

I have a problem with crystal reports. I have added the report from VB6. This is the code in the Form Section

Visual Basic 6 Code:
------------
Dim Report As New CrystalReport1

Private Sub Form_Load()
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
Screen.MousePointer = vbDefault

strSelectString = "{M_Receipt.PayMtd} = 'Credit Card' "

CrystalReport1.RecordSelectionFormula = strSelectString

End Sub
------------
end of Visual Basic 6 Code

This code still gives me all the records from the database. I connected to the DSN in the Crytal report itself using Database-->Set Location, then pointing to my DSN.(Connecting to an Access Database)

How can i resolve this so that only the records i want are displayed.

ThanksMillions in advance[ Moved to Crytal Report forum]|||Add parameters in the said crystal report, use these parameters in the Report Selection option.

Pass values to the crystal report from the VB script.

Sample way of passing parameters is as below :

For eg., the parameter name is vPayMtd.

CrystalReport1.Parameterfields(0) = 'vPayMtd;' & 'Credit Card' & ';true'

Here if want to pass a value in the condition of comparision
of vPayMtd = 'Credit Card', above notation can be used.

Try with this.|||Hi Friends,

m new to crystal reports and facing some problems regarding the same

i made one rpt in crystal rpts.
and now want to call it in vb 6

the coding which i have used is as follows.

frmemp.crystalreport1.connect = "dsn,uid,pwd"
frmemp.crystalreport1.reportfilename = "c:\programe files\..\empdtl.rpt"
frmemp.crystalreport1.action = 1

m i missing out something,

please guide me for this query.

regards,
kalpana

Crystal report setup using Package and Deployment Wizard of VB6.0

Hi
I am working on Visual Basic 6.0 and I've use crystal report 9.2 for report printnig.
But when I made the setup using Package and Deployment Wizard.
While installing the setup in the client's machine setup gives error -
An error occured while registering these files...
crtslv.dll
exportModeller.dll
filedialog.dll
crqe.dll

Due to which my report does not show up. when I call my report system gives error - "Load report failed"

Please help.

PuneetInclude these dlls while making setup.|||I've tried that. I've addid these file while making setup but invane its still not working.

Actually the prob is when I run setup on the win 98 machine it gives error
"An error occured while registering these files..."
even after the inclusion of these files while making the setup.

Now what should I do.|||It seems the dll is corrupted

Crystal report refresh

Hi All i'm working in crystal report 8.5 with visual basic 6. All reports are working well only problem when we open any report. coz when we open report it take much time to show data on report. mean its processing speed is very slow. i wants when i open report, with in few seconds it shows all record, but this can be huge record. mean i wants to make it more efficient, then usual.
if i convert these reports into crystal report 10 from 8.5, how it will be....... mean it will increase its efficiency or not.
plz tell me if any one knows abt it.

mushiHow many data does the table have?

Crystal Report Doubt

Dear All,

i am visual basic Programmer.But new to crystal report . I coded like below

report1.Formulas(1) = "compadd2='" & (PockAdd2) & "'" 'Place
report1.Formulas(2) = "compadd3='" & (PockAdd3) & "'" 'City
report1.Formulas(3) = "strtitle='" & (strtitle) & "'" 'Title
report1.RetrieveDataFiles
report1.Action = True

Which Shows an error "Invalid File name", While Executing the line "Report1.RetrieveDataFiles"

Have any solution for this problem.

Pls let me know

Regards

Abdul VahidTry the next :
1.- Click on Menu / Database / Verify Database
and / or
2.- Include file definition before preview report
.
Report1.DataFiles(0) = SomePath & "\Somefile.Mdb"
Report1.DataFiles(1) = SomePath1 & "\Somefile1.Mdb"

.