-
October 20th, 2013, 09:11 AM
#1
Report selection formula
Hi,
I want to use in clause in rpt file selection formula
for e.g
crDoc.RecordSelectionFormula={tblEmployees.EmployeeID} in (14,11,8,2,5,13,10112,10127,10129,11685)
But it showing error.Please advice me that how to use this in report Report selection formula
Thanks in advance
-
October 20th, 2013, 09:54 AM
#2
Re: Report selection formula
Use square brackets instead to enclose data and apostrophe to enclose the formula, as in
Code:
crDoc.RecordSelectionFormula="{tblEmployees.EmployeeID} IN [14,11,8,2,5,13,10112,10127,10129,11685]"
Last edited by jggtz; October 20th, 2013 at 09:56 AM.
JG
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
-
October 20th, 2013, 10:06 AM
#3
Re: Report selection formula
Thank you very much for help
now it is working
-
October 20th, 2013, 10:10 AM
#4
Re: Report selection formula
OK
Now is time to mark the thread as Resolved and rate the post (litlle star at the left of the post)
JG
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
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
|