Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Web tool for reports
- Thread starter vbajock
- Start date
The best way I have seen is in Access 2002!
You can save a report as XML and it creates a style sheet that formats the web page pretty much exactly in Access.
hth
Ben
----------------------------------------------
Ben O'Hara
"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------
You can save a report as XML and it creates a style sheet that formats the web page pretty much exactly in Access.
hth
Ben
----------------------------------------------
Ben O'Hara
"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------
- Thread starter
- #3
Ahh! Now you have a problem!! It won't export your embeded things!
Your choices now:
1. Buy a pdf generator and print your reports as pdf. You could even automate this if need be.
2. Create everything using asp & html if you want your page to be dynamic.
3. If you only want to update your page periodically, rather than every time you request the page, there is a file on my website called quiz that uses Access to output a static html page filled with data from the database.
Only problem with 2 & 3 is you need to build the web page yourself before you can use them.
hth
Ben
----------------------------------------------
Ben O'Hara
"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------
Your choices now:
1. Buy a pdf generator and print your reports as pdf. You could even automate this if need be.
2. Create everything using asp & html if you want your page to be dynamic.
3. If you only want to update your page periodically, rather than every time you request the page, there is a file on my website called quiz that uses Access to output a static html page filled with data from the database.
Only problem with 2 & 3 is you need to build the web page yourself before you can use them.
hth
Ben
----------------------------------------------
Ben O'Hara
"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------
- Thread starter
- #5
Hello, Ben,
I am reading your exchange with interest, and am wondering if you'd be willing to expound on the #2 option you mentioned, "create everything with ASP and HTML." I have downloaded your Quiz example (thank you very much
), but was really hoping to have a Web page generate from Access 2000 data, where I could have an enduser generate and refresh a report on demand, or refresh a display of data that looks like a report, so that it could be copied/pasted into Word or exported to RTF.
I've done some hunting around and playing with page creation through FrontPage, but report generation is not an option. The output looks like an Access table rather than a report. Being a novice with ASP, I am looking for a push in the right direction to start. I'm really hoping not to have to recreate all my Access reports in Crystal, and am looking for an alternative. Any help at all would be much appreciated!
TIA,
Susan
I am reading your exchange with interest, and am wondering if you'd be willing to expound on the #2 option you mentioned, "create everything with ASP and HTML." I have downloaded your Quiz example (thank you very much
), but was really hoping to have a Web page generate from Access 2000 data, where I could have an enduser generate and refresh a report on demand, or refresh a display of data that looks like a report, so that it could be copied/pasted into Word or exported to RTF. I've done some hunting around and playing with page creation through FrontPage, but report generation is not an option. The output looks like an Access table rather than a report. Being a novice with ASP, I am looking for a push in the right direction to start. I'm really hoping not to have to recreate all my Access reports in Crystal, and am looking for an alternative. Any help at all would be much appreciated!
TIA,
Susan
Susan,
There isn't much more to expand on! Basically you would have to create the design of the report in html, then use ASP to query the access database and insert the data in the relevant places.
The ASP would be doing dynamically what the vba does in the quiz file.
ASP would also let you generate the report in word, assuming word is installed on the server, but you would have to do the whole automation thing yourself.
Let me know if you need more info.
Cheers
Ben
----------------------------------------------
Ben O'Hara "Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------
There isn't much more to expand on! Basically you would have to create the design of the report in html, then use ASP to query the access database and insert the data in the relevant places.
The ASP would be doing dynamically what the vba does in the quiz file.
ASP would also let you generate the report in word, assuming word is installed on the server, but you would have to do the whole automation thing yourself.
Let me know if you need more info.
Cheers
Ben
----------------------------------------------
Ben O'Hara "Where are all the stupid people from...
...And how'd they get so dumb?"
----------------------------------------------
Hi, Ben,
Thanks for the reply. I am betting that it would take me longer to work through the ASP programming than it would to simply recreate the report in Crystal. It looks like there really isn't a quick way to simply take an existing Access report and make it interactively available through the Web, at least with Access 2000. Not even sure if Access 2003 can do this; info out there doesn't seem to address my immediate question. If you are in the know about Access 2003's enhancements with regard to reports and the Web, I would greatly appreciate the info. If not, I will just have to say "thanks anyway" for the advice!
Susan
Thanks for the reply. I am betting that it would take me longer to work through the ASP programming than it would to simply recreate the report in Crystal. It looks like there really isn't a quick way to simply take an existing Access report and make it interactively available through the Web, at least with Access 2000. Not even sure if Access 2003 can do this; info out there doesn't seem to address my immediate question. If you are in the know about Access 2003's enhancements with regard to reports and the Web, I would greatly appreciate the info. If not, I will just have to say "thanks anyway" for the advice!
Susan
Like I mentioned before, if it is a fairly standard report, without any embedded charts/sub reports, you could play with the XML/XSL outputs from Access 2002. I've never used Crystal, so can't comment on that, but producing PDF's are easy and give you an exact output of the report.
I use Zeon Docucom at work and can provide the code for that, but there are a whole range of PDF applications you can use.
hth
Ben
----------------------------------------------
Ben O'Hara "Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------
I use Zeon Docucom at work and can provide the code for that, but there are a whole range of PDF applications you can use.
hth
Ben
----------------------------------------------
Ben O'Hara "Where are all the stupid people from...
...And how'd they get so dumb?"
----------------------------------------------
Thanks for your reply! I may investigate the XML end with 2002 or 2003, but the PDF format is not what I am looking for. I need Web-based interactive function, as I can get with Crystal, rather than read-only output. Thanks again for all your insight!:-D
Susan
Susan
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Helpful tip
