Crystal Report bypass Single qoute

[former_member264311]

Good Day,

Please help me expert I cant show the transaction base on my parameter when the customer code has a single qoute like C_Samantha's

this is my parameter:

Reference@ Select JDT1.Ref1 From JDT1 where (JDT1.Shortname='@Customer') and ( (JDT1.BalDueDeb - JDT1.BalDueCred)<>0)

Thanks

[Former Member · Accepted solution]

Hello,

Update your parameter with following

Reference@ Select JDT1.Ref1 From JDT1 where (REPLACE(JDT1.Shortname,'''','') =REPLACE('@Customer','''','')) and ( (JDT1.BalDueDeb - JDT1.BalDueCred)<>0)

Thanks

Regards,

Engr. Taseeb Saeed

[former_member264311 · Accepted solution]

Thanks Engr. Taseeb,

But cant get the best result. All CardCode has single qoute('), there's nothing appear in select box.

Regards and Thanks

[Johan_H]

Hi,

In general it is not recommended to use single or double quotes in identifier type fields (CardCode, CardName, ItemCode, ItemName, etc). If necessary try to use accents instead: ´´. Looks the same but does not cause problems in queries, Crystal Reports, and on web pages.

Regards,

´Johan´

[Former Member]

You could try removing '

Replace(JDT1.Shortname, "'","")

Ian

[former_member264311]

Hi Ian,

How can apply that could? like

Reference@ Select JDT1.Ref1 From JDT1 where

(Replace(JDT1.Shortname, "'","") = '@Customer') and ( (JDT1.BalDueDeb - JDT1.BalDueCred)<>0)
??

Thanks

[former_member264311]

Still cant get the answer.

Thanks