Jim DeMarco
Jdemarco at hudsonhealthplan.org
Mon Mar 22 14:53:39 CST 2004
There was an article in the October 2003 Smart Access on dynamically creating XML reports in A2K2 using .NET that I thought looked doable in ASP (actually sending criteria to an existing report and outputting it as XML). For a primer on XML reports Susan and I wrote an article on the basics of Access XML reporting for Inside Microsoft Access but I couldn't find my copy to give you the date. Sometime last year though. HTH, Jim DeMarco Director Application Development Hudson Health Plan -----Original Message----- From: Susan Harkins [mailto:ssharkins at bellsouth.net] Sent: Monday, March 22, 2004 2:24 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Using Access for Reports w/an ASP app? So far, the main differences I've run across are: 1. The Snapshot Viewer control is a much simpler technique. You don't need any real expertise with Access or SV to use it. Generating a web-ready report with Access is fairly easy, but you have to know what you're doing -- even if you use the ui. 2. The XML feature generates an actual page which means everytime you have to update the report, you have to update the actual Web page. With the SV, you just save the new .snp file to the appropriate Web folder. You don't have to actually update the page with the XML code for the new report. Now, there may be a way around that one, but I don't know what it is besides automation, which kind of negates the need for the SV technique in the first place. 3. The SV gives you an exact copy -- can't get that with XML. This isn't a recommendation for SV and against XML by any means. It's just a coincidence that I happen to be writing about the SV technique and I had to think through the advantages/disadvantages -- just didn't want to miss anything if I could help it. Susan H. Honestly don't know Susan. To be quite frank, I have never used either. It's very simple to have Access 'export' a report, to a file, which is then 'redirected' through ASP to the user. The system I built was put in place due to the 'prompts' that the reports were giving, which were no problem on the local LAN, where the users had direct access with Access, but for remote users, those reports took forever, and Terminal Server was getting bogged down (not too mention they were having printing problems). Quite frankly, I like snapshot files better then any other format, simply because I find that it keeps the 'formatting' closer to the actual report (in my experience). But I have never used the 'snapshot Viewer control'. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************************** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ***********************************************************************************