Print Page | Close Window

RecordSelectionFormula

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Writing Code
Forum Discription: .NET 2003 programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1203
Printed Date: 18 May 2024 at 3:10am


Topic: RecordSelectionFormula
Posted By: calvinkwoo3000
Subject: RecordSelectionFormula
Date Posted: 20 Aug 2007 at 7:38pm
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 that 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() & "')"

It only query the record c_date >= certainDate but now both inv_date >= certainDate and c_date >= certaindate
 
I want query data either c_date >= certainDate or inv_date >= certainDate


Replies:
Posted By: BrianBischof
Date Posted: 20 Aug 2007 at 11:17pm
I don't see where the problem could be. I suggest creating the same record selection formula in CR only. Get it working there to make sure that the logic is correct. Once you have it working in CR, copy the record selection formula into your .NET app and swap out the datefrom.ToString() functions. This might help you catch what is going wrong (but it looks fine to me - there must be something small causing the problem).

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>


Print Page | Close Window