Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal scripts and vista

Status
Not open for further replies.

IanMac26

Programmer
Nov 16, 2007
20
NZ
Running CR XI

To run our reports our application creates a vb script. Yesterday I tried to run a script on Vista for the first time and got the error

“Basic syntax is not supported in group or record selection formula”

The line that seems to be causing the problem is

objReport.RecordSelectionFormula=”{CourierInformation.reference} = 1234 and “ & objReport.RecordSelectionFormula

The same script still works on my other computer (XP Pro)

In this case I could change the reference to a parameter and use that in the selection criteria but I have other reports where I need to concatenate the variable criteria with fixed criteria.

Cheers,
Ian


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top