crystal report formula to filter between dates for bar chart

0
votes

I get an error when I try to add parameters to filter between dates in a crystal report selection record formula. This is the formula I used:

if {tblFaultyDevice.date} >= {?dateFrom} and {tblFaultyDevice.date} <= {?dateTo} then true

Error:

A string is Required Here

1
c#crystal-reports
What is the datatype of date database field and also parameters – Siva
ohh ok where did you write that formula? in which window? – Siva
Crystal report, select expert, record formula.. am trying to filter between dates, i passed in two paremeters which are dateFrom and dateTo. when ever try to launch i get that error.. i found a way to stop the error but by using ToText{?dateFrom} vice versa. the error stoped but yet the chart does not pick the date i pass to it. – Umar E. Shaibu

1 Answers

0
votes

what you have written is wrong.. select expert record selection doesn't accept any boolean values to return.

your formula should be:

{tblFaultyDevice.date} >= {?dateFrom} and {tblFaultyDevice.date} <= {?dateTo}