Search found 15 matches
- 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...
- 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!!
- 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 ...
- 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...
- 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...
- 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...
- 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. ______
- 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...
- 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 ...
- 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...