index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard (version 1)
search this forum:
:: Table Relationships & purchasing info :: (17)Post a New Message | Post a Reply
Oct 3 2003, 11:10 AM
 Table Relationships & purchasing infoPost a Reply
 jt102763

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

since: Oct 1, 2003
from: somewhere

In your online demo, one can select two tables such as Customers and Orders.  On the next screen of the demo, the relationship between these two tables is known and is in the text box.

In the version I downloaded to try, when I select two of my tables, there is no relationship information present.  I have to key it manually.  In my SQL server database, I do have a relationship setup between the two tables.

How do I get the app. to know the relationship between tables?

I have a couple of other questions.

On your download/purchase page, to buy the product requires you to enter a url.  I would be using this product in an intranet asp application that I have developed and, in as such, it has no url.  It would be running 'localhost" or in house only.  How can the product be purchased without a url entry?  Also, on the purchased version, does the "ASP Web Solution" copyright info show up on all report pages like is does on the free version?

Also, on purchasing the source, if someone wanted that, is the price negotiable?

Thanks.

Oct 5 2003, 12:24 AM
 Re: Table Relationships & purchasing infoPost a Reply
 Ghost

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

from: Washington, DC

How do I get the app. to know the relationship between tables?

In the current version, It will recognize the relationships if both field names are the same. The reason we did not want to query the whole database schema is because of speed issues - we wanted the report wizard to run as fast possible. This might change however in a future release.

On your download/purchase page, to buy the product requires you to enter a url. I would be using this product in an intranet asp application that I have developed and, in as such, it has no url. It would be running 'localhost" or in house only

Any URL would do e.g. http://www.aspwebsolution.com, http://localhost, http://MikesPC..etc..

Also, on the purchased version, does the "ASP Web Solution" copyright info show up on all report pages like is does on the free version?

No. The copywrite information shows up only on the free version.





-------------------------
Ghost
Oct 8 2003, 10:03 AM
 Re: Table Relationships & purchasing infoPost a Reply
 jt102763

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

since: Oct 1, 2003
from: somewhere

In the free version that I am testing, my two tables do have fields with the same name, but the wizard does not automatically use them as join fields.  Table 1 has Vendor information with fields VendorID, name, address, etc.  Table 2 has contract information and has fields ContractID, VendorID, contract type, etc.  The field VendorID is in both tables and has the same properties in both tables.  It is the primary key in the Vendor table, while ContractID is the primary key in the Contracts table.

Also, the column where saved reports are shown has an error message "Errors occured", "Access is denied".

I would like to buy the product but I want to be certain that it works as it appears in your demo.

Oct 8 2003, 6:25 PM
 Re: Table Relationships & purchasing infoPost a Reply
 Ghost

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

from: Washington, DC

In the free version that I am testing, my two tables do have fields with the same name, but the wizard does not automatically use them as join fields. Table 1 has Vendor information with fields VendorID, name, address, etc. Table 2 has contract information and has fields ContractID, VendorID, contract type, etc. The field VendorID is in both tables and has the same properties in both tables. It is the primary key in the Vendor table, while ContractID is the primary key in the Contracts table.

I have set up a small example from your database specifications. It works great. If you would like to see it, go to
http://www.aspwebsolution.com/products/demos/test



Also, the column where saved reports are shown has an error message "Errors occured", "Access is denied".


Check the folder in which your reports.xml file is a make sure you have read/write permissions on it


I would like to buy the product but I want to be certain that it works as it appears in your demo.


We do premium support for our customers. Should you purchase our product, we will work closely with you to make sure that it meets your needs



-------------------------
Ghost
Oct 9 2003, 2:48 PM
 Re: Table Relationships & purchasing infoPost a Reply
 jt102763

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

since: Oct 1, 2003
from: somewhere

Your example works like what I want, but my download version won't produce the same results.  In the example you created, the only key field in Vendors table is VendorID and the only key field in Contracts table is ContractID, correct?  In the Contracts table, VendorID is not a part of the key at all?

On the Access denied error, you were correct about the authority to write to that folder for all users, I do not have that erroe message now.

Oct 9 2003, 3:15 PM
 Re: Table Relationships & purchasing infoPost a Reply
 ghost

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

from: Washington, DC

The database is really simple: 2 tables Vendors(VendorID, Name, Address) and Contracts(ContractID,VendorID,Contract Type ). Thats all.. if you want you can download a copy from here

http://www.aspwebsolution.com/products/demos/test/db.mdb



-------------------------
Ghost
Oct 9 2003, 7:06 PM
 Re: Table Relationships & purchasing infoPost a Reply
 jt102763

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

since: Oct 1, 2003
from: somewhere

I downloaded your test db and it does work correctly.  The next question I need to know is why doesn't it work on a sql server database if it does on an Access database?  Being certain of this is about the only thing stopping me from buying the source code.  I want it to automatically know the join fields, since my user's most likely won't know them.

Oct 10 2003, 10:45 AM
 Re: Table Relationships & purchasing infoPost a Reply
 Ghost

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

from: Washington, DC

This bug has been fixed.
Download the latest version build - 1.0.0.18 from
http://www.aspwebsolution.com/products/downloads
and try it out.
I hope this takes care of your problem.

Regards,
Mike


-------------------------
Ghost
Oct 10 2003, 11:39 AM
 Re: Table Relationships & purchasing infoPost a Reply
 jt102763

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

since: Oct 1, 2003
from: somewhere

I'm sorry to continue to be a pest, but now that you have fixed the bug where the wizard did not find any joins in sql server, now it joins on every field that has the same name in the selected tables.  My tables have fields named "memo", it's just an area to keep a note on the vendor or contract.  These fields couldn't be used to join on at all.  I can understand why I'm getting this since the design of the wizard is to join tables when the field names are the same, but there may need to be another fix for this.  Maybe only join on like named fields when one of them is the table key?  Is that possible?

Also, the count summary feature is not working, in either my downloaded version or your online demo.  I have a report on your demo titled "Customer Report for Totals".  It chould have the count of customers, but is shows "COUNT CustomerID" at the bottom of the report.

Oct 10 2003, 2:23 PM
 Re: Table Relationships & purchasing infoPost a Reply
 whichman

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

from: Laurel, MD

We have a lot of customers who have very unstructured datasets so even looking for a primarykey will not be very usefull.
The easiest way to overcome this problem is by creating views to your tables. Besides, if two or more tables have the same field names the field names have to be prefixed with the table names else the SQL query would fail.
If you have any suggestions, please let me know and I would be glad to help.

About the COUNT issue, I have just fixed it. An updated version is available at the downloads http://aspwebsolution.com/products/downloads


-------------------------
Master of the Game
Oct 10 2003, 4:25 PM
 Re: Table Relationships & purchasing infoPost a Reply
 jt102763

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

since: Oct 1, 2003
from: somewhere

I created three views in sql server but none of them show up in my version of the wizard like they appear to in your demo.  Is there something else that needs to be done for them to show?

Oct 10 2003, 6:55 PM
 Re: Table Relationships & purchasing infoPost a Reply
 whichman

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

from: Laurel, MD

I thought I had fixed that bug.
What version of the ASPReportWizard.dll are you using?


-------------------------
Master of the Game
Oct 10 2003, 7:04 PM
 Re: Table Relationships & purchasing infoPost a Reply
 whichman

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

from: Laurel, MD

The me see the connection string you are using to access the SQL Server, it might be the problem.



-------------------------
Master of the Game
Oct 10 2003, 8:36 PM
 Re: Table Relationships & purchasing infoPost a Reply
 whichman

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

from: Laurel, MD
What if I added the option to exclude certain field names from your tables' relationship such as:

objReport.ExcludeFromJoins("Memo,Description,SomOtherFieldNames")

Can this be a possible solution?




-------------------------
Master of the Game
Oct 11 2003, 1:37 PM
 Re: Table Relationships & purchasing infoPost a Reply
 jt102763

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

since: Oct 1, 2003
from: somewhere

I am using version 1.0.0.19 of the wizard.  I also have the older one's, but this is the latest that I have.  Here is the connection string that I am using.  strConnectionString = "Provider=SQLOLEDB;Network=dbmssocn;Data Source=192.168.200.152;Database=Scheduler;UID=ustdbuser;PWD=ustdbuser;"


Oct 13 2003, 9:16 AM
 Re: Table Relationships & purchasing infoPost a Reply
 jt102763

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

since: Oct 1, 2003
from: somewhere

Your idea to add a method to eliminate certain fields from consideration in determining table relationships sounds good to me.

Oct 13 2003, 11:26 AM
 Re: Table Relationships & purchasing infoPost a Reply
 whichman

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

from: Laurel, MD

Hi,
You can now exclude certain fields from appearing in table joins by using the property ExcludeFromJoins.

Note: This property must be used before the Init. as below:

'SQL Server connection string
strConnectionString = "Provider=MSDASQL;Driver={SQL Server};Server=WHICHMAN;Database=Northwind;User ID=sa;Password=sa;"

objReport.ExcludeFromJoins = "UnitPrice,Memo,Field 4"

'NOTE: You must call the Init procedure before adding any HTML Tags/Text into your page
objReport.Init(strConnectionString)
[/code]


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

search this forum: