i have a table which contains following columns.
if fmonth is "october" and fdate is null then it is showing nothing in report. but when i put date in fdate column . the reports shows data. i want to shows the all report wether fdate is null or having a date.
Table Name: Fees
AND isnull(fdate,date) between :fd AND :td
AND fdate between isnull(:fd,date) AND inull(:td,date)
[Updated on: Thu, 04 October 2018 05:48]
Report message to a moderator