Formating report..........

["Srini ." <vasbrio@HOTMAIL.COM>]

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]
>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




_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com