DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1

Thread: query subsutution

  1. #1
    Join Date
    Aug 2001
    Posts
    35

    query subsutution

    I am using the following query in my report.

    Select r_sub,sum(custom_money1)
    from pr_customers
    where (all the conditions)
    group by r_sub.


    so in the after parameter trigger,i subsuitied the value for r_sub.

    The problem is in the result,for ex if _sub = 'custom_number',
    then the result is displayed as

    custom_number 4
    custom_number 5
    custom_number 6


    Instead of the orgingal row value,i am getting the above answer.please let me know how to solve it.
    Last edited by vennai; 09-16-2003 at 09:24 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width