Charlotte Foust
cfoust at infostatsystems.com
Wed Sep 3 12:29:34 CDT 2003
You may have overlooked the fact that you can use subreports to extend the capabilities of Access reporting. The limits in Access reports are the number of controls on a *single* report or subreport and the overall size of the report. There are limitations on the record size in the queries underneath the reports and limitations on the overall size of a record, but you should run into some of the same record size issues if you are using an Access table and DAO behind Crystal Reports. I truly cannot image a comprehensible report that runs to seven pages and 1000 calculations. Charlotte Foust -----Original Message----- From: Paula Wright [mailto:paulawright at boddienoell.com] Sent: Wednesday, September 03, 2003 8:51 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Crystal Reports Resubmit It's been a while since I recreated the reports in Crystal. If I remember correctly the message was something along the lines of "Too many fields defined." These reports are quite extensive with approximately 1000 calculated fields, some on the report, some in the query. Rather than having a detail that changes with the record, each field is based on one record in a table and is a separate field, if you understand what I'm saying. I did check the specs in Access and it truly was beyond the capabilities of Access. There are 7 pages to the report (it's actually all one report) and I broke it down as far as I could into 7 different reports. I have been writing in Access for 7 years and have written some very complex reports. I had never run across that either. It took me quite by surprise, not realizing that it was even possible and it was rather frustrating as I had spent many, many long hours writing these reports. I started with the basic foundation of displaying the base calculations themselves for each report and then went back to include percentages. That's when I ran across the problem. -----Original Message----- From: William Hindman [mailto:wdhindman at bellsouth.net] Sent: Wednesday, September 03, 2003 11:33 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Crystal Reports Resubmit Paula ...can't help you with CR since I don't use it ...but could you elaborate on "Access would not handle all the fields required for the reports" ...I've simply never run into that situation :) ...there may well be a much simpler and better solution available within Access itself if you can give us a bit more information. William Hindman "the world is full of trickery. But let this not blind you to what virtue there is; many persons strive for high ideals, and everywhere life is full of heroism." ...from Desiderata ----- Original Message ----- From: "Paula Wright" <paulawright at boddienoell.com> To: <accessD at databaseadvisors.com> Sent: Wednesday, September 03, 2003 11:07 AM Subject: [AccessD] Crystal Reports Resubmit > > I hope this is better. Funny, I don't remember having this much > trouble before. But thanks for your help. > > I have just been informed that my posts were coming through as > attachments and most readers could not see my question. So I am once > again resubmitting > in the hopes that someone knows how to answer my question. I > apologize and > thank you. > > I have an Access database (XP) from which I created > several Crystal Reports (8.5) because Access would not > handle all the fields required for the reports. I may have gone about > this backwards because now that I have started investigating how to be > able to view the reports in Access I find that one actually must > create the reports through Access when using the Wizard. If so then > hopefully this will be a simple copy/paste procedure once I get into > it. > > The problem is that once I started up the Crystal Report Wizard and > chose the query from which I wanted to create the first report, I was > asked to enter a database password. My database does not have a > password. I have searched for a means to handle this but to no avail. > Has anyone experienced this problem before? > > Or better yet, what I really need to do is view the > reports from within Access using the Crystal Active-X. > I've been over the Accocx97.mdb example on how to set up a > CR in Access, however in XP I don't see a place to put the file name > of the report. > > I'm hoping someone can help me real quick as I've already wasted too > much time re-doing these reports in Crystal after having found out > that Access won't handle them. > > > THANK YOU > > > > Paula Wright > Programmer/Analyst > paulawright at boddienoell.com <mailto:paulawright at boddienoell.com> > (252)937-2800 ext.1355 _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com