|
-
Aug 25th, 2007, 02:12 AM
#1
Thread Starter
Hyperactive Member
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|