AspWebSolution Forums » Products » ASP Report Wizard (version 1)

index | search | no replies | posting guidelines | help

» »

:: Use and Hide tables not working :: (13)

Post a New Message | Post a Reply

Oct 13 2003, 7:41 PM

Use and Hide tables not working

Post a Reply

jt102763

since: Oct 1, 2003
from: somewhere

I tried to add the property to hide tables and also tried to add the use tables property. Both give the following error - "Wrong number of arguments or invalid property assignment:". This is one of the lines I tried in my asp page -"objReport.UseTables("Growers,Contracts,Deliveries")

Oct 13 2003, 10:14 PM

Re: Use and Hide tables not working

Post a Reply

whichman

from: Laurel, MD

objReport.UseTables = "Growers,Contracts,Deliveries"

-------------------------
Master of the Game

Oct 13 2003, 10:50 PM

Re: Use and Hide tables not working

Post a Reply

jt102763

since: Oct 1, 2003
from: somewhere

I used your code to call the properties and I now do not get the error message, but neither of the properties work. It doesn't show only the tables I choose, nor does the hide not show the tables I select for it. I tried using them right before call to objReport.Init and also right before the call to objReport.DisplayReports. I tried using the property calls one at a time individually and together.

Oct 14 2003, 10:09 AM

Re: Use and Hide tables not working

Post a Reply

Ghost

from: Washington, DC

You cannot use both of them toghether.
Use these properties separately.

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

Oct 14 2003, 10:40 AM

Re: Use and Hide tables not working

Post a Reply

jt102763

since: Oct 1, 2003
from: somewhere

As my previous message stated, I did attempt to use them separately. They still did not work.

I still also cannot get any views to show up.

Oct 14 2003, 10:48 AM

Re: Use and Hide tables not working

Post a Reply

ghost

from: Washington, DC

Can I see the connection string you are using!

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

Oct 14 2003, 10:59 AM

Re: Use and Hide tables not working

Post a Reply

jt102763

since: Oct 1, 2003
from: somewhere

I have tried TWO different connection strings. The first is as follows - strConnectionString = "Provider=SQLOLEDB;Network=dbmssocn;Data Source=192.168.200.152;Database=Scheduler;UID=ustdbuser;PWD=ustdbuser;"

This is the string that I have been using for my other database access. I have also tried the version that you show in your demo as shown below.

The second is - strConnectionString = "Provider=MSDASQL;Driver={SQL Server};Server=192.168.200.152;Database=Scheduler;UID=ustdbuser;PWD=ustdbuser;"

Neither of these affect the ability to see views. The only difference has been that the table "dtproperties" shows when I use the second connection string.

Oct 15 2003, 2:57 PM

Re: Use and Hide tables not working

Post a Reply

jt102763

since: Oct 1, 2003
from: somewhere

I have posted the information on the connection strings that I have tried to use. I have tried every combination I can think of to try to get the "Use" and "Hide" properties to work correctly. Please provide some direction on this.

Oct 16 2003, 9:04 AM

Re: Use and Hide tables not working

Post a Reply

whichman

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

Oct 16 2003, 10:13 AM

Re: Use and Hide tables not working

Post a Reply

jt102763

since: Oct 1, 2003
from: somewhere

Tanwani,

I tried your example and had the same results, it didn't work. I have sent you email containing my asp and the resulting page when displayed. I am using SQL Server 2000 and version 21 of the wizard. Thanks.

Oct 16 2003, 11:01 AM

Re: Use and Hide tables not working

Post a Reply

whichman

from: Laurel, MD

I belive the bug has been fixed.
Please upgrade to the latest version 1.0.0.26 and let me know if it works.

http://www.aspwebsolution.com/products

-------------------------
Master of the Game

Oct 16 2003, 11:37 AM

Re: Use and Hide tables not working

Post a Reply

jt102763

since: Oct 1, 2003
from: somewhere

TANWANI!

I believe we may have it!! It looks like it works correctly now! I can see the views that I created and the "Use" & "Hide" appear to be doing their job. I will test more, but it looks good right now. THANKS!

Just a note, you said to download version 26, but the one I got on the download page was version 25. Didn't know if the latest isn't on the download site or what.

Oct 16 2003, 12:06 PM

Re: Use and Hide tables not working

Post a Reply

whichman

from: Laurel, MD

You are right. It is the 1.0.0.25 build. I must have been confused for some reason...was trying to get the DLL's up quickly enough..we have a response time time limit which I was trying to meet. Thanks for pointing that out.

-------------------------
Master of the Game

Pages: (1) [1]