"%" in request attribute

[Former Member]

HI: I'm working on a web application, which uses Java MVC framework, JRC, .rpt, teradata to render a crystal report in a web portal environment.

When I pass request attribute to .rpt, through JRC framework, report works fine. When I have a "% " (percentage , space) in request attribute, I don't see any results, although database returns value. Any ideas to resolve this issue would be great. Thanks

Pavan

[Former Member · Accepted solution]

Hi Pavan,

You can change the rpt to modify the formula for record selections like this:

{Table.field} like ""{?YourParameter}""

By doing this, your reports will support % wildcard without typing in "%"

If % is a value rather than wildcard, for Oracle, you can use escape.

For instance, select* from table where table.colum like '!%' escape '!';

thanks,

Dennis