index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: New function GetReport broke :: (14)Post a New Message | Post a Reply
Dec 13 2004, 8:16 AM
 New function GetReport brokePost a Reply
 limbo1686

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

from: somewhere

I get this error when trying to use the GetReport function and you example:

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
AspWebSolution<br> DisplaySQL: 5 (0x800A000D)
Type mismatch
/aspreportwizard/test.asp, line 16


Dec 13 2004, 9:23 AM
 Re: New function GetReport brokePost a Reply
 limbo1686

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

from: somewhere

More Info.  I get that error when testing on Win XP.  However when I run it on Win2K Server I don't get the error and instead get back the table.

Another Problem Though:  The table that is returned is cut-off.  It did not get the whole thing.  

For some reason it is being truncated.  If you need an example please give me an email address and I will email one to you if you need it.



Dec 13 2004, 9:57 AM
 Re: New function GetReport brokePost a Reply
 whichman

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

from: Laurel, MD

Below is my source code I tested on a WinXP Pro machine.
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
Dec 13 2004, 10:47 AM
 Re: New function GetReport brokePost a Reply
 limbo1686

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

from: somewhere

Yep - I'm using the same example pretty much.  The ASP code is executing fine, it's just error out on the GetReport() call on WinXP.

How about the return string truncation issue?

See this link:
http://login.salesjunction.com/custom/test.asp

Dec 13 2004, 1:47 PM
 Re: New function GetReport brokePost a Reply
 ghost

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

from: Washington, DC

I'm out of the office right now but try this - create a smaller report and let me know if you are still having this issue


-------------------------
Ghost
Dec 13 2004, 7:16 PM
 Re: New function GetReport brokePost a Reply
 limbo1686

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

from: somewhere

Works fine on a smaller report.  Only truncates the larger ones.

However, even clicking the Print on the small report results in a Server Error 500.

Dec 28 2004, 3:27 PM
 Re: New function GetReport brokePost a Reply
 limbo1686

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

from: somewhere

What's the status on this?

Dec 29 2004, 9:06 AM
 Re: New function GetReport brokePost a Reply
 ghost

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

from: Washington, DC

Will have an answer for you by the second week of january 05


-------------------------
Ghost
Jan 12 2005, 7:56 AM
 Re: New function GetReport brokePost a Reply
 limbo1686

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

from: somewhere

?

Jan 14 2005, 1:59 PM
 Re: New function GetReport brokePost a Reply
 ghost

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

from: Washington, DC

Works fine on a smaller report.  Only truncates the larger ones.
This is a VBScript issue. If the string exceeds a certain length, it is going to be truncated

However, even clicking the Print on the small report results in a Server Error 500.- Just tested this feature and it works fine


-------------------------
Ghost
Jan 14 2005, 11:29 PM
 Re: New function GetReport brokePost a Reply
 limbo1686

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

from: somewhere

VBScript issue?  There is no string size limit that I know of.  Why is it a VBScript issue?  Please give me details.



Jan 15 2005, 2:32 PM
 Re: New function GetReport brokePost a Reply
 ghost

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

from: Washington, DC

Create a string with 1000,000 characters and tell me if it works


-------------------------
Ghost
Jan 15 2005, 4:41 PM
 Re: New function GetReport brokePost a Reply
 limbo1686

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

from: somewhere

Yep - this code works just fine.  I can't imagine your tables being over 500K!!  Sound like it's a problem in your string buffer class you are using in your VB code in the DLL.  I have a really good string buffer class if you need one.

----  Code

<%
Dim str

str = String(500000,"X")

Response.Write str

%>


Jan 25 2005, 7:48 AM
 Re: New function GetReport brokePost a Reply
 limbo1686

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

from: somewhere

??

Pages: (1)   [1]

search this forum: