Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

"%" in request attribute

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

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question