Search found 4 matches

by StevenZog
Wed Aug 06, 2008 7:26 am
Forum: R&R ReportWorks Users
Topic: R&R SQL
Replies: 1
Views: 1404

R&R SQL

Hello;__I have a problem running one of my reports in R&R SQL. Initially, the report was created in R&R Xbase, since all of our data were in dbase database files. We are currently migrating to MS SQL 2005 Server. We^ve imported all of our data into the SQL Server. ____Now, the report I am ha...
by StevenZog
Fri Aug 01, 2008 11:52 am
Forum: R&R ReportWorks Users
Topic: Joins with R&R v12
Replies: 0
Views: 1672

Joins with R&R v12

I am unable to join multiple tables in version 12. I have selected the customer table as my master and want to add two related tables. When I add the first one,(demand) it allows me to do a left outer join but when I try to add the second table,(demand transactions) the option is grayed out: I also ...
by StevenZog
Tue Jul 29, 2008 10:10 am
Forum: R&R ReportWorks Users
Topic: non-ANSI
Replies: 2
Views: 1678

==> RE: non-ANSI

That did it! Thank you very much!
by StevenZog
Thu Jun 26, 2008 7:57 am
Forum: R&R ReportWorks Users
Topic: non-ANSI
Replies: 2
Views: 1678

non-ANSI

I have an employee using R&R Report Writer version 10. She is attempting to join two SQL Server 2005 tables together. This is the error she is getting:____"DB access: [Microsoft][ODBC SQL Server Driver][SLQ Server] The query uses non-ANSI outer join operators ("*=" or "=*&quo...