eaklor

eaklor

  • NA
  • 1
  • 0

VB .NET Crystal Reports, month to date

Jan 19 2005 4:49 PM
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}),1,1) to {?Date} then (x+y) ?Date = parameter mytable = table myDate = Current date Thank You Julie

Answers (1)