[sqr-users] Using multiple layouts and reports

[Kevin Laroche <bydesign@magma.ca>]

Hi to all
I can't get this simple thing to work. I have 2 reports that use the same SQL 
statements. 
One needs legal size, the other uses regular paper. I want to select which 
report and 
layout on the basis of the users input. I must have something wrong in the code 
below 
because this code will only ever use the report that is declared first in the 
setup 
regardless of the user input.
What am I doing wrong?

Thanks

BEGIN-SETUP
DECLARE-LAYOUT general !for general report
  PAPER-SIZE = (14, 8.5)
  ORIENTATION = landscape
END-DECLARE


DECLARE-LAYOUT 2YRDETAIL_LAYOUT  !for abstract report
  PAPER-SIZE = (11, 8.5)
  ORIENTATION = landscape
END-DECLARE

DECLARE-REPORT DETAIL
 layout = 2YRDETAIL_LAYOUT
END-DECLARE

DECLARE-REPORT GENERAL
 layout = general
END-DECLARE

END-SETUP


BEGIN-PROGRAM
input $report_type
 IF $report_type = 'A'
  USE-REPORT DETAIL !use regular size paper 
  print 'got to  detail here'  (15,15)
 end-if
 IF $report_type = 'B'
  USE-REPORT GENERAL!use legal paper
 print 'got to general layout here' (15, 100)
 END-IF

END-PROGRAM

Oracle 8.05 Brio 5.1 Windows 2000
Kevin LaRoche Alcea at the Canadian Human Rights Commission
Ottawa, Ontario

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users