Hi,
Am using crystal 10 with SQL server 2000. My sequel view returns all the data i need for both current financial yr and Previous financial yr.
(Date, AccountNo, AccountDesc, Amounts)
The financial year spans Sept 2004 to August 2005, with reporting being sept 2004 to date
Problem @ Hand:
Both the YTD formula and LYTD formula are returning same value (YTD amount) but the values in the database are different.
Ps: Currently am using a record selection formula, 2 parameters and 2 formulas.
{?sdate} = parameter name of start date
{?edate} = parameter name of end date
My record selection formulas are...
{table.date} in date(year({?sdate),month({?sdate}),1) to {?edate}
.. and my formulas are:(put in the details sections)
@YTD
if {table.date} in {?Sdate} to {?Edate} then {table.amount} else 0
@LYTD
if {table.date) in dateadd("y",-1,{?Sdate}) to dateadd("y",-1,{?Edate}) then {table.amount} else 0
Please assist!
Am using crystal 10 with SQL server 2000. My sequel view returns all the data i need for both current financial yr and Previous financial yr.
(Date, AccountNo, AccountDesc, Amounts)
The financial year spans Sept 2004 to August 2005, with reporting being sept 2004 to date
Problem @ Hand:
Both the YTD formula and LYTD formula are returning same value (YTD amount) but the values in the database are different.
Ps: Currently am using a record selection formula, 2 parameters and 2 formulas.
{?sdate} = parameter name of start date
{?edate} = parameter name of end date
My record selection formulas are...
{table.date} in date(year({?sdate),month({?sdate}),1) to {?edate}
.. and my formulas are:(put in the details sections)
@YTD
if {table.date} in {?Sdate} to {?Edate} then {table.amount} else 0
@LYTD
if {table.date) in dateadd("y",-1,{?Sdate}) to dateadd("y",-1,{?Edate}) then {table.amount} else 0
Please assist!