AspWebSolution Forums » Products » ASP Report Wizard (version 1)

index | search | no replies | posting guidelines | help

» »

:: What's Missing :: (9)

Post a New Message | Post a Reply

Oct 21 2003, 3:12 PM

What's Missing

Post a Reply

kinglesbian

since: Oct 17, 2003
from: Chicago

    I found this site and think that the reports are fantastic and would like to use them.   No problem buying code/components.  According to the site just download zip, install, and place the 2 sections of code in the file.  I did that.  Nothing.
    I have this installed on my server but encountered 2 errors during install.  The first was to keep an older file.  The second was a registering error for msado25.tlb.   I clicked "ignore" and received a successful install message.
    It has become obvious that something is missing/wrong.  What do I need to get this working?

Oct 21 2003, 11:01 PM

Re: What's Missing

Post a Reply

whichman

from: Laurel, MD

This is a common thing with all dll registrations on windows.
Try the following:
1. restart your computer
2. Uninstall the previous version (AWSReportWizard.dll)
3. Re-Install the new version and try to run your files.

Note: Make sure you have write access to the folder in which your .asp file is located and also that your connection string is working.

Let me know if it works

-------------------------
Master of the Game

Oct 22 2003, 11:01 AM

Re: What's Missing

Post a Reply

kinglesbian

since: Oct 17, 2003
from: Chicago

It did not work.  Below is a copy of the code, it's quite basic.  All I am trying to do is see if I can get this thing to read/display the tables.  The connection string is fine and I followed what the tutorial said about placing code.  I put 1 test line in to see if it was working.  I uninstalled/reinstalled/rebooted to no avail.  Any suggestions (the html tag was after the initial asp code to begin with)?

<html>
<%
Dim objReport, strConnectionString
Set objReport = Server.CreateObject("AspWebSolution.ReportWizard")

'ACCESS connection string
strConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.3.51;DATA SOURCE=" & _
     "\\cid2000\c\ASPMaker\projects\Cidbond\system.htm;"

'SQL Server connection string
'strConnectionString = "Provider=MSDASQL;Driver={SQL Server};Server=WHICHMAN;Database=Northwind;User ID=sa;Password=sa;"

'NOTE: You must call the Init procedure before adding any HTML Tags/Text into your page
objReport.Init(strConnectionString)

%>

<head>
   <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
   <meta name="Author" content="Keith T. Aremka">
   <title>test</title>
</head>
<body>
this is my report
<%
objReport.DisplayReports
Set objReport = Nothing
%>
</body>
</html>

Oct 22 2003, 2:41 PM

Re: What's Missing

Post a Reply

kinglesbian

since: Oct 17, 2003
from: Chicago

Well,
It turns out that I changed the provider to 3.51 because I thought our server did not have 4.0. I changed it back, and made the path to be c: instead of the network path and it turned out well.
I have been searching the forum to find out how to remove certain tables from the first page and found one that said to include a objReport.ExcludeFromJoins = "..." before the init line. This did not work. Any other suggestions?

KING

Oct 22 2003, 3:33 PM

Re: What's Missing

Post a Reply

jt102763

since: Oct 1, 2003
from: somewhere

The exclude from joins property is to eliminate fields from automatically being used to join multiple tables. I had an instance where I was creating a report from two tables that both had a field named "Memo". This field obviously couldn't be used to join tables, I reported it and the program now has this property.

What you use to hide/show tables are the properties "usetable" and "hidetable". How to use them is on the API page for the report wizard.

Oct 23 2003, 11:06 AM

Re: What's Missing

Post a Reply

kinglesbian

since: Oct 17, 2003
from: Chicago

I was sifting through the posts and the site and actually found that late in the afternoon. Thanks.

Also, is there a was to format fields in the reports?

Oct 23 2003, 11:15 AM

Re: What's Missing

Post a Reply

kinglesbian

since: Oct 17, 2003
from: Chicago

Thanks, I was sifting through the site and forums and found it late in the afternoon.

Also, is there a way to format the summery fields in the reports?

Oct 23 2003, 1:16 PM

Re: What's Missing

Post a Reply

Ghost

from: Washington, DC

You can type the text for the summary in the description box. As for data formatting, the specs will be handled in the next version.

-------------------------
Ghost

Oct 23 2003, 4:00 PM

Re: What's Missing

Post a Reply

cam johnson

since: Oct 20, 2003
from: USA

What is the resolution to the registering error for msado25.tlb? I've never installed a previous version so that can not be it. I've restarted the server a couple times. Is there something that I'm missing?

Thank You!

Pages: (1) [1]