Ampersand (&) in the as input parameter to Livereport

RajDon

We have Oracle 10g database.I am trying to pass a input parameter value with ampersand in it to a Livereport. The report is is not retruning any results.I tried using &&, \& and %26.Sample query:Select * from animals where name = 'Cats & Dogs'Any Ideas?

Martin_Gäckler

Hi,where is the problem? This livereportselect * from dtree where name = %1works fine with "Cats & Dogs" as input parameter.Martin