index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: help please :: (23)Post a New Message | Post a Reply
Jun 18 2004, 11:50 AM
 help pleasePost a Reply
 edp1959

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

from: somewhere

How do I get this to work with ASP.Net - I just get a blank page.  

Sub Page_Load(sender As Object, e As EventArgs)
        Dim objWiz
        objWiz= Server.CreateObject("AspWebSolution.ReportWizard2")
        Dim dbConn As SqlConnection= _
        New SqlConnection(ConfigurationSettings.AppSettings("strConn"))
        objWiz.Init("dbConn")
        objWiz.DisplayReports
        objWiz= Nothing
End Sub

I read in the forum about a report.xml page, but can't find anything in the online manual about it.  Do I need this .xml page for this to work?


Jun 18 2004, 12:33 PM
 Re: help pleasePost a Reply
 edp1959

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

from: somewhere

I found the info. on the .xml file and created.  Still getting a blank page.  

Jun 21 2004, 5:55 AM
 Re: help pleasePost a Reply
 ghost

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

from: Washington, DC


dotNet doesn't support late bound controls. And as such cannot set a reference to the ASP context objects. If you want to use this version with dotNET, you will have to call it jsut like a regular ASP page with <%...%>  signs

The dotNet version  (v2.5) is comming out this summer hopefully before the end of july.




-------------------------
Ghost
Jun 22 2004, 6:13 AM
 Report Wizard & .NETPost a Reply
 whichman

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

from: Laurel, MD

There is a way you can run COM objects with ASP.NET but it is a little complicated.


  • Download and Copy the AWSReportWizard2.dll file to any folder and
    register with command in Start > Run :

    regsvr32 "C:\<YOUR DLL PATH>\AWSReportWizard2.dll"

  • Download and Copy the AWSReportWizard2_NET.dll assembly
    into the bin directory of you application. Do NOT register it.

  • Import the AWSReportWizard2_NET.dll into your project file and
    set the aspCompat property of your ASP file to True

  • A sample call in C# will be as follows:


      private  void Page_Load(Object sender,  System.EventArgs e)
    {
         //Put user code to initialize the page here
         String cn;
         AWSReportWizard2_NET.ReportWizard2 wiz =  
               new AWSReportWizard2_NET.ReportWizard2();
      
         //set your connection string
         cn = "Provider=MSDASQL;Driver={SQL Server};Server=(local);Database=NorthWind;User ID=sa;Password=sa;";
      
         //initialize your connection string
         wiz.Init(cn);
      
         //start your page
         startPage("ASP Report Wizard version " +  wiz.Version);
      
         //display your reports
         wiz.DisplayReports();
      
         //clear memory
         wiz = null;
      
         //end your page
         endPage();
    }
      

  • You can download the VS.NET source from here ReportWizard.NET Demo (C#/VB.NET)






-------------------------
Master of the Game
Jul 28 2004, 9:42 AM
 Re: Report Wizard & .NETPost a Reply
 Darin

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

from: Conway, AR

This isn't working for me.  Does the .net version of the .dll have to be used with a corresponding version of the asp3 .dll?

Jul 28 2004, 10:32 AM
 Re: Report Wizard & .NETPost a Reply
 Darin

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

from: Conway, AR

Nevermind, I found the answer I needed.

Jul 28 2004, 1:30 PM
 Re: Report Wizard & .NETPost a Reply
 ghost

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

from: Washington, DC

What was the answer?


-------------------------
Ghost
Jul 28 2004, 1:35 PM
 Re: Report Wizard & .NETPost a Reply
 Darin

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

from: Conway, AR

The answer was to run tlbimp.exe on the version that I have already.  Trouble is that I can't get past the wizard now.  After I click finish, I get a blank gray screen in the wizard, and no report displays.

Jul 28 2004, 3:08 PM
 Re: Report Wizard & .NETPost a Reply
 Darin

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

from: Conway, AR

Need help with the above post soon!  

Jul 29 2004, 5:31 AM
 Re: Report Wizard & .NETPost a Reply
 ghost

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

from: Washington, DC

Do you have a reports.xml file in the same folder as your aspx page?


-------------------------
Ghost
Jul 29 2004, 6:37 AM
 Re: Report Wizard & .NETPost a Reply
 Darin

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

from: Conway, AR

I hope that isn't a requirement!  I have the reports.xml location specified with the ReportsFile paramater, and it is in a different folder entirely.  So far, it has been my experience that the ReportsFile parm is useless.  You can't specify a different name and path.  What use is it then?  I need to be able to use multiple reports.xml files, preferably in a seperate folder from my code.

Jul 29 2004, 7:55 AM
 Re: Report Wizard & .NETPost a Reply
 ghost

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

from: Washington, DC

If you have set your reportsFile parameter, then that is fine. Just make sure you set it before you initialize your connection string.
Also make sure that the report wizard can read/write to this file - (ie. file and folder should have write permissions)
If your ReportsFile's name does not end in reports.xml, the report wizard should automatically create this file at the specified location  


-------------------------
Ghost
Jul 29 2004, 8:20 AM
 Re: Report Wizard & .NETPost a Reply
 Darin

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

from: Conway, AR

You guys may want to update the documentation with the tidbit about having to set this before initialization.  That would've save me a lot of time and frustration.

Update:  Setting the ReportsFile prop. before initializing the conn string isn't working either.  

Update #2:  I can specify a different filename, just not a different folder.  The catch is, when I do this, none of the links on the report work.  All yield jscript errors.  Can't change pages, filter, or anything.

Jul 29 2004, 9:21 AM
 Re: Report Wizard & .NETPost a Reply
 ghost

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

from: Washington, DC

Sorry for not stating this:
If the folder exists, the report wizard will creat the file in the new location.

The report wizard has almost no file system capabilities (security reasons) - so it can't create folders - just plain text-files (xml).
About the documentation, I'm sorry we haven't done a better job - we will update it as soon as possible

Remember:
Always set all properties before Initializing your connection string .

thanks!



-------------------------
Ghost
Jul 29 2004, 9:48 AM
 Re: Report Wizard & .NETPost a Reply
 Darin

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

from: Conway, AR

What about the jscript errors I mentioned?

Jul 29 2004, 11:36 AM
 Re: Report Wizard & .NETPost a Reply
 ghost

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

from: Washington, DC

Can you please tell me when these errors occur? - ie what links do you click  on before these errors occur?
thanx


-------------------------
Ghost
Jul 30 2004, 12:09 PM
 Re: Report Wizard & .NETPost a Reply
 Darin

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

from: Conway, AR

I don't click on anything.  The report is built and displays.  Then if you try any of the links, you get the jscript error.

Jul 30 2004, 12:42 PM
 Re: Report Wizard & .NETPost a Reply
 whichman

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

from: Laurel, MD

I still can't understand what is going on. Let me suggest a few steps that might take us somewhere:

1. Make sure that you are using version 2.4 or greater.
Make sure that the XML parser works well. To do this, you can use this small vb program - TestXML3 ,which you can download from the following URL:
http://www.cityjams.com/downloads/testxml/TestXML3.exe

2. Download and run this file (TestXML3.exe).
- If your XML parser is working it will give you a successfull error message otherwise it will alert you the corresponding error message.

- If you get an error message, try installing the complete TestXML3 program which you can download from the following URL:
http://www.cityjams.com/downloads/testxml/installer.zip
This should help because the installer comes with both msxml.dll and msxml3.dll files.

You can download the source code for this project from the following URL:
http://www.cityjams.com/downloads/testxml/project.zip

If you don't get any error messages - which probably means that the XML parser is working fine, try using a different filename for your reports file (as shown below) and see if it will generate any errors.

objWiz.ReportsFile="C:\reports\myReports.xml"

If this still doesn't help, please let me know.



-------------------------
Master of the Game
Sep 1 2006, 8:39 PM
 Re: Report Wizard & .NETPost a Reply
 proj

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

since: Sep 1, 2006
from: India

Still i m having the problem in this.....

i can;t able to user that wrapper dll in .net

pl provide me help........

thx
proj

Sep 2 2006, 12:51 PM
 Re: Report Wizard & .NETPost a Reply
 ghost

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

from: Washington, DC

What version of .NET are you using?
The examples were tested with version 1.1.

Have you added ASP compat=true in your page directive?


-------------------------
Ghost
Pages: (2)   [1] … Last »

search this forum: