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. This code works very much like ASP Report Wizard but simplified. I did use the ASP Reports Wizards export.asp page with some minor modifications. I plan in the near future to have multiple where statements and joined table functionality.
Change the dbase.inc file to point to your database.
See live demo at http://www.personalwebsolutions.com/webreports/
Don't forget to vote.
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:
Re-scan downloaded files using your personal virus checker before using it.
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...
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.
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.
You may link to this code from another website, but ONLY if it is not wrapped in a frame.
You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
I'm not sure what problems you are having but you should only have to change the location of where your database sits. You change this in the database.inc file. The file needs to be in a folder under your web page. Let me know if you have any more problems. (If this comment was disrespectful, please report it.)
1. please use template for exporting 2. please allow user to use css so as there will be a lot less hard-code html tags like "bgcolor=#ff0000" etc. (If this comment was disrespectful, please report it.)
I really like your work. Have been working on a similar, but simpler code myself. One thing I did that I think looks better and more efficient is the use of a multiple select list instead of using checkboxes. The same would also be nicer for te table select option. A drop down list would be nicer (in my opinion), and a second possibility to select from queries as well. My own next investigaions will be in selecting with multiple where clauses, although I dont kno how to make this efficient in this kind of a query yet.
Trond (If this comment was disrespectful, please report it.)
Thanks, you can also see the queries with the tables by changing the ShowTablesOnly to FALSE. Your right I may want to change the check boxes to dropdowns. Thanks for your suggestions. Don't forget to vote. (If this comment was disrespectful, please report it.)
I know that’s where I got the idea. I love ASP Report Wizard but wanted to have the ability to join tables and have multiple were clauses. I have not finished the code yet but plan to soon. That’s the reason why I wrote my own version of your product. Also wanted the experience. (If this comment was disrespectful, please report it.)
1/2/2004 11:32:41 AM:
This is great! I'm glad to see someone pick this project back up. The other one you mentioned is no longer free. They charge for it, bugs and all!
In any case - I have a lot of ideas for you. I'd be glad to help or give input. Contact me via email. (If this comment was disrespectful, please report it.)
I viewed your work on your site and was thouroughly impressed. I'm trying to get it to work using MySQL. Here's the error I recieve followed by my connection string. Is there something I'm missing? Thanx, Mike Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.16-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '[meetinglist]' at line 1
/index.asp, line 89 Set MyConn=Server.CreateObject("ADODB.Connection") MyConn.Open "DRIVER={MySQL ODBC 3.51 Driver};" & _ "SERVER=localhost;"_ & "DATABASE=blahblah;"_ & "UID=blahblah;PWD=blah; OPTION=35;" (If this comment was disrespectful, please report it.)
3/5/2004 7:24:02 AM:
i found it very intersting carry on with ur good work. best of luck (If this comment was disrespectful, please report it.)
Thank you so much! (If this comment was disrespectful, please report it.)
3/12/2004 11:33:00 AM:
why i can't run your code?
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /ASP_Report/dsn.asp, line 13
can you give me solutions?
i will surely vote for you..tnx
(If this comment was disrespectful, please report it.)
Try changing the permision on the database and database folder to include "IUSER_machinename" give this full permissions. Let me know if this works. Thanks! Chad (If this comment was disrespectful, please report it.)
3/14/2004 11:45:39 PM:
Still nothing new yet? Hung-up on something? (If this comment was disrespectful, please report it.)
Have you done a search on this error? Try this link "http://support.microsoft.com/default.aspx?scid=kb;en-us;q306518" (If this comment was disrespectful, please report it.)
Man this source is really good job but no security measures are taken into consideration. Your authoring talent is glowing but this source, the way it is, is of no use. Even an amateur with little knowloedge of SQL could inject your source. For example click on the orders table, and move your mouse pointer over an export option (eg. Excel) Right click on it and select "Copy Shortcut". Finally paste it on the explorer address bar, change "select" to "Delete" and press enter. Boom! There goes [Orders] and [Order Details] due to their reationship. i won't vote but if you fix it i will post for 5. (If this comment was disrespectful, please report it.)
I wrote this in a couple of hours and thought it may be useful for others. Your right you would need to fix some of the security issues if you wanted to use this in a production environment.
Thanks for the post I will look into fixing this ASAP.
(If this comment was disrespectful, please report it.)
5/23/2004 1:46:45 AM:
(indonesia)anda memang layak mendapat bintang... (If this comment was disrespectful, please report it.)
5/27/2004 11:08:50 PM:
thanks by your code (If this comment was disrespectful, please report it.)
7/23/2004 8:35:13 AM:
Ohhh this is good!! Once of the best (if not the best) export codes i've seen. Love the Excel/CSV/XML choice,
Nice one Chad. (If this comment was disrespectful, please report it.)
9/2/2004 11:55:29 PM:
No new progress? (If this comment was disrespectful, please report it.)
I used your code in another project I posted here for WMI IIS Monitor to generate reports it is great I hope it's ok I added it to mine if not let me know (If this comment was disrespectful, please report it.)
3/17/2005 8:29:56 PM:
This worked out great for me. I couldn't figure out how to do aggregation (sum function) easily, so I just used the access queries that were doing it already. Since I then really only wanted queries that had been built for my Access database, I changed the objTable.Type to be VIEW to see them and listed the queries by name in the strTables variable. The "where" conditions worked fine with the queries. I had to change the name of the aggregated fields in the query, since Access was naming them "Sum of fieldx" and when I tried to sort by clicking the column header of the aggregated field I got an error. Renaming the aggregate in the Access query to "fieldx_sum" fixed that problem. Overall, I am very happy with the results and the professional looking output. Thanks! (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.)
By 26 Users
Download code
12/18/2003 8:54:10 AM: 
