gderoeck
asked on
Crystal Reports, ASP - How to create a web site to run reports out of MS Access 2000 tables
Hello!
I'm in the process of planning an intranet site that can be used by managers, supervisors, etc to run reports on certain metrics straight from that web site. I have tables and databases in MS Access 2000, Crystal Reports knowledge, and ASP writing experience, but have never developed pages that do this particular thing before. Can anyone give me resources, online or otherwise, that would be helpful putting this together? Also, anyone ever done anything like this before and can give me some insight as to what I'm getting myself into? Thanks in advance!
I'm in the process of planning an intranet site that can be used by managers, supervisors, etc to run reports on certain metrics straight from that web site. I have tables and databases in MS Access 2000, Crystal Reports knowledge, and ASP writing experience, but have never developed pages that do this particular thing before. Can anyone give me resources, online or otherwise, that would be helpful putting this together? Also, anyone ever done anything like this before and can give me some insight as to what I'm getting myself into? Thanks in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad I could help
mlmcc
mlmcc
I currently work for a company of 3,000+ users and engineer and create the entire intranet. I use MS Access extensively in conjunction with outputs from Lawson and Crystal. The key I find is to create all the tables, joins, queries you wish to have inside the access database. This would include any form data captures, counters, reporting mechanices within the DB. When you have the info constructed to your standards use a DNS less connection string (such as 'CreateObject' method ect.) in conjunction with CSS. I design layouts using tables to maintain format design and multibrowser display. I always attach the connections to queries so that everytime a page is opened it runs the query and refreshes information in a 'live' fashion.
ASKER