Search found 3 matches
- Tue Nov 17, 2009 11:15 am
- Forum: R&R ReportWorks Users
- Topic: SQL Error with outer joins
- Replies: 0
- Views: 2140
SQL Error with outer joins
"Query contains an outer-join request that is not permitted"__I am getting this SQL error when I create a Left Join to a database, and a second Left Join to a database off the first database.__I believe it has something to do with the way the SQL query is being built. Is there any way arou...
- Tue Aug 25, 2009 4:03 pm
- Forum: R&R ReportWorks Users
- Topic: expression for last page of group
- Replies: 4
- Views: 3272
expression for last page of group
V12.5 SQL __Is there an expression I can use to determine last page of a group or page x of x?____thanks!__Craig__
- Tue Aug 25, 2009 4:00 pm
- Forum: R&R ReportWorks Users
- Topic: conditional bands in group footer.
- Replies: 1
- Views: 1529
conditional bands in group footer.
We have a report with 1GH, Record, 1GF and PF using RW 12.5 SQL__1GF is set to Swap Footer____In 1GF we have a log of band lines with conditions to print when true.__I have found that when the condition is false(dont print), the program does not print these lines, but it makes virtual space for them...