index | search | no replies | posting guidelines | help | login | register |
Index » Products » ASP Report Wizard v2 |
| |||||||
Mar 4 2006, 7:59 AM |
| ||||||
holyschmidt from: Florida | The AddHiddenSqlFilter is not applying the filter. What am I doing wrong? query string: http:/website.com/master/default.asp?rid=SCLR&originate=co.asp&location=001 page code: <% if request("originate") <> "" then session("originate") = request("originate") end if Dim objWiz Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2") objWiz.LincenseKey = XXX objWiz.ReportsFile = "C:\INetPub\WWWRoot\master\reports.xml" objWiz.Init("Provider=SQLOLEDB.1;User ID=databaser;PWD=password;Initial Catalog=Database;Data Source=server") objWiz.DefaultPageSize = 10 objWiz.Width = 650 objWiz.HideProcedures = True objWiz.HideTables = True objWiz.HideViews = True objWiz.IsAdmin = False objWiz.HomeURL = "../" & session("originate") %> <html> <head> <title>Master Reporting System</title> </head> <Body OnLoad="" leftmargin="0" topMargin="0"> <!-- #include file=top.asp --> <% objWiz.AddHiddenSqlFilter "users", "usersystem = " & session("userdb") objWiz.DisplayReports %> | ||||||
Mar 6 2006, 5:05 AM |
| ||||||
ghost from: Washington, DC | You have to set all parameters before initializing your connection string. page code: <% ------------------------- Ghost | ||||||
Pages: (1) [1] |