Report selection formula
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4

Thread: Report selection formula

Hybrid View

  1. #1
    Join Date
    Oct 2013
    Posts
    2

    Smile 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

  2. #2
    Join Date
    Jul 2005
    Posts
    1,075

    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 10:56 AM.
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

  3. #3
    Join Date
    Oct 2013
    Posts
    2

    Re: Report selection formula

    Thank you very much for help
    now it is working

  4. #4
    Join Date
    Jul 2005
    Posts
    1,075

    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
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center