Search found 3 matches

by Craig_M_(Guest)
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...
by Craig_M_(Guest)
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__
by Craig_M_(Guest)
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...