escaping special characters in report variables?

[CNelsen]

For reports, is there a way to escape characters that have special meaning to the substitution logic?

For example, I am trying to create a variable defined to include this column based on a check box:

Decode(r.reject_code, null, r.status, r.reject_code || ' - ' || c.short) Reject_Code,

This is what I've attempted so far:

&<NAME="Display Reject Code"
  Checkbox = "Decode(r.reject_code, null, r.status, r.reject_code || ' - ' || c.short)  Reject_Code,"
Suffix = "," >

But this give me an error
"Display Reject Code: Checkbox requires 2 items:
CHECKBOX="checked,unchecked"
due to the commas used in the Decode statement.

I haven't figured a way to get around this.

Thanks,
Christian

 

[Marco Kalter]

You can use 2 double quotes:

&<NAME="Display Reject Code"
  Checkbox = """Decode(r.reject_code, null, r.status, r.reject_code || ' - ' || c.short)  Reject_Code"","
Suffix = "," >

The quotes separate the 2 items.

 

[CNelsen]

That works great. Thanks!