Prev: MS Access Permissions Problem
Next: SQL examples
From: WernerA on 3 Jan 2007 14:16
All

Using CR XI with 2740 or 2806

If I am trying to set the
oCRreport:RecordSelectionFormula := '{SteuerRechn.Steuerjahr} = 2006 '
gives the Runtime Error "Basic syntax in recordselectionformulas not
supported"
Any ideas?
Werner

From: Geoff Chambers on 3 Jan 2007 16:37
Try this instead

oCRreport:RecordSelectionFormula := [{SteuerRechn.Steuerjahr} = 2006]

WernerA wrote:
> All
>
> Using CR XI with 2740 or 2806
>
> If I am trying to set the
> oCRreport:RecordSelectionFormula := '{SteuerRechn.Steuerjahr} = 2006 '
> gives the Runtime Error "Basic syntax in recordselectionformulas not
> supported"
> Any ideas?
> Werner

From: WernerA on 4 Jan 2007 14:23

Geoff,

Thank You
I still get the same result. May it be because I use the german version
of Crystal?
Werner

From: Geoff Chambers on 4 Jan 2007 16:58
Should work, is the field your accessing nummeric?

This works for me

[{jobcost.job} = "RESRC" and j{obcost.amount} = 1000]

where job is char
and amount is numeric

I'm using Classmate, but here's my code

METHOD Menu_File_Print(cDoc,cRecords) CLASS MyChildWindow
LOCAL oCRW AS crApplication
LOCAL oDoc AS crReport

oCRW := crApplication{}

IF !oCRW:Attach2RunningServer("CrystalRunTime.Application")
//This returns .T. so I am able to access the CRAXDRT report engine
oCRW:CreateFromProgID("CrystalRunTime.Application")
ENDIF
oDoc := oCRW:OpenReport(cDoc)
IF cRecords <> NIL
oDoc:RecordSelectionFormula := cRecords
ENDIF
oDoc:SelectPrinter(SELF:Properties:Driver,SELF:Properties:Printer,SELF:Properties:Port)
oDoc:PaperOrientation := 0
oDoc:PrintOut(TRUE)

RETURN NIL



WernerA wrote:
> Geoff,
>
> Thank You
> I still get the same result. May it be because I use the german version
> of Crystal?
> Werner

From: Michael Haensch on 5 Jan 2007 01:45
Hallo Werner,

what happens if you put this formula in Crystal in the selection editor?
Or the other way: if you build the selection in Crystal with the editor,
is it the same?

Michael


WernerA schrieb:
> All
>
> Using CR XI with 2740 or 2806
>
> If I am trying to set the
> oCRreport:RecordSelectionFormula := '{SteuerRechn.Steuerjahr} = 2006 '
> gives the Runtime Error "Basic syntax in recordselectionformulas not
> supported"
> Any ideas?
> Werner
>
 |  Next  |  Last
Pages: 1 2 3
Prev: MS Access Permissions Problem
Next: SQL examples