Open a report in a new browser

gearheadgood · Dec 12, 2003

Is there a way to launch a report in a new browser window ?

I have a launchreport.asp which calls my showreport.csp.

Can;t quite figure out how to open the report in a new browser window !

tks,

Turkbear · Dec 12, 2003

Hi,
You can do it in a JavaScript function:
( snippet below)

Code:

function RunRpt{
windowprops = &quot;fullscreen=no,location=yes,scrollbars=no,menubars=no,toolbars=no,resizable=yes&quot;;
reportWindow=window.open(<YourUrl>,&quot;rptWindow&quot;,windowprops);
}

Of course you will need to handle the call to the function in your ASP ( or CSP) page and you can also add parameters to the call to set the URL or other stuff

gearheadgood · Dec 12, 2003

Here is my current code, works like a charm:

Dim sTemp

sTemp = crReportID & "&promptex-CenterName=" & Replace(CenterName, "&", "§&quot

& _
"&promptex-DischargeFilter=" & CStr(DischargeFilter) & _
"&promptex-StartDate=" & StartDate & _
"&promptex-EndDate=" & EndDate

Response.Redirect("../Reports/LaunchReport.asp?ReportID=" & sTemp)

LaunchReport.asp calls the ShowReport.csp

Should I add the java code to the ASP page and call it instead of the Response.Redirect ?

tis,
M

Turkbear · Dec 12, 2003

Hi,
I think JavaScript is the only way to get a new window, but experienced ASP/VbScript coders may know otherwise..
For your example you could use on your calling page:

Code:

<HEAD>
<SCRIPT Language=&quot;JavaScript&quot;>

function RunRpt(pstr){
var qstr = pstr
locstr = &quot;http:\\servername\Reports\LaunchReport.asp?ReportID=&quot; + qstr
windowprops = &quot;fullscreen=no,location=no,scrollbars=no,menubars=no,toolbars=no,resizable=yes&quot;;
reportWindow=window.open(locstr,&quot;rptWindow&quot;,windowprops);
}
</SCRIPT>
</HEAD>

Then add a calling button in the BODY section of your Page:

Code:

<input type=&quot;button&quot; value=&quot;Run the Report&quot; OnClick=RunRpt(&quot;<%=sTemp %>&quot;)>

Above assumes sTemp will be defined first and then you can pass it as an ASP Variable.

gearheadgood · Dec 16, 2003

Getting Close:

Here's the code:

function RunRpt(pstr){
var qstr = pstr
locstr = "LaunchReport.asp?ReportID=" + qstr
windowprops = "fullscreen=no,location=no,scrollbars=no,menubars=no,toolbars=no,resizable=yes";
reportWindow=window.open(locstr,"rptWindow",windowprops);
}

I call this in the client side onLoad event:
RunRpt("<%=crReportID%>&quot

I get a crystal error:
Error encountered by Crystal PageServer
------------------------------------

The error message returned is:

File E:\woundstar_new\Reports\viewrpt.cwr not found. [On Page Server: JKAWEB02.pageserver]

I know it's there, because this report works fine the "old" way when I dont try and opena new window. Is it something in the way variable "crReportID" is passed ?

crReportID is a variable that I get from the passing URL.

tks,

Turkbear · Dec 16, 2003

Hi,
Can I see the code that is executed before the OnLoad event?

webgolf · Dec 17, 2003

I too experienced the viewrpt.cwr not found error and I was told to stopt and start all the processes on CCM. It worked for me. (CR 8.5)

gearheadgood · Dec 17, 2003

Here is the code I run in the before show event:

Function Page_BeforeShow()
Dim CenterID
Dim StartDate
Dim EndDate
Dim crReportID

CenterID = Request.QueryString("CenterID&quot

StartDate = Request.QueryString("StartDate&quot

EndDate = Request.QueryString("EndDate&quot

crReportID = Request.QueryString("crReportID&quot

Call RunStoredProc(CenterID, StartDate, EndDate)
End Function

gearheadgood · Jan 14, 2004

Turkbear any ideas ?

Thanks in advance !

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Open a report in a new browser

gearheadgood

Programmer

Turkbear

Technical User

gearheadgood

Programmer

Turkbear

Technical User

gearheadgood

Programmer

Turkbear

Technical User

webgolf

Programmer

gearheadgood

Programmer

gearheadgood

Programmer

Similar threads

Part and Inventory Search

Sponsor