[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: (SQR 5007) Report 'default' - solved (or reason discovered an yway...)



Great!  Glad you figured it out!   :)

Trish

> -----Original Message-----
> From: Brown, Bryan [SMTP:bbrown2@ACSALASKA.COM]
> Sent: Tuesday, July 25, 2000 5:52 PM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: (SQR 5007) Report 'default' - solved (or reason
> discovered an yway...)
>
> Trish,
>
> I knew it was right in front of me! After I read your message again - it
> hit
> (yea - it hit pretty hard too!). The heading/footing was defined in one of
> our "standard" includes!!
>
> Thanks for making me think :-)
>
> 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)