index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: passing parameters and AddHiddenSqlFilter :: (2)Post a New Message | Post a Reply
Mar 4 2006, 7:59 AM
 passing parameters and AddHiddenSqlFilterPost a Reply
 holyschmidt

View this author's profile Send this author a private message Visit author's homepage

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
 Re: passing parameters and AddHiddenSqlFilterPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

You have to set all parameters before initializing your connection string.

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.DefaultPageSize = 10
objWiz.Width = 650
objWiz.HideProcedures = True
objWiz.HideTables = True
objWiz.HideViews = True
objWiz.IsAdmin = False
objWiz.HomeURL = "../" & session("originate")
objWiz.AddHiddenSqlFilter "users", "usersystem = " & session("userdb")

objWiz.Init("Provider=SQLOLEDB.1;User ID=databaser;PWD=password;Initial Catalog=Database;Data Source=server")
    
%>

<html>
<head>
<title>Master Reporting System</title>
</head>
<Body OnLoad="" leftmargin="0" topMargin="0">
<!-- #include file=top.asp -->

<%
    objWiz.DisplayReports
%>




-------------------------
Ghost
Pages: (1)   [1]

search this forum: