[dba-Tech] Crystal reports

Ahhhh. Bad or missing join. Cartesian product


http://www.metrokc.gov/gis/kb/Content/SQLTipJoin.htm



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: "'Discussion of Hardware and Software 
>issues'"<dba-tech at databaseadvisors.com>
>Subject: RE: [dba-Tech] Crystal reports
>Date: Mon, 7 Jun 2004 16:48:23 +0100
>
>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
>_______________________________________________
>dba-Tech mailing list
>dba-Tech at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-tech
>Website: http://www.databaseadvisors.com