From the same Database when I tried to run a report from Sales Order Header, it picked all the transactions dated from Jan 2010 back whatever historical date that were in the database. When I run another report Sales Summary, it picked only transactions that are dated Jan 2010, not transactions with older date.