-
August 20th, 2007, 02:22 AM
#1
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 03:55 AM.
Reason: wrong spelling
-
August 20th, 2007, 05:15 PM
#2
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
-
August 20th, 2007, 09:28 PM
#3
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 20th, 2007 at 11:10 PM.
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
|