Morning all.
Just wondered if anyone knows how to pass parameters with a Carriage Return / Line Feed via drill through?
Here is a simple test case (demos the problem, not the real problem).
I have a report that can capture a multiline parameter:
On the report this parameter looks like:
If I create a drill through on this report back to itself, passing the data item 1 into the same parameter, then the CR/LF get replaced:
- I know that in a query based data item I could do some kind of substitute to replace with chr(10) but I don't want to introduce another query into a report just to format a data item correctly. Is there a report expression (not query expression) that can do a replace?
- Or if anyone knows how to pass CR/LF via drill through then let me know.
Regards.
Edited - screenshots are still not showing on this forum!
basically the drill through target is showing 'hello world'
rather than
hello
world
------------------------------
Marc Reed
------------------------------