| :: New function GetReport broke :: show all messages | Post a New Message | Post a Reply |
 Re: New function GetReport broke | Post a Reply |
from: Laurel, MD
Make sure your web folder is registered as a web application under IIS
Also make sure that your web server has ASP enbled
<%
Const db="Test"
Dim objWiz , strReport, strConn,strReportId
'set variables
strConn = "Provider=MSDASQL;Driver={SQL Server};Server=DUMMY;Database=" & db & ";User ID=sa;Password=**;"
strReportId = "4121016594" 'Request("reportid")
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")
'set all properties before initializing connection string
objWiz.LicenseKey = "XXXX-XXXX-XXXX-XXXX-XXXX"
objWiz.ReportsFile = "tmp/" & db
'Make sure you initialize before adding any HTML text
objWiz.Init(strConn)
'get your report's html string
strReport = objWiz.GetReport(strReportId)
'clear memory
Set objWiz = Nothing
%>
<html>
<head>
<title>West Coast Report</title>
</head>
<body>
<h2>West Coast Report</h2>
<%=strReport%>
<p>
© Copyright <%=Year(Now)%> ACME Solutions, All rights reserved
</p>
</body>
</html>
-------------------------
Master of the Game