Calling a subreport using a hyperlink, and using a parameter

[iamyellow]

I would like to click ona field pass that value to the subreport and open up the subreport.

I have done the following:

I am using Crystal 2008. I selected hyperlink type, a website on the internet. For hyperlink information, I entered the following in the formula: "

http://localhost:8080/ASM3_REPORTS/RFTUSN_ROLLUP_sub_hypelnk.rpt?prompt0="+{QptRft.QCL_TITLE}

When I click on the field, the window opens up with the reports source code vice the report.

 

[IdoMillet]

You need a web application in order to support this approach.

One of the 3rd-party Crystal report viewers listed at

http://www.kenhamady.com/bookmarks.html

provides special functionality that allows a double-click in a report section to launch another report and pass parameters to it (based on information in a hidden formula placed in that section). This can be done even from within subreport sections.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com