index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: More Stored Procedures :: (8)Post a New Message | Post a Reply
Aug 13 2004, 6:32 AM
 More Stored ProceduresPost a Reply
 stephensan

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

from: Lisburn

Hi All,

I have installed the trial version of report wizard and have connected it to a MS SQL server running on windows 2000 Pro with IIS as a webserver (its a test box).   The tables are coming up with no problems and I have added a couple of simple reports to make sure I've installed correctly.

I then wrote a stored procdure (simple select statement) and added it to  the database but it does not appear on the default.asp.

I have rebooted the box but this does not raise any reference to the stored procedure.

The reason I'm so keen in getting stored procedures working is that I've inherited a lot of in-house developed access databases which all link tables to a central SQL server and run user interactive querys.  

I'd like to take each of these querys, convert them to use TSQL, and create stored procedures which Report Wizard (the paid for version of course) can generate online allowing users to set dates etc.

This is problably due to something I've not done correctly but any assistance would be a great help.

Cheers

Stephen



Aug 13 2004, 3:24 PM
 Re: More Stored ProceduresPost a Reply
 ghost

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

from: Washington, DC

Make sure your parameter HideProcedures is set to True
and also that there are stored procedures in the database.

let me know if this helps,
thanx!


-------------------------
Ghost
Aug 14 2004, 2:10 AM
 Re: More Stored ProceduresPost a Reply
 stephensan

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

from: Lisburn

There are definitely stored procedures in there but I'm not sure how to check if HideProcedures is set correctly (bit of a new boy to these things)

Cheers

Stephen

Aug 14 2004, 11:27 AM
 Re: More Stored ProceduresPost a Reply
 ghost

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

from: Washington, DC

Honestly, I didn't understand what you just said


-------------------------
Ghost
Aug 15 2004, 7:01 AM
 Re: More Stored ProceduresPost a Reply
 stephensan

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

from: Lisburn

How do I make sure the parameter HideProcedures is set to True ?


Aug 15 2004, 2:17 PM
 Re: More Stored ProceduresPost a Reply
 ghost

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

from: Washington, DC

objWiz.HideProcedures = False


-------------------------
Ghost
Aug 16 2004, 9:50 AM
 Re: More Stored ProceduresPost a Reply
 stephensan

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

from: Lisburn

Should this line be in default.asp?

Aug 16 2004, 10:07 AM
 Re: More Stored ProceduresPost a Reply
 ghost

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

from: Washington, DC

<%
objWiz.HideProcedures = False
objWiz.Init(Connection String)
%>

By default, this property is set to False. If your procedures are not showing up it either means there are no procedures in the database or the report wizard cannot see the procedures.
In order for us to fix this problem, we will need you to email an empty copy of your database backup to support@aspwebsolution.com  so we can test it on our servers.

Let me know if this information helps.


-------------------------
Ghost
Pages: (1)   [1]

search this forum: