In Crystal Reports for Adagio, I created a CrossTab report to show sales by customer by period for the year
The formula for period is:
Year({QI62A History Headers.Date}) &' '&
(if (Month ({QI62A History Headers.Date}))<=9 then
' 0'&Month ({QI62A History Headers.Date}) else
''&Month ({QI62A History Headers.Date}) )
In the original report the period returned by this formula looks like this 2004 01
When I update the report selection formula to a new year, the formula changes and shows as 2004.00 01.00
Can anyone tell me how to correct this.
Previous Topic
Index
