RE: [sqr-users] Using multiple layouts and reports

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

Kevin, your code looks fine (though I didn't actually run it)
Use the -F option on the command line to redirect the output to the files
you want rather than letting the filenames default.
e.g. sqr mysqr.sqr connect
string -fdirectory/detail.lis -fdirectory/general.lis
This will give you two outputs: detail.lis and general.lis in the directory
specified.

Steve.

-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of Kevin LaRoche
Sent: Thursday, 12 December 2002 2:12 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Using multiple layouts and reports


Hi Richard
Thanks for your reply. Could you elaborate.... I hoped to share
procedures and select statements between reports by putting them
together in one .sqr that could output a legal size report and a letter
size report. Are you suggesting that I break the program up into
includes and call the layouts as needed?
Thanks



-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org] On
Behalf Of Knapp, Richard
Sent: December 11, 2002 4:54 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Using multiple layouts and reports



Since you now know (or can determine) the full path to the files, try
issuing the print command for those specific files from the call system
command.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: Yingqi Cui [mailto:YCui1@scu.edu]
Sent: Wednesday, December 11, 2002 3:19 PM
To: bydesign@magma.ca; sqr-users@sqrug.org
Subject: Re: [sqr-users] Using multiple layouts and reports


I had the same problem. I found out one report is in one directory you
specified, and the other one ends up in the current directory. They are
named differently: mysqr.lis and mysqr_01.lis. I have difficulty to
direct these two report to the printer.

Yingqi

>>> bydesign@magma.ca 12/11/02 08:15AM >>>
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


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

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

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


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