Search found 4 matches

by Thomas_Ruschak_(Guest)
Thu Jun 20, 2002 3:59 am
Forum: R&R ReportWorks Users
Topic: Convert normal report to User-SQL
Replies: 1
Views: 1563

Convert normal report to User-SQL

Is there any easy way to convert a normal report (where R&R constructs the SQL string for you) into a user-SQL report?____Tom
by Thomas_Ruschak_(Guest)
Thu Jun 20, 2002 3:49 am
Forum: R&R ReportWorks Users
Topic: Multiple Scan Reports w/SQL
Replies: 1
Views: 1278

Multiple Scan Reports w/SQL

What^s the best way to do multiple scan reports with SQL?____I read this technote:____http://www.livewarepub.com/ftp/TechDocs/Multi-Scans_in_SQL.PDF____It involves setting up a complicated union of two SQL queries. It seems like an awful lot of work for something that was so simple with Dbase files ...
by Thomas_Ruschak_(Guest)
Wed May 01, 2002 2:05 pm
Forum: R&R ReportWorks Users
Topic: Joining tables across databases
Replies: 3
Views: 2107

=> RE: Joining tables across databases

>Hi - I am new to R&R, having recently purchased SQL Edition __>v9.0. __>__>I understand that Auto SQL will not allow table joins across __>databases and that a User SQL statement is required. __>__>I have established 2 data source connections to SQL Server __>2000. __>__>My problem is that when...
by Thomas_Ruschak_(Guest)
Fri Apr 26, 2002 12:27 pm
Forum: R&R ReportWorks Users
Topic: SQL Problems
Replies: 2
Views: 1574

SQL Problems

I^m trying to convert some old RR5 reports to RR9 (v9.0.009) SQL.____I have a SQL Server with tables corresponding to the old dbf files. I have converted the RR5 reports to an RR9 XBase report, just to make sure it works, which it does.____Now, I try and use the Report Conversion Wizard to change th...