RE: [sqr-users] On Break Option

[Don Mellen <donm@ontko.com>]

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

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