index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: passing parameters and AddHiddenSqlFilter ::    show all messagesPost a New Message | Post a Reply
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: