RE: [sqr-users] page write attempted while writing current page

["Turner, Ivan" <Ivan.Turner@qwest.com>]

Yes.  I believe SQR takes care of headers and footers for the user.  I'm
using the header below.
begin-heading 12 
#include 'arhdg01.sqc'
        !print parameters on lines 3 and 4 in heading
        print 'Business Unit:'             (3,1,15)
        print $Bus_Unit                    (,16,5)
        print $include_text                  (+1,1)

        evaluate $By_Date_Or_Cycle
                when = 'CYC'
                     print 'Billing Cycle:'             (,62,14)
                     print $cycle_id                    (,77,10)
                     print 'Cycle Occurrence:'          (,89,17)
                     print $occur_no                    (,107,10)
                     break

                when = 'DAT'
                     print 'For Accounting Date'     (,63,20)
                     print $From_Dt                  (,83,11)
                     print 'through'                 (,95,7)
                     print $To_Dt                    (,103,11)
                     break

                when = 'PDT'
                     print 'For Post Date'           (,67,13)
                     print $From_Dt                  (,81,11)
                     print 'through'                 (,93,7)
                     print $To_Dt                    (,101,11)
                     break
                when = 'ENDT'
                     print 'For Entered Date'        (,67,13)
                     print $From_Dt                  (,81,11)
                     print 'through'                 (,93,7)
                     print $To_Dt                    (,101,11)
                     break

                when = 'JDT'
                     print 'For Journal End Date'    (,71,21)
                     print $Journal_Dt               (,93,11)
                     break

                when = 'JID'
                     print 'For Journal Id'          (,67,14)
                     print $Journal_id               (,82,10)
                     print 'through'                 (,93,7)
                     print $Journal_id_end           (,101,10)
                     break

                when-other
                     print ' No Proper Selection Specified' (,73,25)
                     break
        end-evaluate

        If $Type = ' '
            print 'Entry Class:'               (+1,1,13)
            print $Adj                         (,14,3)
            print $Occ                         (,18,3)
            print $Inv                         (,22,3)
            print $Pay                         (,26,3)
        else
            print 'Entry type: '                (+1,1)
            if $entry_selection = 'Multiple'
               print $include_entry_type_text   (,,)
            else
              print $Type                       (,,)
            end-if
            print 'Reason Code: '               (+1,1)
            If $Reason = ' ' or $entry_selection = 'Multiple'
               print 'ALL'                        (,,)
            else
               print $Reason                      (,,)
            end-if
        end-if


        if ($By_Date_Or_Cycle  = 'JDT' or $By_Date_Or_Cycle = 'JID') 
            if ($invoice_date_entered <> ' ')
                print 'Invoiced Amounts in'            (,75,19)
                print $invoice_date_entered            (,95,5)
            end-if
        end-if

        print 'Entry'                      (+2,#1 )
        print 'Entry'                      (,#2)
        print 'Entry Type Descr'           (,#3 )
        print 'Reason'                     (,#4 )
        print 'Grp Id'                     (,#5 )
        print 'Oper Id'                    (,#5b)
        print 'Date'                       (,#6 )
        print 'Item no.'                   (,#6a)
     print 'AR'         (,#6b)
        print 'Cust ID'                    (,#7 )
        print 'Name '                      (,#8 )
        print 'PreTax Amt'                 (,#9 )
        print 'Tax Amount'                 (,#10)
        print 'Entry Amount'               (,#11)
        
        print 'Class'                      (+1,#1)
        print 'Type'                       (,#2)
        print 'Code'                       (,#4)
     print 'ID'         (#6b)

        print '-----'                   (+1,#1) 
        print '-----'                   (,#2) 
        print '-'                       (,#3,22 ) fill
        print '-'                       (,#4,6 ) fill
        print '-'                       (,#5,10 ) fill
        print '-'                       (,#5b,8 ) fill
        print '-'                       (,#6,11 ) fill
        print '-'                       (,#6a,18) fill
     print '-'         (,#6b,2) fill
        print '-'                       (,#7,9 ) fill
        print '-'                       (,#8,10 ) fill
        print '-'                       (,#9,18 ) fill
        print '-'                       (,#10,18) fill
        print '-'                        (,#11,18) fill
end-heading


-----Original Message-----
From: sqr-users-bounces+ivan.turner=qwest.com@sqrug.org
[mailto:sqr-users-bounces+ivan.turner=qwest.com@sqrug.org] On Behalf Of
Hins, Thomas D. (HSC)
Sent: Monday, July 12, 2004 2:09 PM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] page write attempted while writing current page


R u using some kind of header or footer?

Tom Hins
Information Technology - Application Solutions
University of Oklahoma Health Sciences Center
P.O. Box 26901
Oklahoma City, OK  73190
Phone:(405) 271-2262 Ext. 50213
Fax: (405) 271-2352
(The information transmitted is intended only for the person or entity
to which it is addressed and may contain confidential and/or privileged
material. If you are not the intended recipient of this message you are
hereby notified that any use, review, retransmission, dissemination,
distribution, reproduction or any action taken in reliance upon this
message is prohibited. If you received this in error, please contact the
sender and delete the material from any computer. Any views expressed in
this message are those of the individual sender and may not necessarily
reflect the views of the company.)



-----Original Message-----
From: sqr-users-bounces+thomas-hins=ouhsc.edu@sqrug.org
[mailto:sqr-users-bounces+thomas-hins=ouhsc.edu@sqrug.org]On Behalf Of
Turner, Ivan
Sent: Monday, July 12, 2004 12:57 PM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: [sqr-users] page write attempted while writing current page


Has anyone ever seen this one?  I have no before or after procedures in
the code.

(SQR 5400) Second page write attempted while writing current page. Check
BEFORE-PAGE, AFTER-PAGE procedures.

_______________________________________________
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