Search found 4 matches
- 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
- 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 ...
- 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...
- 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...