MartyConnelly
martyconnelly at shaw.ca
Thu Jul 8 18:15:47 CDT 2004
Here is a new article that came out yesterday MS Access for the Business Environment: "Upsize" MS Access Reports to MS Reporting Services. http://www.databasejournal.com/features/msaccess/article.php/3373661 It explains how you can import an Access Report from an mdb or adp into MS SQL Reporting services and save as an .rdl file. It also explains the features of MS Access Reports that require at least some intervention as part of conversion. This may only work with importing Access 2002 reports supposedly real soon now Crystal Reports will be added and you may need Microsoft Visual Studio .NET 2003 to get this to work Steven W. Erbach wrote: >Gustav, > > > >>>have you considered using Access as a server side printing engine? On the web-server or a separate server you run Access which somehow monitors the web site and prints reports on demand to a pdf-printer which saves the pdf-files in a directory on the web-server. << >>> >>> > >Very clever! The web host I've recommended to my client (CrystalTech) has Access support. I have a feeling that there'd be some maintenance issues I'd have to watch for. > > > >>>It's not that easy as it sounds, I know << >>> >>> > >I'll just bet. I appreciate the response. > >Regards, > >Steve Erbach >Scientific Marketing >Neenah, WI >920-969-0504 > >"The central conservative truth is that it is culture, not politics, that determines the success of a society. The central liberal truth is that politics can change a culture and save it from itself." - Patrick Moynihan > > >_______________________________________________ >dba-Tech mailing list >dba-Tech at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-tech >Website: http://www.databaseadvisors.com > > > -- Marty Connelly Victoria, B.C. Canada