+6
When passing a parameter from a lobby element to a quick report, the navigation URL is surrounding the data with single quotes, these are then in the URL, and appear in the quick report. This causes the quick report to break.
Why is this? The data source does not have these quotes in it.
Hi
Normally if you type in a url and use the ‘ character, they are automatically replaced by %27 .
There seems to be a parameter (I'm on 23R2) on the lobby element page, which allows you to overrule the datatype.
Please check if that works. If not, you can leave that setting on and manually add the %27 like so: quickreport516536?AREA=%27$[RESOURCE_ID]%27
+6
That’s interesting, we’re yet to take 23R2, so that will fix it I assume.
I’ve actually combined your suggestion with the update to the query in the Quick Report to strip out the quotes, and that works,
replace(&AREA, '''', '')
Thank you
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
