How to drill down to 2nd report passing parameters

[Chisho]

I have a summary web report (built with report builder 10g) and I'd like to have the data in one column set as hyperlinks so the user can click on any value in that column which then passes that specific value to the detail report - which then magically appears.

e.g. my summary report has a name column, if the results are Tom, Bob, Jim and I click on Bob then "Bob" is sent as a parameter to run the detail report.

any suggestions?

 

[nagornyi]

You need the fileld's properties Hyperlink and Hyperlink Destination found on the field's Property Palette. The field value can be referred by name as parameter while creating report calling URL. Read help on those properties for more info.

 

[Chisho]

I've created a url to link to the detail report based on the examlpe in reports help (placed it in the hyperlink field for the clickable data field - name). I've included 3 parameters in the hyperlink, name, a date and priority. I can run the detail report standalone (on the reports test server) with this link, however I get an error when I try to run it from clicking in the summary report:

rep-50003: Bad parameter 'p_priority'=PRIMARY
here is the last part of my link:

report=RWLD.rdf&'p_date='&F_start_date&'p_name='&F_name&'p_priority='&F_priority

The summary (parent) report has 2 user parameters, p_name and p_date. The detail report has 3 user parameters, p_name, p_date and p_priority. Does p_priority have to exist in the parent rpt as a parameter as well?? It seems to read the param though as the error message identifies (priority should be PRIMARY).

Thanks for your assistance

 

[nagornyi]

Try changing places of parameter and see if it still complains on the priority parameter, or on the last one in string.
Examine the hyperlink string by copying it from the address bar once generated, and see how it is different from the URL you said is working fine.

 

[Chisho]

OK, problem solved.

I changed the parameter positions but no luck then I played around with the & in the url string and found that if I connected the parameters with a + and then referenced the actual value with the & it worked.
e.g.
report=RWLD.rdf+p_date=&F_start_date+p_name=&F_name+p_priority=&F_priority

The following doc on Oracle Metalink gives an example:
How To: Create Drill Down Web Reports Using Hyperlinks
Doc ID: Note:160262.1

thanks for you help nagornyi