RecordSelectionFormula
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Thread: RecordSelectionFormula

  1. #1
    Join Date
    Aug 2007
    Posts
    5

    RecordSelectionFormula

    hi , i am newbie in crstal report,
    I had face a problem when i try to set the formula for selection.

    I hope to query record that inv_date and c_date bigger than certain date.
    so i set the formula like below:

    r.RecordSelectionFormula =
    "{ViewReportTraking.inv_date} >= DateValue('" & datefrom.ToString() & "') or {ViewReportTraking.c_date} >= DateValue('" & datefrom.ToString() & "')"

    What happen is the query only select the record inv_date >= certainDate,
    but not the c_date >=certainDate.


    when i try to set it to opposite
    r.RecordSelectionFormula =
    "{ViewReportTraking.c_date} >= DateValue('" & datefrom.ToString() & "') or {ViewReportTraking.inv_date} >= DateValue('" & datefrom.ToString() & "')"

    I need query either inv_date or c_date >= certainDate.
    Last edited by calvinkwoo3000; August 21st, 2007 at 04:55 AM. Reason: wrong spelling

  2. #2
    Join Date
    Sep 2005
    Location
    Colorado, USA
    Posts
    86

    Re: RecordSelectionFormula

    Are you wanting to retrieve records back where both the inv_Date and c_date are >= your "certain date"? If so change your "or" to "and", then you will get back records where both conditions are true.

    GJ

  3. #3
    Join Date
    Aug 2007
    Posts
    5

    Re: RecordSelectionFormula

    No, i need either inv_date > certainDate or c_date > certainDate is true then query record.
    but the 'or' look like not function, but the 'and' is function.
    Last edited by calvinkwoo3000; August 21st, 2007 at 12:10 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
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center