Jon Tydda
Jon.Tydda at alcontrol.co.uk
Mon Jun 7 10:48:23 CDT 2004
We're using Crystal Reports and Excel because the development team have been using Crystal Reports, and I know Excel... afaik, no-one here has used Access (including me), so we don't have the slightest clue where to start. And we think we're getting that message because we didn't "tie the tables together" if that makes any sense to you - it was trying to process a bajillion bits of data and couldn't. According to our "experts"... :-) What we've done now works ok, so I assume we've fixed it, or are doing it correctly, but thanks :-) Jon -----Original Message----- From: Gary Kjos [mailto:garykjos at hotmail.com] Sent: 07 June 2004 16:34 To: dba-tech at databaseadvisors.com Subject: RE: [dba-Tech] Crystal reports I don't know about Crystal Reports, but I do regular Access Reports and queries from Oracle Databases all the time and have no problems. How many rows are you dealing with? Why are you using Excel? I wonder if the Excel limit of 65K rows is causing a problem? Gary Kjos garykjos at hotmail.com >From: Jon Tydda <Jon.Tydda at alcontrol.co.uk> >Reply-To: Discussion of Hardware and Software >issues<dba-tech at databaseadvisors.com> >To: "Dba-Tech (E-mail)" <dba-tech at databaseadvisors.com> >Subject: [dba-Tech] Crystal reports >Date: Mon, 24 May 2004 10:37:12 +0100 > >I've got an Oracle database which I'm trying to write a report from, by >extracting data through Cystal Report and/or Excel (MS Query). I'm using >Win2k, Office 2k and Crystal Reports 9.0 sp3 on a P4 1.5 with 512mb RAM and >2048mb page file, and I keep getting the message "memory full"... which is >slightly annoying to say the least. > >Does anyone have any ideas how I'd get around that? > > >Jon > > >The information in this e-mail is confidential and may also be legally >privileged. The contents are intended for recipient only and are subject >to the legal notice available on request from : webmaster at alcontrol.co.uk >ALcontrol Laboratories is a trading division of ALcontrol UK Limited. >Registered Office: Templeborough House, Mill Close, Rotherham, S60 1BZ. >Registered in England and Wales No 4057291 >_______________________________________________ >dba-Tech mailing list >dba-Tech at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-tech >Website: http://www.databaseadvisors.com _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available on request from : webmaster at alcontrol.co.uk ALcontrol Laboratories is a trading division of ALcontrol UK Limited. Registered Office: Templeborough House, Mill Close, Rotherham, S60 1BZ. Registered in England and Wales No 4057291