Re: Print Columns Down Page

[Samir Patel <samir.patel@US.PWCGLOBAL.COM>]

Thanks for the response, but my mesg. may have been a bit unclear.  I was
trying to setup two "logical sections", with the same column and row info.
in both sections, only the data is different.  What I wanted my program to
do is print a column header (4 columns), and then print the rows under it.
Once it reaches the bottom of the page, the cursor would go to the 2nd
"logical section" (which is on the same page, just to the right of the last
column from the 1st section).  The program would again print the same
column header, and the rows under it.  I guess it is easier to show, rather
than explain.

Regardless, I was finally able to get it to work properly.  I had to build
some additional logic into the program.  It may not be most efficient, but
it works.  I believe the code below will work in a program where there is
only 1 report generated.   My issue was caused by creating multiple reports
from one program.

But I appreciate the response.  Thanks again.

samir






David Brawner <dbrawner@ATT.NET>@list.iex.net> on 11/15/2001 03:46:22 PM

Please respond to sqr-users@list.iex.net

Sent by:  "Discussion of SQR, Brio Technology's database reporting
      language" <SQR-USERS@list.iex.net>



To:   SQR-USERS@list.iex.net
cc:
Subject:  Re: Print Columns Down Page



Looks like your problem, as coded, fails to properly assign print
parameters.  In Print-Report you'll either need to insert a next-column
command between data, ie
                                                 use-column 1
                                                 print $column1
(+0,2,35)
                                                 next-column
                                                 print $column2
(+0,+3)
or define the columns ahead of time and specify the column in the print
position ie. (+0,{col1}), (+0,{col2}) etc.

Dave

-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Samir Patel
Sent: Thursday, November 15, 2001 11:14 AM
To: SQR-USERS@list.iex.net
Subject: Print Columns Down Page
.

SQR/6.1.4/PC/Windows NT 4.0/Orcale 8.0.6

I am experiencing difficulties trying to print multiple columns down the
page.  I have looked thru previous postings, but cannot come up with an
answer.  Below is a snippet of the code.

It prints the 1st column fine (about 50 rows), and then advances to the
next column, prints the column heade, and prints the 1st row on the 2nd
column.  However, the next row of data gets printed over the 1st column,
instead of the 2nd column.  I believe it may have to do with where the
"Columns" declaration is done.  I've tried putting it in the Init section,
before the begin-select in the Main-Select proc, before the If logic in the
Check-Page-Break proc, etc..    I've tried various scenarios, but with
little success.

Also, it may be worth noting that I am generating multiple reports in the
same program.  The code below is ONLY for one report.

I would appreciate it if anyone could provide any insight.  Thanks in
advance.

Samir

----------------------------------------------------------------------------

-----------------------------------------------------------

! Init section
    let #Column1 = 2
    let #Column2 = 90
    let #bottom_line = 58

   Columns #Column1 #Column2

! Main Select
    select
    column1,
    column2,
    column3,
    etc..

    do Print-Report

    from tablename

! Print-Report
    do Check-Page-Break
    print $column1            (+0,2,35)
    print $column2            (+0,+3)
   etc..

! Check-Page-Break
    If #current-line < 6
        do Print-Header  !prints a header column
    Else
        If #current-line >= #bottom_line
            Next-Column Goto-Top=1 At-End=NewPage
            print '' (+2)  !skip 2 lines to line up the header for the 2nd
column
            do Print-Header
        End-If
    End-If

   print '' (+1)

----------------------------------------------------------------------------

-----------------------------------------------------------





----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited.   If you received
this in error, please contact the sender and delete the material from any
computer.

----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited.   If you received
this in error, please contact the sender and delete the material from any
computer.