index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard (version 1)
search this forum:
:: Use and Hide tables not working ::    show all messagesPost a New Message | Post a Reply
Oct 16 2003, 9:04 AM
 Re: Use and Hide tables not workingPost a Reply
 whichman

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

from: Laurel, MD

What version of SQL Server are you using? I have tried both connection strings and everything works fine. Views are showing up, HideTables hides tables and UseTables uses only the tables and views listed. Below is the script I used to test this

<%

Dim objReport, strConn
Set objReport = Server.CreateObject("AspWebSolution.ReportWizard")

'SQL Server connection string
'strConn = "Provider=MSDASQL;Driver={SQL Server};Server=THETMAN;Database=Northwind;User ID=sa;Password=sa;"
strConn = "Provider=SQLOLEDB;Network=dbmssocn;Data Source=10.41.3.118;Database=pubs;UID=sa;PWD=sa;"

'objReport.UseTables = "discounts,titleview"
objReport.HideTables = "discounts,titleview"
objReport.ExcludeFromJoins = "UnitPrice"

objReport.Init(strConnectionString)

%>

<h1>My Publications</h1>

<%

objReport.DisplayReports
Set objReport = Nothing

%>


-------------------------
Master of the Game
Pages: (1)   [1]

search this forum: