| :: installation problem with asp report :: (7) | Post a New Message | Post a Reply |
 installation problem with asp report | Post a Reply |
from: Fresno, CA
 Re: installation problem with asp report | Post a Reply |
from: Washington, DC
Also make sure you create your connection before adding any HTML tags to your .asp page as shown below:
<% 'decalre your object Dim objWiz 'create an instance Set objWiz
= Server.CreateObject("AspWebSolution.ReportWizard2") 'set your parameters With objWiz
'Set your print header .PrintHeader
= "<h1>ACME, INC</h1><h2>@ReportTitle</h2>" 'set other parameters if required .ShowInactiveButtons
= True End With 'initialize your connection string objWiz.Init(strConn)
%> <html>
<head>
<title>First Quarter Reports</title>
</head>
<body>
<% objWiz.DisplayReports
Set objWiz = Nothing %> </body>
</html>
-------------------------
Ghost
| Re: installation problem with asp report | Post a Reply |
from: Fresno, CA
I'm using the simple data to test ASP Report Wizard. SO I set up the following:
<%
'Declare object
Dim objWiz
'Create an instance
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")
'Create database connection
objWiz.Init("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("/report/data/sample.mdb") & ";")
%>
It connects to the database, displays the report wizard data and lets me select a table (like customers) but when I select print it returns to default.asp but doesn't display the page. It says it can't find default.asp.
The default page has only been modified to connect to the database location, no other modifications. What's wrong here?
John
| Re: installation problem with asp report | Post a Reply |
from: Laurel, MD
<% 'Declare object Dim objWiz 'Create an instance Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2") 'Create database connection objWiz.Init(
"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE= "& Server.MapPath("/web/test/Sample/data/sample.mdb") & ";") objWiz.DisplayReports
Set objWiz = Nothing %> -------------------------
Master of the Game
| Re: installation problem with asp report | Post a Reply |
from: Fresno, CA
I'm still having the same problem. It appears that it won't do the javascript:_doPostBack(). I guess it may be a permission issue. The web folder is set to read and exucute. Do I need any special permssions with the DLL?
John
 Re: installation problem with asp report | Post a Reply |
from: Laurel, MD
P/S: Also make sure that the folder where your reports.asp files reside is recognized as an application by IIS
-------------------------
Master of the Game
| Re: installation problem with asp report | Post a Reply |
from: Fresno, CA
Here's the code, the only changes from the sample are to the folder locations. At this point I believe it's something on the server set up. It's a new W2003 server. Server side ASP is turned on. The web site folder is included as a default application under the application pools, which would include the report folder. Permissions are set to read, write, and scripts. It connects to the database and shows the tables, but whenever a Javascript:_doPostBack() is called, it fails. Don't know where to look for any other settings?
<%
'Declare object
Dim objWiz
'Create an instance
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")
'Set license key before you initialize connection
'objWiz.LicenseKey = "U7MA-WA7C-2P8F-ZPPK-YMPM"
'Create database connection
objWiz.Init("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("/report/data/sample.mdb") & ";")
%>
<html>
<head>
<title>Simple Repoprts</title>
</head>
<body scroll="auto">
<%
'put this where you want your reports
objWiz.DisplayReports
%>
</body>
</html>
<%
Set objWiz = Nothing
%>