Results 1 to 2 of 2

Thread: distinct in selection formula

  1. #1

    Thread Starter
    Hyperactive Member yousufkhan's Avatar
    Join Date
    Jan 2002
    Location
    India
    Posts
    492

    distinct in selection formula

    StrSelFor = "{ip_stlmt_dtl.rev_dt}>=date(" + StrFyr + "," + StrFmnth + "," + StrFday + ") and {ip_stlmt_dtl.rev_dt}<=date(" + StrTyr + "," + StrTmnth + "," + StrTday + ") and {iptrn.chrg_cd}=99 and {iptrn.bil_no}={ip_stlmt_dtl.bill_no}"

    in the above formula last condition is of {iptrn.bil_no}={ip_stlmt_dtl.bill_no}
    in ip_stlmt_dtl there can be same bill_no more then once but i want to have only once in the report that should be distinct bill_no
    how should i set the selectio forumula

  2. #2
    New Member
    Join Date
    Aug 2007
    Posts
    6

    Re: distinct in selection formula

    in my report every record is repeated again.but i just want it once so how can i deal with that?

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