[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

here i am attaching my output.txt file




hi i am getting this out put......help me to get correct output

>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




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com
                                      Texas Department of Criminal Justice -
Parole division
                                                         Caseload Summary
  July 11,2002
  District Name  DALLAS DPO 1

--------------------------------------------------------------------------------------------------------------------------------
  Officer Name          Reg  AR   NR   SO   EM   MI   MR   TIPH SISP DRC  SA
   SNP  TYC       Totals
------------------------------------------------------------------------------------transfer------------------------------------
  BIGGAR CRAIG          1
                  1
--------------------------------------------------------------------------------------------------------------------------------

                  1
--------------------------------------------------------------------------------------------------------------------------------

  District:           NACOGDOCHES DPO

--------------------------------------------------------------------------------------------------------------------------------
  Officer Name          Reg  AR   NR   SO   EM   MI   MR   TIPH SISP DRC  SA
   SNP  TYC       Totals
------------------------------------------------------------------------------------transfer------------------------------------
  COOK NEIL             1
                  1
  HENDERSON JACQUELINE  1
        6         7
--------------------------------------------------------------------------------------------------------------------------------


  District:           TYLER DPO

--------------------------------------------------------------------------------------------------------------------------------
  Officer Name          Reg  AR   NR   SO   EM   MI   MR   TIPH SISP DRC  SA
   SNP  TYC       Totals
------------------------------------------------------------------------------------transfer------------------------------------
  FITZGERALD SUSAN      2
                  2
  LONG CHARLES          2
        2         4
--------------------------------------------------------------------------------------------------------------------------------

                  6
--------------------------------------------------------------------------------------------------------------------------------


  Region :           01

--------------------------------------------------------------------------------------------------------------------------------
  DistrictParole        Reg  AR   NR   SO   EM   MI   MR   TIPH SISP DRC  SA
   SNP  TYC       Totals
--Office----------------------------------------------------------------------------transfer------------------------------------
  02                    DALLAS DPO 1