Report that opens another report in a different browser

[marydn]

Hi,

In order to defeat the no subreport within a subreport limitation in Crystal 8.5, I created two separate reports. I added a hyperlink to my main report so that when clicked it opens the subreport. In order to open the subreport I need to pass a parameter to it. The only problem is that it doesn't work when I post it to Crystal Enterprise. It keeps putting a comma in the value being passed through the URL. It doesn't do this in the report designer. Can anybody tell me how to fix this? I have tried ToText with the thousands separator, but then it puts a number and a percent in the URL, which deos not work. These are the various URL's I have used:

"http:.....=java&promptex-Pm-vwSite.PropertyID="""+cstr({vwSite.PropertyID},0)+""""


"http:.....=java&promptex-Pm-vwSite.PropertyID="""+ToText({vwSite.PropertyID},0)+""""

"http:.....=java&promptex-Pm-vwSite.PropertyID="""+ToText({vwSite.PropertyID},0," &quot+""""


Any help would be greatly appreciated!

M.

 

[marydn]

Nevermind I figured it out

 

[lyanch]

The hyperlink function depends on the viewer (sorry to say). The following is an example of one (using the formula) that works in the Active X and java viewer.. but not in the DHTML viewer.

"

http://.....+

"&promptex-catalogId=" + '"' + {catalog.catalogId} + '"'


I think it is the single quotes around double quotes that is the trick you need.

Lisa

 

[marydn]

Thanks...what I needed to do was get rid of the comma being passed and I did that by........

+cstr({PropertyID),0,'')

I had to use single quotes or else it wouldn't work.