[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
- Subject: here i am attaching my output.txt file
- From: "Srini ." <vasbrio@HOTMAIL.COM>
- Date: Thu, 11 Jul 2002 19:18:24 +0000
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