Re: (SQR 5007) Report 'default' has overlapping heading and footi ng

["Brown, Bryan" <bbrown2@ACSALASKA.COM>]

Thanks for the info, unfortunately, I have checked that. Currently, I am
using only the default. I have no headings or footings defined in the report
at all...

That is sort of the problem, as I don't want any headings or footings in the
report. The error seems to be stating that I am trying to print in the
heading area, and I can't find how to tell it not to reserve any space for a
header or footer...sigh....

Thanks for the response though - have a good one!

Bryan

-----Original Message-----
From: St.Andre, Patricia [mailto:Patricia.St.Andre@MARRIOTT.COM]
Sent: Tuesday, July 25, 2000 1:21 PM
To: SQR-USERS@list.iex.net
Subject: Re: (SQR 5007) Report 'default' has overlapping heading and
footi ng


Make sure that you specify the for-reports option on any footings or
headings you have defined if you are using one or more report layouts....

For example,

begin-footing 33 for-reports = (Report_Name)

The error you are getting leads me to believe that you have defined one or
more headings / footings in your SQR but have not specified a report layout
to be used for each defined heading and footing....

Hope this helps!

Trish

> -----Original Message-----
> From: Brown, Bryan [SMTP:bbrown2@ACSALASKA.COM]
> Sent: Tuesday, July 25, 2000 4:29 PM
> To:   SQR-USERS@list.iex.net
> Subject:      (SQR 5007) Report 'default' has overlapping heading and
> footing
>
> Hi everyone,
>
> As the frustration begins to appear, it's time to ask for help...
>
> When trying to use print to create a flat file, I get the following
> error:
>  "(SQR 5007) Report 'default' has overlapping heading and footing "
>
> I need to use the print (instead of write) due to the general nature of
> this
> report. The concept (which is even demonstrated in the manual) is:
>
>    declare-layout default
>    formfeed = No
>    max-lines = 1
>    max-columns = 1000
> end-declare
>
> This causes the above error. When I use a different layout name (and the
> use-report option), I get the same error for the new report name. It must
> be
> a real obvious thing that I just don't know - or can't see...help :-)
>
> Thanks,
> Bryan
>
> ------------------------------------------------------------
> Bryan E. Brown
> bbrown2@acsalaska.com, 907-564-1303
> Systems Analyst, ACS (Alaska Communication Systems)
> SQRW  V3.0.13.2, CSS Hrizon ver 8, Oracle 7.3.3, NT (server &
> workstations)