Search criteria with apostrophe

rbuser

Hi,

We have a problem with the report builder (10.07 - 10.08).

When we fill in a search criteria containing an apostrophe (') in the
search dialog we get the following error message (from the report
server version):

Server Error: Processing request for report Report Explorer
Database\All Reports\7456
Data Error: An exception was raised on the server: Line 38:
Incorrect syntax near =

And from report builder enterprise we get this:

An exception was raised on the server: Line 38: Incorrect syntax near
' )
AND (1=0) ORDER BY opdracht.opdrachtid, 25,
clienten.achternaam, dossier.startdatum,
werkzaamheden.da'.
Unclosed quotation mark before the character string ' )
AND (1=0) ORDER BY opdracht.opdrachtid, 25,
clienten.achternaam, dossier.startdatum,
werkzaamheden.datum'.

I don't know if anyone has ever reported this?
Is there a fix for it?

Thankx,
Chantal

nicocizik

Hi Chantal,

Which database and connectivity are you currently using? Are you able to
successfully run the query in question without ReportBuilder and get the
proper result set?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Data abstract met SQL server 2000...

To use an apostrophe in SQL you must write 2 of them.
I can run the query with the query analyser, but then I'm going to
write it "right"...what the report builder doens't do...

If I search on [Employee name = Hello's ] it crashes but if I do
[Employee name = Hello''s] it works, the SQL statement become
select ... where employeename = 'Hello''s'

If I only use one apostrophe I always get an error message that the
sql statement canno't be built with Incorrect syntax near ....

I would expect the given criteria when searching on a text field to be
automatically formatted, that I don't have to explain to the users
that when they search for O'Malley they have to write O''Malley...

Is this something all Report Builder users get of related to our SQL
or ...?

Thankx,

Chantal

On Tue, 27 May 2008 07:22:36 -0600, "Nico Cizik \(Digital Metaphors\)"

nicocizik

Hi Chantal,

There is now a patch available for RB 10.08 that fixes this issue. Send an
email to support@digital-metaphors.com requesting the patch and we'll send
it to you asap.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

ThankX!
Patch received and installed, works fine!

Chantal

On Thu, 29 May 2008 09:43:27 -0600, "Nico Cizik \(Digital Metaphors\)"