Re: Please give me reply soon........

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

Hi,
Thanks for quik reply.
I gave onebreak levels........
I am getting data like this...

State
Region
District
Officer
Offenders........
but i don't want that order........

first i have to display  districts information which are in particular
Region then have to display region details which are under particular
stae.....
it seems reverse order to print data.....

here i am getting district and officer ,offender information.
When i am printing region under district ...just i am getting only one
distric.

my code looks like this...
OFFC_STATE         &OFFC_STATE ()on-break level=1
                   after=print_state_total
                   SAVE=$offc_state
                   print=never
D.RMF_REGION       &RMF_REGION   ()on-break level=2
                   before=print_region_heading
                   before=print_region_total
                   SAVE=$region
                   print=never
D.RMF_DISTRICT     &RMF_DISTRICT ()on-break level=3
                    SAVE=$district_number
                    print=never
OFFC_NAME           &OFFC_NAME   ()on-break level=3
                   after=print_dist
                    print=never
                    after=print_district_total
                    before=print_district_heading
                    SAVE=$district_name
                    print=never

OFCR_LAST_NAME      &OFCR_LAST_NAME ()on-break level=4
                    SAVE=$officer_number
                    print=never
OFCR_FIRST_NAME     &OFCR_FIRST_NAME ()on-break level=4
                    after = print_officer_total
                    before = print_officer_heading
                    print=never
E.CTH_CASE_CAT       &CTH_CASE_CAT ()on-break level=5
                    after= print_cat_total
                    SAVE=$cth_case_CAT
                    print=never



A.OIMS_SID_NO       &OIMS_SID_NO
D.RMF_SID_NO        &RMF_SID_NO

  DO print_data
  add 1 to #state_count
  add 1 to #region_count
  add 1 to #district_count
  add 1 to #officer_count
  add 1 to #cat_count
  add 1 to #grand_total

FROM OIMST.TAMASTER A,OIMST.TPRELMAST D,TPOFFICE,TPOFFICER,TPCASE_CAT_HIST E

  WHERE (A.OIMS_SID_NO BETWEEN '06500000' AND '35000000')AND
   D.RMF_ACTIVE='Y'

   AND A.OIMS_SID_NO=D.RMF_SID_NO
   AND A.OIMS_SID_NO=E.CTH_SID_NO
   AND D.RMF_REGION=OFFC_REGION
   AND D.RMF_REGION=OFCR_REGION
   AND D.RMF_DISTRICT=OFFC_DISTRICT
   AND D.RMF_DISTRICT=OFCR_DISTRICT
   AND D.RMF_OFFICER=OFCR_EMP_NO
  !AND OFCR_FIRST_NAME='Doss'
   !AND CTH_CREATION_DATE=(SELECT MAX(CTH_CREATION_DATE)
    !   FROM OIMST.TPCASE_CAT_HIST F
     !  WHERE E.CTH_SID_NO=F.CTH_SID_NO)
      !AND A.OIMS_SETUP_DTE=
       !  (SELECT MAX(OIMS_SETUP_DTE)
        !  FROM OIMST.TAMASTER B
         !  WHERE B.OIMS_SID_NO=A.OIMS_SID_NO
          !    AND B.OIMS_SID_NO=D.RMF_SID_NO)
   AND D.RMF_RELEASE_DATE=
        (SELECT MAX(RMF_RELEASE_DATE)
          FROM OIMST.TPRELMAST C
          WHERE C.RMF_SID_NO=A.OIMS_SID_NO
            AND C.RMF_SID_NO=D.RMF_SID_NO)
ORDER BY OFFC_STATE,D.RMF_REGION,OFFC_NAME,OFCR_LAST_NAME,CTH_CASE_CAT
end-select
!do print_grand_total
end-procedure !get-warrant

Thanks
Srini

>From: Elvis Pressly <elvisdman@HOTMAIL.COM>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Re: Please give me reply soon........
>Date: Thu, 11 Jul 2002 15:39:51 +0000
>
>First you have to SORT your file according to your report sequence then
>have each sort sequence assign a level number for ON-BREAK function.
>
>ex...
>
>     SORT Sequence                  On-Break level
>
>        STATE                            1
>        REGION                           2
>        DISTRICT                         3
>        OFFICER                          4
>        OFFENDER                         5
>
>
>There are more information about On-Break function in the SQR manual.
>
>>From: "Srini ." <vasbrio@HOTMAIL.COM>
>>Reply-To: sqr-users@list.iex.net
>>To: SQR-USERS@list.iex.net
>>Subject: Please give me reply soon........
>>Date: Thu, 11 Jul 2002 14:53:47 +0000
>>
>>Hi Friends,
>>I am new to this Users Group, i am happy to inform to you all.
>>I am Srinivas, working with Texas Department of Criminal
>>Justice,Huntsville/Tx. I have several questions on SQR Reports.
>>
>>I have to create one report like this....
>>I have to display data like this ...
>>Statewise , Regionwise, Districtwise And Officerwise offenderslist.
>>
>>First i have to display all offenderlists officerwise in all districts
>>under
>>single region. Then under that dirsticts, i have to display region heading
>>and under all district details and under that i have to display state
>>heading and under all regions.
>>but i am getting district wise data only...........while i am printing
>>region and under all districts...i am not getting district details..
>>please give me the solution to get the data abouve format.
>>
>>District name dist1
>>officername name1                   offenders 10
>>officername name2                      ''     20
>>officername name3....                ''        5
>>
>>District name dist2
>>officername name1                   offenders 10
>>officername name2                      ''     10
>>officername name3....                ''        5
>>  .............
>>
>>Region region1
>>dist1                         offender        35
>>dist2                          ,,             25
>>........
>>
>>State state1
>>region1                   offenders 60
>>region2                      ''     80
>>region3                        ,,
>>.....
>>
>>Please i need above format
>>
>>Thanks
>>Srinivas
>>
>>_________________________________________________________________
>>Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>
>
>
>_________________________________________________________________
>Join the world’s largest e-mail service with MSN Hotmail.
>http://www.hotmail.com




_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com