I am trying to pass a user selected value using a URL to another report.
If I include a value in the URL (p_GEO='ASIA') it works no problem however I want to pass the value that the user clicks on.
How would I accomplish this?
I have the hyperlink Text Source set as a Data Item Value with the Value of GEO and the URL Source is a Report Expression that contains the URL.
.../content/package[@name='MyPkg']/report[@name='MyReport']&p_GEO=?&ui.action=run&ui.header=false&ui.toolbar=false&run.prompt=false
I know I could accomplish this using the Drill-Through definitions however I have a unique requirement that requires the use of a URL. I appreciate any help I can get.
Thanks.
Color me impressed - I didn't know you could trigger a report via GET variables.
Since I'm not sure EXACTLY how to do this, let me see if I can provide some ammo - please let me know how you end up doing this, as it could be a great benefit to others.
In order to pass the geo value in the URL, you're going to need to create a data item that builds the URL string. for example:
'<a href=".../content/package[@name='MyPkg']/report[@name='MyReport']&p_GEO=' || [Query1].[GEOCODE] || '&ui.action=run&ui.header=false&ui.toolbar=false&run.prompt=false">'
Give that a shot?