Report with hyperlink open in the same window

[JuliaFarber]

Hello!

I have a very big report with a lot of subreports( on demand and regular). I also have hyperlink.
My problem is when the hyperlink is clicked, new window is opened(that is good), but when I close this window to get back to the report, after switching to next page the hyperlink data displayed in main report.

Does anyone have any idea what is happening and how to resolve it?

Thank you.
Julia

 

[FVTrainer]

Your statement "after switching to next page the hyperlink data displayed in main report" is a little unclear. First, what does the hyperlink go to? Another report or some other html/asp page? Second, how are you viewing the main report? Through a web browser or in Crystal Designer? And how is the report being deployed? Via Crystal Enterprise or some other way? Lastly, what version of Crystal are you using?

 

[JuliaFarber]

Thanks for quick respond.
I am using cr 8.5 developers edition. The main report is opened through asp using ActiveX Viewer. Hyperlink is going to asp page which is opening another report in the new browser window. Then when I close new window, I get my main report, and when click to get next page I get the report from hyperlink.

Thank you for your help.
Julia

 

[FVTrainer]

Ok, so when you say you click the "next page" are you click the browser's next page button (as in the Forward button you might use when surfing the web) or the Crystal ActiveX Viewer next page button?

 

[JuliaFarber]

Crystal Active X next page button >.

 

[FVTrainer]

Ok, CR 8.5 Developer came with a version of CE. So, are you using "CE lite" to run your report or the RDC? Perhaps it would help if you posted the section of the asp page that calls the main Crystal report?

 

[JuliaFarber]

The asp page that calls main report:
<%@ Language=VBScript %>

<%
server.ScriptTimeout=600
Response.CacheControl=&quot;no-cache&quot;
pstart=Request.QueryString(&quot;pstart&quot
pend=Request.QueryString(&quot;pend&quot
site=Request.QueryString(&quot;site&quot

if Request.QueryString(&quot;pdiv&quot=&quot;&quot; then
pdiv=0
else
pdiv=cint(Request.QueryString(&quot;pdiv&quot)
end if

if Request.QueryString(&quot;pacct&quot=&quot;&quot; then
pacct=0
else
pacct=cdbl(Request.QueryString(&quot;pacct&quot)
end if

if Request.QueryString(&quot;pnum&quot=&quot;&quot; or Request.QueryString(&quot;pnum&quot=&quot;0&quot; then
pnum=0
else
pnum=cdbl(Request.QueryString(&quot;pnum&quot)
end if

ReportName=&quot;main_report.rpt&quot;

%>
<!-- #include file=&quot;AlwaysRequiredSteps.asp&quot; -->
<%
set crtable = session(&quot;oRpt&quot.Database.Tables.Item(1)
crtable.SetLogonInfo &quot;dbname&quot; ,&quot;&quot;, cstr(&quot;user&quot, cstr(&quot;user&quot

if crtable.testconnectivity=&quot;True&quot; then

Set ParamDefCollection = Session(&quot;oRpt&quot.Parameterfields
set session(&quot;Param&quot = ParamDefCollection

set MyParam = session(&quot;Param&quot.Item(1)
Call Myparam.SetCurrentValue(cdbl(pnum),7)

set MyParam = session(&quot;Param&quot.Item(2)
Call Myparam.SetCurrentValue(cdbl(pdiv),7)

set MyParam = session(&quot;Param&quot.Item(3)
Call Myparam.SetCurrentValue(cdbl(pacct),7)

set MyParam = session(&quot;Param&quot.Item(4)
Call Myparam.SetCurrentValue(cstr(pstart),12)

set MyParam = session(&quot;Param&quot.Item(5)
Call Myparam.SetCurrentValue(cstr(pend),12)

set MyParam = session(&quot;Param&quot.Item(6)
Call Myparam.SetCurrentValue(cstr(&quot;&quot,12)

%>

<!-- #include file=&quot;MoreRequiredSteps.asp&quot; -->
<!-- #include file=&quot;SmartViewerActiveX.asp&quot; -->

<%
end if
%>

Thank you.
Julia

 

[JuliaFarber]

Any ideas, guys!