HI....everybody...
may i know, who know how to pass the string contain the single quote into the crystal report.
i'm using vb6 and crystal report 7.
my coding is as below:-

Dim HouseName as string

HouseName="David's House"

WITH CryRpt
.REPORTFILENAME="C:\Rpt_House.rpt"
.FORMULAS(0)="HouseName= ' " & HouseName & " ' "
.DISCARDSAVEDDATA=TRUE
.DESTINATION=crptToWindow
.ACTION=1
END WITH

i getting the ERROR [20515]-
"THE REMAING TEXT DOES NOT APPEAR TO BE PART OF THE FORMULAR."

Thansk for u replying.....

 

i had tried to double up the single quote. but still getting the error.

i know in SQL we need to double up the single quote in order to retrieve/get record from database.

 

my problem now is, i try to direct pass the string (contain single quote)  into the crystal report by using formulas without save the string into database and then retrieve it.

 

i had do the online research but din find any soluction yet.

 

the alternatively way that ur suggested may be i will consider it. but i have to restrict the user entering the character so that they canot enter this character ^

 

beside this, is there any soluction/suggestion to solve my problem?