index | search | no replies | posting guidelines | help | login | register |
Index » Products » ASP Report Wizard v2 |
| |||||||
Jul 12 2005, 7:08 AM |
| ||||||
tonyzoc since: Jul 5, 2005 from: Buffalo, NY | Here's my code. The include file includes a function getOraSDEConn2() that takes a parameter and looks up and returns the Oracle connection string. When I initially run the page, with the parameter in the URL it works. On any postback action (next page, CSV, Text, etc...) it doesn't get the Request and fails to return a connection string. The calling URL is: https://geobase.afrc.af.mil/facilityreports/test.asp?rid=FUSROOM_ALL_PR&bcode=HTUX <!--#include virtual="../include.asp"--> <% Dim OraConn, strDbCode Dim objWiz strDbCode = Request("bcode") 'On the initial call the response.request returns the passed in bcode. On postbacks it returns empty. response.write("strDbCode=" & strDbCode & "<br>") OraConn=getOraSDEConn2(strDbCode) Session("UserSeqLevel")="1" Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2") With objWiz .LicenseKey = "XXXX-XXXX-XXXX-XXXX-XXXX" .AddTopNavigationBar = True .PrintHeader = "<h1>AFRC Facility Data</h1><h2>@ReportTitle</h2>" .ShowInactiveButtons = True .UsePopupFilters = False .HideProcedures = True .HiddenFields = strDbCode .CanDelete = False .IsAdmin = False End With 'Make sure you initialize before adding any HTML text objWiz.Init(OraConn) %> <html> <head> <LINK href="styles.css" rel="stylesheet" type="text/css"> <title>First Quarter Reports</title> </head> <body> <% targetstr="https://geobase.afrc.af.mil/geobase_resources/index.html" & chr(34) & " TARGET=" & chr(34) & "_top" objWiz.HomeUrl = targetstr objWiz.Title = "Facility Reports" objWiz.PrintFooter = "<p align='center'>© AFRC, 2005. All rights reserved</p>" 'put this where you want your reports objWiz.DisplayReports Set objWiz = Nothing %> | ||||||
Jul 12 2005, 12:50 PM |
| ||||||
ghost from: Washington, DC | If Request is not working then it is probably your server's ASP version. Anyway, try this: strDbCode = Request("bcode") ------------------------- Ghost | ||||||
Jul 12 2005, 4:26 PM |
| ||||||
tonyzoc since: Jul 5, 2005 from: Buffalo, NY | I'm pretty sure the dll was just updated in anticipation of this feature, but I'll recheck and also try this code and let you know.. Thanks, Tony Zoccolilo | ||||||
Jul 13 2005, 7:13 AM |
| ||||||
tonyzoc since: Jul 5, 2005 from: Buffalo, NY | Ok...we updated from 2.5.47 to 2.5.52 and it works. We still have 1 problem though.... The postback for Print, Doc, CSV, etc work fine. In some of our reports we have hyperlink fields that filter the data down based on that field. If the hyperlink value is clicked the report filters down for that field value. This isn't working now because the bcode is not getting through. Any ideas how we deal with that? How do we get this parameter HiddenField into our hyperlink URL? Thanks Tony Z | ||||||
Jul 13 2005, 3:46 PM |
| ||||||
ghost from: Washington, DC | This functionality will be added by the next release due by Friday. ------------------------- Ghost | ||||||
Jul 14 2005, 5:27 AM |
| ||||||
tonyzoc since: Jul 5, 2005 from: Buffalo, NY | ok, We have also noticed that although the latest .dll release has supported more parameter-based features, it has also affected the functionality of the 'Build Report' feature of the component. When a dynamic connection string is passed into the default.asp page; the parameter-portion of the string now maintains state for most of the components functionality; however the 'Build Report' feature now fails. | ||||||
Jul 14 2005, 10:16 AM |
| ||||||
ghost from: Washington, DC | This bug fix will also be available in the next release due before the end of tomorrow. thanx! ------------------------- Ghost | ||||||
Pages: (1) [1] |