AspWebSolution Forums » Products » ASP Report Wizard v2 » Clicking Build Report Generates A Page Error

index | search | no replies | posting guidelines | help

login | register

» »

:: Clicking Build Report Generates A Page Error :: (6)

Post a New Message | Post a Reply

Jan 2 2008, 7:21 AM

Clicking Build Report Generates A Page Error

gmanning

since: Jan 2, 2008
from: Wilkes-Barre, PA I just installed the ASP Report Wizard and when I click on Build Report I get a page error with the following detail:

Line: 3
Char: 462
Error: 'check1.length' is null or not and object
Code: 0

I reregistered the DLL to no avail.

The database I am connecting to is SQL 2005 and I tested the connection string with no problems.

Thank You

Jan 4 2008, 11:58 PM

Re: Clicking Build Report Generates A Page Error

ghost

from: Washington, DC Make sure your report wizard is not within any HTML FORM tags

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

Jan 6 2008, 4:29 PM

Re: Clicking Build Report Generates A Page Error

akviby

since: Jan 6, 2008
from: somewhere Hi
It is all about the connectionstring, I tried a lot of different ones and this one worked.

objWiz.Init("Provider=SQLNCLI;Server=SERVER01\SQLEXPRESS;Database=supersales;Uid=sa;Pwd=###")

Try that and I hope it works!

Jun 1 2009, 7:38 AM

Re: Clicking Build Report Generates A Page Error

Weezy

since: Jun 1, 2009
from: Grand Rapids, MI Using this will work to access some old reports:
<% Set objWiz = Nothing Dim objWiz Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2") objWiz.LicenseKey = "JUST-BOUGHT-THIS-THING" ;-) 'Make sure you initialize before adding any HTML text 'TODO: Change this to your actual connection tring objWiz.DatabaseType = "SQLServer" objWiz.Init("Provider=MSDASQL;Driver={SQL Server};Server=192.168.9.9;Database=Sample;UID=xxxx;PWD=75478f;") 'put this where you want your reports objWiz.DisplayReports Set objWiz = Nothing %>

But whenever you click on Build Report you get the error:
check1.length is null or not an object.

I have tried several other connection strings and they either won't work or throw the same error.

I can get records back from the old reports so I know the connection is good.

Jun 1 2009, 9:16 AM

Re: Clicking Build Report Generates A Page Error

Weezy

since: Jun 1, 2009
from: Grand Rapids, MI I have been dinking around with this and found this post: http://aspwebsolution.com/forums/?tid=837&mid=890

I was able to get it to list tables and views and I believe I am on my way.

We are using SQL 2005, is there something that prevented the tables or views from being listed?

Thanks.

Jun 2 2009, 4:06 AM

Re: Clicking Build Report Generates A Page Error

ghost

from: Washington, DC The connection string for SQL Server 2005 is of the following format:

strConnectionString = "Provider=SQLNCLI;" & _ "Server=YOUR_SERVER_IP;Database=YOUR_DATABASE;" & _ "UID=YOUR_USERNAME;PWD=YOUR_PASSWORD;"

Try it and let me know if it helps.

Ref: Connection String Samples

You may have to REMOVE the entry below first.

objWiz.DatabaseType="SQLServer"

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

Pages: (1) [1]