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!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"gf" function in URL Reporting

Status
Not open for further replies.

AurobindoSaha

Programmer
Mar 11, 2004
57
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top