RE: [sqr-users] On Break Option

[Darshil Mehta <darshilm@yahoo.com>]

Thanks a ton. Don. 
 
It's really working fine.
 
Thanks for the great help :)
 
Darshil

Don Mellen <donm@ontko.com> wrote:
Well, your code uses "before=", it should be "after=". Instead of
&cust_nam and &custcount in procedure cust_count, use $cust_nam and
#custcount.

On Wed, 26 May 2004, Darshil Mehta wrote:

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

-----------------------------------------------------------------------
Donald Mellen | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com | "In the beginning, there was nothing, which exploded"


_______________________________________________
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