Important alert: (current site time 7/31/2014 3:05:39 AM EDT)
 

winzip icon

webReports - New Version

Email
Submitted on: 12/2/2004 4:19:40 PM
By: Chad Snyder  
Level: Advanced
User Rating: By 28 Users
Compatibility: ASP (Active Server Pages), HTML, VbScript (browser/client side)
Views: 19962
(About the author)
 
     Revised - This is a new version of my webReports submitted last year. This code will create a report from any database table you specify and your able to export out to an EXCEL/CSV/TXT/XML file. Change the dbase.ini file to point to your database. I added the ability to write your own SQL statement and some other nice futures like saving your custom report for later viewing.. See live demo at http://www.personalwebsolutions.com/webreports/ Don't forget to vote.

 
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!
'**************************************
' for :webReports - New Version
'**************************************
Copyright 2004, Personal Web Solutions
Author - Chad Snyder
chad@personalwebsolutions.com
winzip iconDownload code

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come out every day, so no prevention program can catch 100% of them. For your own safety, please:
  1. Re-scan downloaded files using your personal virus checker before using it.
  2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com

 
Terms of Agreement:   
By using this code, you agree to the following terms...   
  1. You may use this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
  2. You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.   
  3. You may link to this code from another website, but ONLY if it is not wrapped in a frame. 
  4. You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.


Other 4 submission(s) by this author

 


Report Bad Submission
Use this form to tell us if this entry should be deleted (i.e contains no code, is a virus, etc.).
This submission should be removed because:

Your Vote

What do you think of this code (in the Advanced category)?
(The code with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor (See voting log ...)
 

Other User Comments

12/2/2004 7:12:30 PM

Tried out webreports but discovered a bug. If you change the pagesize and press Enter the listing changes to the new page size but you can't navigate to further pages.

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in query expression '[[EmployeeID]]'.
/test/webreports_new/Default.asp, line 566

It seems your code is double bracketing the field names.



(If this comment was disrespectful, please report it.)

 
12/3/2004 7:55:59 AM

Microsoft JET Database Engine error '80040e07'
Tried this website as mentioned in the article.

http://www.personalwebsolutions.com/webreports/

This was the error i get.
I tried to add where clause. Wonder if these kinds of errors are left so we as downloaders can keep your comments list growing.. ?

- Check out this message -
Note : Would have attached the image.. for evidence.. but there wasn't any option..found yet..

Data type mismatch in criteria expression.
/webreports/default.asp, line 566

(If this comment was disrespectful, please report it.)

 
12/3/2004 8:51:47 AMChad Snyder

I will fix both of these and upload the revised version. I will let you know when it is complete.

Thanks!
(If this comment was disrespectful, please report it.)

 
12/3/2004 10:26:51 AMChad Snyder

I have fixed this issue and the zip files has been updated. Thanks

Don't forget to vote!
(If this comment was disrespectful, please report it.)

 
12/4/2004 12:12:31 AM

How about some multi-sorting, column ordering, multi-criteria etc...

Good start though!
(If this comment was disrespectful, please report it.)

 
12/4/2004 11:27:34 AMChad Snyder

You can sort by selecting the field name. It will sort ascended, and descended. The column ordering, I'm working on and the multi criteria I solved by allowing you to write your own SQL statement. I'm thinking of a way to do this through visual tools but have not came up with the perfect plan yet.

This is an on going project so keep checking back.

(If this comment was disrespectful, please report it.)

 
12/4/2004 3:09:55 PMJon Webb

5 Globes - great work, thanks - just put that on a customers site!!!

It would be great to have some extra settings on/off in the ini file - perhaps turning on/off the different report types?

Thanks again

(If this comment was disrespectful, please report it.)

 
12/4/2004 4:14:42 PMChad Snyder

You can show what tables you want to view by editing the ShowTables.txt file and you can turn off the Views by a True/False setting in the default.asp file (at the top).

I have made a couple of other changes today and uploaded a new zip file. Sorry for the new file but I want it to be right.

Thanks for the support!
(If this comment was disrespectful, please report it.)

 
12/6/2004 3:16:57 AM

hi all...
I am not a Wizard in ASP.
I have a question...
How to autofit the record in the column of this script?
Tks...Sal
(If this comment was disrespectful, please report it.)

 
12/13/2004 1:26:28 AMCodeFester

btw, I'm not talking about your report site, which I am still evaluating, I'm talking about the idio+ post above my last one.
(If this comment was disrespectful, please report it.)

 
12/13/2004 11:23:30 AMChad Snyder

I thought so. I reported this so I hope they take it off.

Thanks!

It wasn't me!!!

Don't forget to vote!
(If this comment was disrespectful, please report it.)

 
2/1/2005 12:52:46 AM

do you have this code that can import the EXECEL or TXT to the database . THX
(If this comment was disrespectful, please report it.)

 
2/1/2005 2:18:30 AM

Very very Good. 5 Globes -
please check also the CSS by http://www.htmlhelp.com/tools/csscheck/
you will see same errors.
great work, thanks
(If this comment was disrespectful, please report it.)

 
2/1/2005 8:23:34 AM

Best code I have seen on PSC in a long time. Very nicely done.
(If this comment was disrespectful, please report it.)

 
2/1/2005 8:56:01 AMgordon

5 Globes.... Great Job
(If this comment was disrespectful, please report it.)

 
2/20/2005 11:00:03 PM

i am software developer in asp with sql server.I like your code.It's so nice..thanks for your code...
(If this comment was disrespectful, please report it.)

 
5/19/2005 10:34:41 AMBrian Battles WS1O

This is GREAT! 5 big ones from me... Now if I can figure out how to port it to ASP.NET... :-)
(If this comment was disrespectful, please report it.)

 
6/24/2005 3:39:10 PMtward3017

Anyone no why this error using a SQL DB would be generated.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
(If this comment was disrespectful, please report it.)

 
9/3/2005 1:48:20 AMScorcel

I produces an error when you navigate to other pages then click the sorting... Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC driver does not support the requested properties.
/AMM/AMM_MatBrowser/default.asp, line 691
... Thanks for sharing hope you can give the fix... Thanks again. You got my 5 globes.
(If this comment was disrespectful, please report it.)

 
1/23/2006 10:38:37 PMsri

good.. it's usefull code... thanks
(If this comment was disrespectful, please report it.)

 
2/8/2006 1:33:39 PMDave W

Awsome code, but I'm having a hard time getting this to work on 1 of my machines, the error says: Unspecified error
/dbase.ini, line 16

but I've checked it over and over, its exactley the same code on the other machine and it works like a champ...
(If this comment was disrespectful, please report it.)

 
2/13/2006 11:22:18 PMkryptonboy

i like it men! its great! awesome!
(If this comment was disrespectful, please report it.)

 
12/26/2006 6:50:53 AMgeorj

it's greet job but i need help from you hot to add more conditions like search between dates
(If this comment was disrespectful, please report it.)

 

Add Your Feedback
Your feedback will be posted below and an email sent to the author. Please remember that the author was kind enough to share this with you, so any criticisms must be stated politely, or they will be deleted. (For feedback not related to this particular code, please click here instead.)
 

To post feedback, first please login.