Re: Portrait or Landscape from an IF statement

["Benzenhafer, Dave" <DBenzenhafer@DEEPWATER.COM>]

Nathan
The "new-report" lines you sent me earlier did the trick. It was renaming
one of the reports and the program couldn't find it. I learned a new trick
thanks to you. I try to read most of the SQR User Group emails as I tend to
pick up code writing suggestions and ideas from them.

I Thank You for you taking the time to assist me with this problem. I have
being trying to figure it out off and on for a couple of months.

Dave Benzenhafer


-----Original Message-----
From: Nathan Stratton Treadway [mailto:nathant@ONTKO.COM]
Sent: Thursday, April 26, 2001 11:59 AM
To: SQR-USERS@list.iex.net
Subject: Re: Portrait or Landscape from an IF statement


On Wed, Apr 25, 2001 at 11:58:31AM -0500, Benzenhafer, Dave wrote:
> Setup and Header/Footer Sections. The problem was that the report would
> always run in the Portrait orientation even though the Selection parameter
> was yes and I couldn't seem to be able to force it to landscape.

The code you quoted (as well as the get-report-parameters procedure you
sent me separately) look okay.

Try putting a "show $p_mfg_rpt" at the very top of Print_Detail so that
you can be sure the variable is actually getting set to 'Y';  if
no rows are selected in get-report-parameters then $p_mfg_rpt will be
blank and Print_Detail will chose Portrait mode.

Also keep in mind that (unless something else is going on outside of the
code sections you quoted) when the report chooses Landscape mode the
output file will be called "reportname_01.ext" instead of
"reportname.ext".  If you are only looking at "reportname.ext", you'll
only see the output of Portrait-mode runs.

(If that turns out to be the problem, you might want to add the
"new-report" lines I sent in my earlier message to the bottom of
get-report-parameters [replacing the "use-report" lines that are
currently in print_detail, since you really only need to execute them
once at the beginning of the program].)

Let me know how it goes.

                                                Nathan
----------------------------------------------------------------------------
Nathan Stratton Treadway  | Ray Ontko & Co. | Software consulting services
nathant@ontko.com         | Richmond, IN    | http://www.ontko.com/