VB .NET Crystal Reports month to date

Question

I have built an application that uses SQL database and Crystal Reports that is embedded in Visual Studio 2002. The application is running well and the Reports are working well. I have a main report with sub-reports. I have a formula to calculate month to date and year to date. As soon as I added data to the database for 2005 I now get two rows of data for 2004 and 2005 although 2004 is showing 0's. Can anyone help me determine the proper formula to show only the current year. The following is the formula format for year to date: if {mytable.myDate} in Date(year({?Date})11) to {?Date} then (x+y) ?Date = parameter mytable = table myDate = Current date Thank You Julie

monkey_gold2003 · Answer

I think you should ues dataset to solve this problem. Indataset you filter fieds very easy. After you filter you filled into the reports. Good luck.

VB .NET Crystal Reports, month to date