Re: Formating report..........

[Atul Shrivastava <atulindia@YAHOO.COM>]

Srini,

When you print heading, just check the current-line
like:

  if #current-line >= {max_lines} - 5
     new-page
     print 'heading-1'  ()
  end-if

Depending upon the layout you can define max_lines in
the beginning like:\

#define max_lines    <nn>

HTH

--- "Srini ." <vasbrio@HOTMAIL.COM> wrote:
> Hi,
> I got a problem......
> While i am printing data, i am unable to restrict
> the data per page.
> I have to print data Officerwise ,District wise
> ,Region and State wise with
> totals. But i am unable to print data page wise.
> First i am printing data Officer wise....ok for
> example First Officer has 15
> records and second Officer has 10 records for that i
> have to print like
> this...
>
> Officer Name.........David
> Record 1
> Record 2
> ......upto 15
> Total                                    15
>
> Officer Name..........Samuel
> Record 1
> Record 2
> ......upto 10
> Total.............                        10
>
> District Name .........Irving
> David                   15
> Samuel                  10
> Total                   25
>
>
> like this state and Region i have to print.
>
> But while i am printing the records.....some
> headings or coming on end of
> page and data is coming another page......how can i
> restrict if the headings
> comes bottom of the page........
>
>
> >From: Seth Earnhardt <searnhar@AEROTEK.COM>
> >Reply-To: sqr-users@list.iex.net
> >To: SQR-USERS@list.iex.net
> >Subject: Multiple Layouts
> >Date: Tue, 23 Jul 2002 12:58:03 -0400
> >
> >Am trying to manipulate an sqr to use one of two
> layouts.  The value of
> >$output_format (at the end of code sample) is two
> when running, however,
> >the report uses the "default" layout.
> >
> >I have also tried using the use-report
> functionality, however, results
> >are the same.  Any help would be greatly
> appreciated.
> >
> >Code sample is pasted below:
> >
> >begin-setup
> >
> >#include 'setupdb.sqc'
> >
> >declare-printer  HP-definition
> >    for-reports = (default, default2)
> >    type=HPLASERJET
> >    font=5
> >    point-size=6
> >end-declare
> >
> >declare-layout default
> >    left-margin=.25
> >    top-margin=.50
> >    paper-size=(8.5,11)
> >    orientation=portrait
> >    max-columns={PAGE_MAX_COLS}
> >    max-lines={PAGE_MAX_LINES}
> >    line-height={LINE_HEIGHT}
> >    char-width={CHAR_WIDTH}
> >end-declare
> >
> >declare-layout default2
> >    paper-size=(8.5,11)
> >    orientation=portrait
> >    max-columns={PAGE_MAX_COLS}
> >    max-lines={PAGE_MAX_LINES}
> >    line-height={LINE_HEIGHT}
> >    char-width={CHAR_WIDTH}
> >end-declare
> >
> >declare-report default
> >   layout=default
> >   printer-type=HPLASERJET
> >end-declare
> >
> >declare-report default2
> >   layout=default2
> >   printer-type=HPLASERJET
> >end-declare
> >
> >declare-procedure
> >         for-reports=(default)
> >end-declare
> >
> >declare-procedure
> >         for-reports=(default2)
> >end-declare
> >
> >end-setup
> >
> >begin-report
> >
> >begin-select on-error=cannot-select
> >PRREQ.PRCSINSTANCE
> >prreq.RUNLOCATION
> >PRREQ.OUTDESTFORMAT
> >PRREQ.OUTDESTTYPE
> >FROM PSPRCSRQST PRREQ
> >WHERE PRREQ.PRCSINSTANCE = [$PI_CHAR]
> >end-select
> >
> >  let $output_format = &PRREQ.OUTDESTFORMAT
> >  let $outdesttype   = &PRREQ.OUTDESTTYPE
> >  let $run_location  = &PRREQ.RUNLOCATION
> >
> >  display $output_format
> >
> >  if $output_format = '2'
> >       use-procedure
> >        for-reports=(default2)
> >  else
> >       use-procedure
> >        for-reports=(default)
> >  end-if
> >
> >THANKS
> >
> >SE
> >
> >
> >
> >begin-setup
> >
> >#include 'setupdb.sqc'
> >
> >declare-printer  HP-definition
> >    for-reports = (default, default2)
> >    type=HPLASERJET
> >    font=5
> >    point-size=6
> >end-declare
> >
> >declare-layout default
> >    left-margin=.25
> >    top-margin=.50
> >    paper-size=(8.5,11)
> >    orientation=portrait
> >    max-columns={PAGE_MAX_COLS}
> >    max-lines={PAGE_MAX_LINES}
> >    line-height={LINE_HEIGHT}
> >    char-width={CHAR_WIDTH}
> >end-declare
> >
> >declare-layout default2
> >    paper-size=(8.5,11)
> >    orientation=portrait
> >    max-columns={PAGE_MAX_COLS}
> >    max-lines={PAGE_MAX_LINES}
> >    line-height={LINE_HEIGHT}
> >    char-width={CHAR_WIDTH}
> >end-declare
> >
> >declare-report default
> >   layout=default
> >   printer-type=HPLASERJET
> >end-declare
> >
> >declare-report default2
> >   layout=default2
> >   printer-type=HPLASERJET
> >end-declare
> >
> >declare-procedure
> >         for-reports=(default)
> >end-declare
> >
> >declare-procedure
> >         for-reports=(default2)
> >end-declare
> >
> >end-setup
> >
> >begin-report
> >
> >begin-select on-error=cannot-select
> >PRREQ.PRCSINSTANCE
> >prreq.RUNLOCATION
> >PRREQ.OUTDESTFORMAT
> >PRREQ.OUTDESTTYPE
> >FROM PSPRCSRQST PRREQ
> >WHERE PRREQ.PRCSINSTANCE = [$PI_CHAR]
>
=== message truncated ===


__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com