Apostrophe in parameter

[LadyJAG]

Hi Folks,

I'm using CR 8.5 and a Sybase 12 database. I am using a stored proc to return data to the report. One of the parameters for the report is a string which is a company name. I am trying to run a report for a company called: Marketing D'Energie HQ Inc.

The apostrophe is screwing up the report so that it isn't returning any data. Any ideas on how to fix this?

Thanks,
Jackie

 

[sim133]

If you selecting the company name is the record selection
company name = "Marketing D"+"'"+"Energie HQ Inc" or you may need to use the left and similar function..

 

[LadyJAG]

Tried that, it doesn't work, says failed to open a rowset.

 

[AdHoc]

How about using the Replace function in your record selection formula on both your data field and your parameter to replace all occurences of the apostrophe with another character? For example:

Replace({YourTable.CompanyName},"'","_")
= Replace({?YourParameter},"'","_")