AurobindoSaha
Programmer
Hi,
I am trying to migrate the csp codes from CE 8 to 10. In the reports we use "gf" function in the hyperlinks of fields to drill down inside a report. For example if we like to see the report for a particular value of NPA in the hyperlink formula of any field of top level of the report we mention:
"viewrpt2.csp?gf={TNVU_XBORDER_MY.NPA}%3d" + ToText({TNVU_XBORDER_MY.NPA},0)
Now, inside viewreport2.csp we form the url as follows
<%
Response.Expires = -1
Dim Viewer, DEBUG, vURL
DEBUG = false
On Error Resume Next
Select Case Request.Cookies("ePortfolio_vwr")
Case 0: Viewer = "actx"
Case 1: Viewer = "html_frame"
Case 2: Viewer = "html_page"
Case 3: Viewer = "java"
Case 4: Viewer = "java_plugin"
Case 5: Viewer = "nav_plugin"
Case Else: Viewer = "html_frame"
End Select
If DEBUG Then
Response.Write "<h2>Group Selection Formula</h2>"
Response.Write Request.QueryString("gf") & "<p>"
Response.Write "<h2>Cookies</h2>"
Response.Write Request.Cookies & "<p>"
Response.End
Else
vURL = "viewrpt.cwr?id=" & Request.Cookies("RCOOKIE")
vURL = vURL & "&init=" & Viewer
vURL = vURL & "&apstoken=" & Request.Cookies("apstoken")
vURL = vURL & "&gf=" & Request.QueryString("gf")
If Request.QueryString("sfSwitch") = "" then
vURL = vURL & "&sf=" & Request.QueryString("gf")
End If
Response.Redirect vURL
End If
%>
Strangely enough the CE 10 returns a error "Internal Error on cache or page server"
On contacting BusinessObjects technical support they says that "gf" is now discontinued in version 10. They suggest to replaced gf with sf. I tried to form the url with sf but with no result.
Also I cannot capture the following parameters when I use sf.
1. Request.Cookies("RCOOKIE") for ID
2. Viewer changes to actx even if I use html_frame
3. Request.Cookies("apstoken")
Can anyone help in this regard?
Thanks
Aurobindo
I am trying to migrate the csp codes from CE 8 to 10. In the reports we use "gf" function in the hyperlinks of fields to drill down inside a report. For example if we like to see the report for a particular value of NPA in the hyperlink formula of any field of top level of the report we mention:
"viewrpt2.csp?gf={TNVU_XBORDER_MY.NPA}%3d" + ToText({TNVU_XBORDER_MY.NPA},0)
Now, inside viewreport2.csp we form the url as follows
<%
Response.Expires = -1
Dim Viewer, DEBUG, vURL
DEBUG = false
On Error Resume Next
Select Case Request.Cookies("ePortfolio_vwr")
Case 0: Viewer = "actx"
Case 1: Viewer = "html_frame"
Case 2: Viewer = "html_page"
Case 3: Viewer = "java"
Case 4: Viewer = "java_plugin"
Case 5: Viewer = "nav_plugin"
Case Else: Viewer = "html_frame"
End Select
If DEBUG Then
Response.Write "<h2>Group Selection Formula</h2>"
Response.Write Request.QueryString("gf") & "<p>"
Response.Write "<h2>Cookies</h2>"
Response.Write Request.Cookies & "<p>"
Response.End
Else
vURL = "viewrpt.cwr?id=" & Request.Cookies("RCOOKIE")
vURL = vURL & "&init=" & Viewer
vURL = vURL & "&apstoken=" & Request.Cookies("apstoken")
vURL = vURL & "&gf=" & Request.QueryString("gf")
If Request.QueryString("sfSwitch") = "" then
vURL = vURL & "&sf=" & Request.QueryString("gf")
End If
Response.Redirect vURL
End If
%>
Strangely enough the CE 10 returns a error "Internal Error on cache or page server"
On contacting BusinessObjects technical support they says that "gf" is now discontinued in version 10. They suggest to replaced gf with sf. I tried to form the url with sf but with no result.
Also I cannot capture the following parameters when I use sf.
1. Request.Cookies("RCOOKIE") for ID
2. Viewer changes to actx even if I use html_frame
3. Request.Cookies("apstoken")
Can anyone help in this regard?
Thanks
Aurobindo