Visual Basic :: VB6 & Crystal Reports 6.0

Crystal Reports Formula
Hi!! I'm new to CR & finding it very difficult to Get into
formulas. I wud be really glad if someone could give an idea
on how to incorporate the following SQL statement on the report.

Code:
SELECT count(students.bno)
FROM Batch, Students
WHERE Batch.Bno=Students.Bno
GROUP BY Batch.bno;
I have grouped my report by Batches.
It looks like this,

Quote:

Batch Name

Student No | Student Name | ...
......
.......
......
.......

Total Student in this batch %

The formula shud come to %. I wud really appreciate any help as it
is urgent!..

Thanks!!
Mur.

Crystal Reports Formula
Hi All,

I want to create formula in Crystal report.I am very new to Crystal reports.Can Any one guide me how to Create formulas.

I want to use replace function .

Any Ideas??

Formula In Crystal Reports
In crystal report I am using sql server database, there is a value i want an another value from that fields. what i did in crystal report in formula fields i made a variable name "goldpur" the following are the command used in the formula editor

(whileprintingrecords;

shared numbervar goldpur;

goldpur := {view_invo.gld_nwt} * {view_invo.kt}/24/0.995)

view_invo.gld_nwt,view_invo.kt are both field name of the database

and the error is "A number,currency amount is required here"

Thank

Regards

Very urgent

Crystal Reports Formula Field
Hi
I got a database column which has number values like
480, 495 , 615, 630
which is equivalent to
480 = 8am (which is like 480/60=8)
495 = 8.15am
615 = 10.00am
630 = 10.15 am
i get this values from ctDEdit control, which gives numbers for time.
Now i have to show this number values as time in crystal reports. so i thought of having a formula field.
its easy to get hours and minutes from this number:
its goes like this
(615/60)=10.25
so 10 is hours
(25*60)=1500, here 15 is minutes.
can any one please help me to do this in a formula field, ie to show the time as 10.15am for number 615.
i hope im clear.
thanks
kumaarrv

Formula For Overtime In Crystal Reports
Hello,
I had a report in Crystal Reports that calculates the salaries for some employees. Which is based on a punch clock software as the report contains the punchin time and punchout time. I have managed to make a formula field as a diffdate to calculate the elapsed time between them. My question is, how can I make a formula that would do the following:
- If someone worked for more than 8 hours in one day, the time left is considered overtime. (So, say if someone stayed 11 hours it would calculate 3 hours)
Any help, suggestion, or code would be really appreciated.
Thanx in advance !

Crystal Reports Formula Captions
In VB6 via the ActiveX component you can drag'n'drop onto a form (crystal32.ocx) i can call a report and stuff a caption in against a formula field like so:

CrystalReport1.Reset
CrystalReport1.Connect = "DSN=" & SQLServer & ";" & SQLServerSetup & ";DBQ=PASS_TEMP_" & PassTempID & ";"
CrystalReport1.ReportSource = crptReport
CrystalReport1.DiscardSavedData = True
CrystalReport1.ReportFileName = REP_PATH & "Task.rpt"
CrystalReport1.SQLQuery = "Select * FROM [Task]"
CrystalReport1.ReplaceSelectionFormula ""
CrystalReport1.WindowState = crptMaximized
CrystalReport1.WindowTitle = "Pass3 Reporting"
CrystalReport1.WindowShowZoomCtl = True
CrystalReport1.WindowShowSearchBtn = True
.CrystalReport1.WindowShowRefreshBtn = True
CrystalReport1.WindowShowProgressCtls = True
CrystalReport1.WindowShowPrintSetupBtn = True
CrystalReport1.WindowShowPrintBtn = True
CrystalReport1.WindowShowNavigationCtls = True
CrystalReport1.WindowShowExportBtn = True
CrystalReport1.WindowShowCloseBtn = True
CrystalReport1.WindowShowCancelBtn = True
CrystalReport1.WindowControls = True
Call Pass3SQL_Set_department(MDIForm1.CrystalReport1)
MDIForm1.CrystalReport1.Formulas(0) = "title = " & Chr$(34) & TITLE & Chr$(34)

MDIForm1.CrystalReport1.PrintReport
MDIForm1.CrystalReport1.PageZoom (100)

Via a DLL, which I must use a different method of accessing reports:
The report runs fine, exports too. My problem is trying to set the formula caption. I have only seemed to have come across oRpt.Formulafields(1).Text Ive tried a value of 0 (zero) like the vb form version would but I get a subscript error, by setting it to 1, it does not fail, however nothing is done to the report. Am I missing something?

Thanks!

Set oApp = CreateObject("CrystalRuntime.Application")

If IsObject(oRpt) Then
Set oRpt = Nothing
End If

Set oRpt = oApp.OpenReport(ReportFileName, 1)
oRpt.MorePrintEngineErrorMessages = False
oRpt.EnableParameterPrompting = False
oRpt.DiscardSavedData

For Each Tbl In oRpt.Database.Tables
Tbl.SetLogOnInfo CrystalServerName, DBFileName, CrystalServerUID, CrystalServerPassword
Next

oRpt.SQLQueryString = SQLString

oRpt.Formulafields(1).Text = "'" & ReportTitle & "'"
'oRpt.Formulas(0) = "title = " & Chr$(34) & ReportTitle & Chr$(34)

Set ExportOptions = oRpt.ExportOptions

ExportOptions.NumberofLinesPerPage = 50
ExportOptions.FormatType = 31 'pdf
'ExportOptions.FormatType = 35 'rtf
ExportOptions.DestinationType = 1
ExportOptions.DiskFileName = OutputFileName

oRpt.Export False

Set ExportOptions = Nothing
Set oRpt = Nothing
Set oApp = Nothing

Crystal Reports Selection Formula HELP
Hi

Please bare with me as i'm new to Crystal

I intend to open a report (CR8) from a VB6 application. I have a database (Access) that holds the info I want but I only want to show records that are >= the date I enter into a text box.

Just to start with I have this as my selectionformula in Crystal which does not return any faults and if i change the date between the hash's then the report changes accordingly (from within Crystal)

DateValue ({Outgoing.Date}) >= #01/08/04#

I have deleted this formula in Crystal and am now entering it at the cr1.selectionformula property in my VB code but it does not seem to like it when i open the report telling me 'You need a number or string etc here'.

Ideally i want the hashed date to be a string in VB that i enter into text box but I though I Better try to crawl before walking.

Many Thanks
Shamus

Selection Formula In Crystal Reports
With crptCreditorsList
.ReportFileName = App.Path & "
eportscreditorslist.rpt"
.PrinterCopies = intCopies
.SelectionFormula = " {Creditors.accountnumber} BETWEEN '" &
strFirst & "' AND '" & strLast & "' "
.Action = 1
End With

WHy doesn't this Selection Formula work?Please help....

Help Crystal Reports Formula Fields????
I am using VB 6 to create a report for my application. The database I am using is Access 2003. I have created my report, and everything works perfectly. It runs and displays. Only there is one catch. As soon as I add a formula field to the report, its like the report just stops running. All I see is a blank report. As soon as I remove the formula field from the report everything works fine again. All data shows up and calculations are preformed.

This leads me to a couple possibilities. The syntax in the formula is incorrect, or I cannot add a formula field in the “Report Header a” section of a report. However I don’t believe my syntax is incorrect, and it does not make since to me why I would not be able to use a formal field anywhere in my report.

Here is what I am trying to do. I am making a report that is an Invoice. I want to be able to format the Customer Name, address, street, country etc… in the way I choose. But if it’s a company I also want the company named added. For this reason I cannot just drag the database fields on to the report because if one of the fields is empty the report will not look nice. So I made a formal field called CreateAddress. Here is the “test” code I have in that formula.

IF {tbl_customers.vc_company_name} = '' THEN

(

'blank';

)

ELSE

(

{tbl_customers.vc_company_name}

)

Now that code compiles with no errors. And the report works perfectly as long as the CreateAddress formula field is not added to the report.

Can anyone help?

Thanks in advance.

Crystal Reports Formula Problem
I am trying to use crystal reports 8.5. I have created a formula that is not working. It's very simple yet, I still can't get it to work. Below is what the formula looks like:

VB Code:
If IsNull({tblClientAddr.addAddr2}) Then {tblClientAddr.addAddr1}Else Trim({tblClientAddr.addAddr1}) & ", " & Trim({tblClientAddr.addAddr2})

I keep getting the error message:

"The result of the selection formula must be a boolean"

What am I doing wrong?

thanks,
Blake

Crystal Reports Selection Formula, SQL
How do I construct a SelectionFormula that uses a date in VB? I am using SQL Server 6.5.

My VB6 code looks like this:

Private Sub cmdPrint_Click()
Dim rptSql As String
Dim rptDate As Date

rptSql = "SELECT * FROM CheckRegister WHERE {CheckRegister.bank_statement_date}=Date('"
rptSql = rptSql & cboStatementDate.Text + "')"

CrystalReport1.SelectionFormula = rptSql
CrystalReport1.Action = 1
End Sub

I have tried many variations on this formula, such as using the string variable alone, in quotes, and using a date variable instead of a string variable, but nothing seems to work. I keep getting the error message "The remaining text does not appear to be part of the formula".

Does the date have to converted to a different format?
If any one has a solution, I would greatly appreciate it.

Crystal Reports Problem In Formula
We have encountered the problem in crystal report formula.That contains more then 254 charaters.How can i rectify when the situation like it exceeds 254 charaters without SPLITING THE FORMULA?

R.SUNDAR

Crystal Reports 6 Formula Trouble
hi,
can someone please tell me how to control crystal reports 6 formulae dynamically from code in visual basic.

this particular version of crystal reports uses a data environment addin with a form to act as the preview. I got everything else working, but cant seem to set the formula values from code.

also I cannot create a blank report, ie: a report containg only blank formula, the values will be passed from code.

any solution?

also is there any simple print preview code available.

thanks

Crystal Reports: Selection Formula Of A Subreport
in my report i have a subreport. the problem exists when i want to make a selection formula of that subreport. it says that cant find the table.

Not Able To Sum The Field In Crystal Reports 9 Formula Editor
Friends,

The below formula is not working. Please point me where iam making mistake.

=========================================
whileprintingrecords;
global numbervar tottrd;
numbervar cnttottrd;
if
(
{Admin.OTC}="001"
or
{Admin.COEN} in
["Chargeable Labour + Chargable Spares",
"Chargeable Labour + Free Spares",
"Chargeable Spares + Free Labour"]
)
then
cnttottrd := {PAYMENTS.PAIDAMT}
else
cnttottrd := 0;
tottrd := tottrd + cnttottrd

=========================================

if i change
cnttottrd := {PAYMENTS.PAIDAMT}
to
cnttottrd := 1
then its working.......

Please treat this as urgent.

Thanks & Regards
Sathyguy

Crystal Reports - Sorting A Formula Field
Hi,

I've got a formula field on my report: -

Code:
//@SumQty
Sum({SALES_VIEW.SUM_QTY}, {SALES_VIEW.AR_DESCRIPTION})
I want to sort the report using this field, but can't seem to find a way.

Is it possible to do this?

Regards

Selection Formula To Subreport: Crystal Reports
I've never used the subreport feature of Crystal report and do not know how to call up a report that has them from VB. I have a report with 3 subreports. I need to have the reports only display values for a specific date. How do I pass the selection formulas to the subreports? Is it just the normal way? I use this to select the records of the primary report, but the subreports are showing all dates....

Code:
With CrysReport
.ReportFileName = App.Path & ReportName
.DataFiles(0) = App.Path & "DB.mdb"
.SelectionFormula = Selection 'defined my selection formula elsewhere
.DiscardSavedData = True
.WindowState = crptMaximized
.Destination = crptToWindow
.Action = 1
End With

Selection Formula Problem Crystal Reports
Hi there

I want to pass a parameter from vb6 that whould return like in this example cust 1 and cust 2. How do I do this? Because the selection formula does not seem to work

CR1.ReportFileName = gsReportPath & "ActiveCust.rpt"
CR1.SelectionFormula = "{Customer.Id} in ('1' ,'2')"
CR1.PrintReport

Formula In Crystal Reports To Ignore Certain Data
I'm using Crystal reports 8.0
I have the report done up, but i want it to ignore records where the HIDNUM length is more than 7 and less than 2..

I cannot figure out how to use the crystal syntax.

I tried to create formula's etc, but they always error out.
the help files with the crystal reporst are useless..
I know this isnt' for crsytal report problems, but nobody seems to ever check the other forums.
I'ld paste the report already made, but dont' know if that would realy help anyone.

Crystal Reports Date Problem In Formula
here is my formula
{tblClaim.DateClosed} in {?StartDate} to {?EndDate} and
not isnull({tblClaim.DateClosed})

This is a SQL database. When I run a report with something like a StartDate 11/1/2002 EndDate 11/30/2002 It will not show anything closed on 11/30/2002 if I use 11/1/2002 and 12/1/2002 then it will show the 11/30/2002 information. Can anyone tell me what I need to do for the report to work correctly so that the user will see everything closed from 11/1/2002 11/30/2002 when he inserts those dates in the paramaters ?

BTW I'm using Crystal Reports 8.5 Developer edition inside VB6.

Thanks for any help.

Crystal Reports Formula Field Charting
I am not a Crystal expert, I normally would be using VB but this project requires a report written in Crystal and I have no access to VB. Any suggestions would be great.

I have a report with a field: {StartTime} that is being pulled from a subreport: ASubrpt.rpt.

I the main report I have a formula field: {RoundedTime} that rounds the time from {StartTime} in ASubrpt to the nearest minute by fives. (example 7:22 would be 7:20).

Now, I need to graph and cross tab the count of records on the change of {RoundedTime}.

Please advise. I have even tried using the Charting on Print-Time Formulas pdf from Business Objects.

If there was a way to format the StartTime field in ASubrpt to be rounded and then create the chart in the subreport then I could insert it into the main report, but I do now know if you can format the time like that w/o a formula field. And then would it even be chartable?

Thanks in advance!

Crystal Reports 9: Formula Field Alignment
I have the following Formula Field in the detail section of a report…
If IsNull({ado.AMOUNT}) = False Then
   Formula = {ado.amount}
Else
   Formula = 0.00
End if

The Horizontal Alignment for the field is set to “Right”. For some reason when ado.AMOUNT is Null the zero value of the formula is displayed to the right but it is off by one position to the left.
See Example
AMOUNT
      $0.00
      $10.00

Anyone know why this is happen?

Crystal Reports 9, Providing Formula Value Dynamically
Hi guys,

I am working with Visual Basic 6.0 and Crystal reports 9. I know it's very easy to work with formula fields from with crystal reports designer. But i want to provide formula values from within my VB code. I can give RecordSelectionFormula from within my code but i find no way to do with a 'formula' field. I have added a text box to the report for this purpose and found that it can receive a value from within VB code via SetText property of the text box, but what i want is that i wanna give a field name from a table of the database to it. Is a geek out there to help me in this regard. I'll be highly grateful.

thankyou

Crystal Reports 10 With VB6.0 -> Sorting, Grouping And Formula Fields
I have a Vb6.0 application calling crystal reports developed in 4.6. The new requirement is to get these reports in CR10 and accordingly update the VB code.

The VB code typically uses
Report1.SortFields(0) = "+{mn_contact.lastname} "
Report1.GroupCondition(2) = "GROUP3;{mn_company.customerid};ANYCHANGE;A"
Report1.SelectionFormula = {V.PROSPECT} = 0
etc etc

I require equivalent code that would be comaptible with CR10.

I tried grouping using the below code

Private Appl As New CRAXDRT.Application
Private Report As New CRAXDRT.Report
Set Report = Appl.OpenReport("C:Documents and Settingsprashanth_d01Desktopproject1Prjt1.rpt")
Report.Application.LogOnServer "crdb_oracle.dll", "vpcs.ad.infosys.com", , "MN06U", "GANESH"
Report.GroupNameFields(1).GroupNameConditionFormula = "GROUP1;{MN_COMPANY.STATE};ANYCHANGE;D"

With CrystalActiveXReportViewer1
.ReportSource = Report
.RefreshEx True
.Refresh
.Visible = True
.viewreport
End With

This returns me the report in the ascending order. The override of descending order given above in the Vb code is not being considered. The grouping in the report has it in ascending order and its returning the same.

CR gurus please help me!!

**RESOLVED**Crystal Reports Formula (PASS/FAIL)
Let's say I have a crystal report which contains the names of ten people. Each of these people has undergone five tests which result in either "PASS" or "FAIL". I am setting up my report to look like a grid. The names of each individual will go in the report header and the results of the five tests ("PASS" or "FAIL") in the details section. In order for the individual to ultimately pass they must pass all five tests. I would like to have a formula, which I would put in the report header next to the individuals name, which would result in "PASS" only if the individual passes all five tests or "FAIL" if the individual fails even one single test. Any crystal formula gurus out there?

Set Selection Formula For Subreport In Crystal Reports Using Visual Basic 6.0
Hello Experts,
I have designed a report using crystal reports 8.0.
There are subreports also included.front end is visual basic 6.0
I change the selection formula of the main report using
crystalreport.selectionformula. I am not knowing how to
set the selection formulae for the sub reports.
can any one help me .

**RESOLVED**Dynamically Change TextColor Of Formula In Crystal Reports
I have a formula which resides in a subreport. The results of this formula are either "Pass" or "Fail". I would like the textcolor for the result to be displayed in green for "Pass" and red for "Fail".

Anyone ever done something like this before. Not sure if I should be attempting to change the color in the Initialize event procedure of my main report or handling directly in the formula itself.

Error 20515
when i run my VB application the run time error 20515 appears...... the remaining text does not appear to be part of formula".... what does it mean?

Error On Formula (crystal)
hi,
I want to print city and pincode,
if pincode exist then city and pincode else print city only.
the following the code of the formula I wrote in crystal but
the problem is it prints city and pincode only when pincode is
not blank, it should also print city name even if pincode is blank,
Pls check the code

---
if {custmaster.pincode1} = "" then
{custmaster.city1}
else
{custmaster.city1} + "-" + {custmaster.pincode1}
---

thanks & regards

French Windows And Error 20515
Hi,
I created an application in VB6 and it creates reports with Crystal Reports 8.5. I installed it on an english Windows 2000 and it works fine. I installed it on a french Windows 2000 and it gives the error "20515 - Error in Formula".
Does anybody know how to solve this?

Thank you

[UNRESOLVED]Crystal Report -- Formula Error
@ Details section i used Supressed (No Drill Down) with the ff statements:

If {?ReportType} = "1" Then
{@Balance} <= 0 //All -Balance will be shown
    else

    If {?ReportType} = "2" Then
    {@Balance} >= 0 //All +Balance will be shown
        else

        If {?ReportType} = "3" Then
            {@Balance} <> 0 // 0 Balance will be shown

Now my problem lies at the Report Footer, I want to sum up the values as per condition above.
I used sum() and it ignores the condition and sums all positive and negative giving me wrong grand total. Any advice on how to sum it up according to the report type i selected?

Edited by - pasaway on 5/11/2006 1:29:49 AM

Case Select In Report, Select Expert Formula For Crystal Reports RDC
I am using Crystal 8 RDC in my VB app. I run a number of reports with paramaters which run beautifully. Typicall when I Enter a Selection formula in the Select Expert it will look something like:

{ado.Issuer} Is like {?IssuerParm}

Can anyone give me an example of how to use an If statement or a Case Select in the Select Expert of Crystal Reports RDC?

**RESOLVED**Crystal Reports Date &"&" Formula (Easy One I Think)
All I need is a simple date formula that shows the date if a date exists in the table/field. If a date has not been entered in the table/field, I would like it to show as "N/A".

Here is the formula I have tried:

if {tblPrimDls.PDLine} = "" then "N/A" else {tblPrimDls.PDLine}

tblPrimDls.PDLine is a Date/Time field in MSAccess Database.

Error I am getting:

A date is required here. Focus is then given to ""

Error On Selection Formula To Display Data On Crystal Report From SQL Database
I have a problem on selection formula to display data from SQL database on crystal report it produce an error like this:
error A number, currency amount, date, time, date-time or string is expected here

Code:

Dim Ap As New Application
Dim Rep As Report

Private Sub CRV_Click()

End Sub

Private Sub Form_Load()

Dim RepFileName
RepFileName = App.Path & "LeaveForm2.rpt"
Set Rep = Ap.OpenReport(RepFileName)
Rep.RecordSelectionFormula = "{tblLeaveApp.EmpNo}=" & ndEmpNo ->error is here
Rep.DiscardSavedData
CRV.ReportSource = Rep
CRV.ViewReport
CRV.Zoom 100

'frmcrs.Enabled = False
End Sub

Private Sub Form_Unload(Cancel As Integer)
Form6.Show
End Sub

anyone can help me....

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 Error
I'm trying to export Crystal Reports version 8.5 from vb6 but keep getting an error 'No = 20000, no error' when calling this action

CRpt.Reset
CRpt.Connect = strALWizReportsLogonInfo
CRpt.ReplaceSelectionFormula (RptSelectFormula)
CRpt.ReportFileName = "C:Export.rpt"
CRpt.PrintFileType = crptWinWord
CRpt.Destination = crptToFile
CRpt.PrintFileName = "C:Test234.doc"

CRpt.Action = 1 ' this is where it conks out

Does anyone have any idea about this? Anything has got to be more informative than the error message.

Crystal Reports 8.5 Error 70
I am using VB6, CR8.5 Developer edition, the report designer and connecting to SQL 2000 via ADO. I am trying to dynamically set the position and width of various report objects based upon the data.

The Error 70 (Permission Denied) occurs at Runtime with the following type of code:

Private Sub Section3_Format(ByVal pFormattingInfo As Object)

If Database.Tables(1).Fields(8).Value > 0 Then
S1Line.Left = Database.Tables(1).Fields(8).Value
S1Line.Right = Database.Tables(1).Fields(8).Value + Database.Tables(1).Fields(9).Value
Else
S1Line.Left = 0
S1Line.Right = 0
fldS1FltNo.Suppress = True
End If

End Sub

When trying to set the Left, Right or Suppress values the Permission Denied error occurs, despite the controls existing in the section that is currently being formatted.

Until upgrading to 8.5 some time ago many of my reports used this style of coding. In 8.5 it would not work and I was able to work around the suppress problem by using the conditional suppress on the properties sheet for the specific controls. As the Left, Right and Width properties can not be conditionally set on the properties sheet I can not adopt this method in this report.

Does anyone have a solution to this one?

John

Crystal Reports 8.5 Error
Hi people,

I'm developing a tiny ERP with VB6 and CR 8.5

I've generated an installer with the Package and Deployment Wizard

In my reports some of my sort criteria are numeric and text fields concatenations . In these cases i generate one formula field like this

({Documents.tfectra} & replicatestring("0", 2 - len(cstr({Documents.tnumreg}))) & cstr({Documents.tnumreg})

({Documents.tfectra} character 3 and {Documents.tnumreg} numeric 2)

in fact {Documents.tnumreg} is a numeric value, and when managing strings "xxx10" < "xxx2" i use the replicate string function to generate "xxx10" and "xxx02" (so "xxx02" < "xxx10")

In the developing machine everything is OK, but when I install on a user machine, I get this error when listing the report

"The number of copies is to large or not an integer"

This is because the default number format is "-55,555.56". If {Documents.tnumreg}=2
then cstr({Documents.tnumreg})="2.00" and len(cstr({Documents.tnumreg}))=4 and replicatestring("0",2-4) will throw that error

In Crystal Reports menu File-Options-Field-Number i can set the default number type to "-55556" (in the developing machine). But in user's machines what can I do? One solution is to install Crystal on every user machine, but this is not an optimal solution.

I'm using Crystal Reports Engine 8 Object Library (CRPEAuto), searching in the Object Viewer I've found this values "crRoundtoUnit", "crRoundtoMillion", etc on the "crRoundingType" Collection. But, where i can use them? There is any method in CRPEAuto objects (crwReport or crwApplication) where i can set the default numeric format to "-55556"?

Please help me...

Cognos

Crystal Reports Error
I've installed a program, made in VB, in some clients. This program has reports made in crystal reports.

In some clients it doesn't give problems, but in other clients, when I try to print a reports it gives a crystal reports erros that says "out of memory".

Does anyone know what can I do tp print the reports?

Thanks in advance.

Crystal Reports Error
Hi Team

I get an error CRPaige Library CRPaige(32).dll cannot be found

Any ideas on this?

Error With Crystal Reports
In my vb code, I am building a selection formula then setting the selectionformula property. When I try to run the report, I get an error from Crystal (#20510) which says "The program cannot add the formula name you specified". I take the exact string that causes the error and paste it into the record selection formula builder in crystal and run the report with no errors. Using vb6 with crystal 7. I feel the solution is there and I am just not seeing it. I would appreciate hearing some suggestions from anyone who has had similar problems.

Error In Crystal Reports
Hi
I am passing date parameters to crystal report my code is given below :

Code:

Private Sub Command1_Click()

CrystalReport1.ReportFileName = App.Path & "
eports
eport1.rpt"

CrystalReport1.ParameterFields(0) = "@date_to;date(2007,05,31);true"

CrystalReport1.ParameterFields(1) = "@date_from;date(2006,07,1);true"

CrystalReport1.Action = 1

End Sub

when i executes i got the message "Error Time Error '20534' " Error detected by database DLL.

can anyone help me out with it ???

I am using Crystal reports 8.5

Crystal Reports 7 Error ,vb6
Hi,,,
I have an old application runing from las two years on export unit of a company it was running fine on windows 2000 m/c but now they have change the OS and they got windows XP SP2 on all there m/c now this software was build on wondows XP In Vb6 , CR 7.
this application working fine on my laptop which have Windows XP With Cr 7 and Cr 9 , Vb6 and Dot net on it.
But when in run this application on the m/a Company have it gives the Error
"20515 Error in File c:Program filesExport SystemReportsOAReport.rpt: Error in formula <Date> 'DTSToDatetime{(OaPrintDate.OaDate)}' the remanning text dows not appear to be part of the formula."
You may see the snap of this error by clicking on this link...
http://kbitsoftware.com/TempFile/snap.JPG
Please Guide me how to solve this Error Problem...
thanks in advance
Sunil Sharma

VB6 &amp; Crystal Reports 6.0 - 20515 Error In Formula

VB6 & Crystal Reports 6.0 - 20515 Error In Formula