Search found 15 matches

by jgould4857
Thu Nov 20, 2008 10:53 am
Forum: R&R ReportWorks Users
Topic: multiple outer (left) joins
Replies: 2
Views: 2326

multiple outer (left) joins

We are using R&R for Windows, SQL Edition Version 12, Build 12.5.000____We have some membership statistical reports that are run monthly. There are three table joins using a "skip" relationship. We have two exception tables that need to be incorporated into the report. We still need th...
by jgould4857
Fri Nov 14, 2008 5:48 pm
Forum: R&R ReportWorks Users
Topic: DB Access error - outer join
Replies: 2
Views: 1932

=> RE: DB Access error - outer join

That did the trick. Perfect____Thanks!!
by jgould4857
Fri Nov 14, 2008 5:48 pm
Forum: R&R ReportWorks Users
Topic: Data Source Connections
Replies: 1
Views: 1521

Data Source Connections

We have a series of SQL reports built in the development environment (server 2). Our production warehouse resides on server 1. The table names and data elements are identical (for most the core reports). I^ve selected the production server through Data Source Connections, but am unable to change my ...
by jgould4857
Wed Nov 12, 2008 9:26 am
Forum: R&R ReportWorks Users
Topic: DB Access error - outer join
Replies: 2
Views: 1932

DB Access error - outer join

I^m using R&R SQL 12.1.001____I have a simple report (no filter) that connects 3 tables together for auditing purposes. One of the connections requires an outer join. When executing this report, the following error message immediately appears.____DB Access: [Microsoft][ODBC SQL Server Driver][SQ...
by jgould4857
Wed Nov 12, 2008 9:26 am
Forum: R&R ReportWorks Users
Topic: Memory error 0x00000004
Replies: 7
Views: 4004

======> RE: Memory error 0x00000004

Hi Kathleen. Sorry, I just read your most recent response. ____I^m not 100% certain that the problem is caused by the volume of returned records. That said, we have found that by reducing the volume of returned records, all the "Memory error 0x00000004" reports will run to completion.____I...
by jgould4857
Thu May 01, 2008 7:36 am
Forum: R&R ReportWorks Users
Topic: Memory error 0x00000004
Replies: 7
Views: 4004

====> RE: Memory error 0x00000004

Hi Patty,____Just read your note. No, we haven^t been able to fix the error. I did find that if I remove all calculated fields from the group/sort areas and limit my scope to a few months of data (less than 2 million records), the report runs fine. The error usually occurs when using the SQL edition...
by jgould4857
Tue Oct 02, 2007 12:37 pm
Forum: R&R ReportWorks Users
Topic: Memory error 0x00000004
Replies: 7
Views: 4004

==> RE: Memory error 0x00000004

I just tried your suggestion, same memory error occurred.____The error also appears when I export the results to a DBF. ______
by jgould4857
Fri Sep 28, 2007 11:26 am
Forum: R&R ReportWorks Users
Topic: Memory error 0x00000004
Replies: 7
Views: 4004

Memory error 0x00000004

Please help. This error message has become a regular occurrence. Our IT support and analytics team has been unable to correct the problem. ____"RSW frequently crashes when trying to preview a report (print preview). The error I receive is "The instruction at "0x73dd11d7" referenc...
by jgould4857
Thu Sep 20, 2007 10:58 am
Forum: R&R ReportWorks Users
Topic: Memory error 0x00000004
Replies: 0
Views: 1447

Memory error 0x00000004

This is in reference to Topic #3619 dated Jun-22-07____RSW frequently crashes when trying to preview a report (print preview). The error I receive is "The instruction at "0x73dd11d7" referenced memory at "0x00000004". The memory could not be "read". Click on OK to ...
by jgould4857
Thu Jun 17, 2004 9:49 am
Forum: R&R ReportWorks Users
Topic: rsw.exe has generated errors
Replies: 3
Views: 2097

==> RE: rsw.exe has generated errors

Kathleen, __Sorry, I forgot to respond to your second question. On two separate occasions (w/ 2 different reports), I did try firing up the problem reports through runtime and experienced the same error. I also tried scheduling them through Rapid Runner - same error.____Good suggestion though. Any o...