How to pass data item value in a URL?

[Deeor]

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.

[melee]

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:

Code Select Expand


'<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?