RE: [sqr-users] On Break Option

[Darshil Mehta <darshilm@yahoo.com>]

here is the code...
 
 
begin-select on-error=record_sql_error 
($sql-error,'MAJOR',$sql_report,'main_query')
crmserv.srno         &service_req_id
crmserv.srdesc       &service_req_subject_desc
crmserv.createdate   &create_dt
crmserv.statuscd     &service_req_status_cd
crmserv.topicdesc    &service_req_topic_desc
crmserv.srreqtype    &serv_req_typ
corp.description   &cust_nam   () on-break level=1 print=change 
before=cust_count 
crmserv.srowner      &assigned_to_last_nam
corp.cnt             &custcount 
 
  move  &service_req_id           to $service_req_id  
  move  &service_req_subject_desc to $service_req_subject_desc
  move  &create_dt                to $create_dt
  move  &service_req_status_cd    to $service_req_status_cd
  move  &service_req_topic_desc   to $service_req_topic_desc
  move  &serv_req_typ             to $serv_req_typ
  move  &cust_nam                 to $cust_nam
  move  &assigned_to_last_nam     to $assigned_to_last_nam
  move  &custcount                to #custcount
  add 1 to #llopp
  do write_file_detail
from 
[$from_clause]
where 1=1
and corp.corp_cd = crmserv.corp_cd 
![$where_clause]
order by 
[$order_by_clause]
end-select

begin-procedure cust_count
 write 1 from $custname ' ' &cust_nam ' - ' &custcount
end-procedure


the dragon <ceprn@hotmail.com> wrote:
post the program



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----

Hi all,

I am getting following data.

Custname
--------------
cust1
cust1
cust1
cust2
cust2

Now I want to show it like

Custname
--------------
cust1
cust1
cust1
Cust name: cust1 : 3
cust2
cust2
Cust name: cust2 : 2

I am using this command.

crmserv.srno &service_req_id
crmserv.srdesc &service_req_subject_desc
crmserv.createdate &create_dt
crmserv.statuscd &service_req_status_cd
crmserv.topicdesc &service_req_topic_desc
crmserv.srreqtype &serv_req_typ
corp.description &cust_nam () on-break level=1 print=never 
after=cust_count
crmserv.srowner &assigned_to_last_nam
corp.cnt &custcount


But I'm getting count in the begining instead of after cust name. My output 
shows following

Custname
--------------
Cust name: cust1 : 3
cust1
cust1
cust1
Cust name: cust2 : 2

cust2
cust2

what could be the reason?

Thanks in advance...
Darshil



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
                
---------------------------------
Do you Yahoo!?
Friends.  Fun. Try the all-new Yahoo! Messenger

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users