Using Hyperlink to subreport from main report in CE8

[dphilli1]

I am attempting to Hyperlink to a subreport from a main report. We’ll be doing some nesting of these subreports, which is why we’re not using the ‘subreport’ functionality already in Crystal 9 Report and Crystal Enterprise 8.

After several contacts with the Crystal Helpdesk I thought I’d give the experts a try. The Hyperlink below references my server name and path to my subreport file.

"

http://nawsssler001/crystal/enterprise9/admin/en/viewreport.cwr?init=connect&id=44144"

& "&prompt0=" & {DW_GL_ORG.ORG_COMPANY}

When I use the above syntax I get the following error message:

Web Component Server Error
Bad Parameter

Main components of this statement are:
1) 44144 – Report ID for the subreport in the ASP
2) The prompt0 is a four-digit numerical value that is a parameter in the main report coming from the field {DW_GL_ORG.ORG_COMPANY} that we need to pass to the subreport.
3) I know the path itself is correct because I can open the subreport from a hyperlink without the prompt. However I’m using the CSP identifier instead of CWR on the end.

My concern is that:
a)The CWR extension should be CSP. Although I’m told be the helpdesk that the CWR will be transformed to a CSP page.
b)My syntax is hosed.

I’ve been working with the Crystal Helpdesk and trial and erroring the syntax for over 8 hours. Any help you can provide would be greatly appreciated!!

Thanks, Dean



Good. Fast. Cheap. Pick Two.