you can only see the orders in report that are processed by admin
means if you have create invoice / shipping or credit memo only that orders will be display in report
moreover you need to refresh statistics from Reports >> Refresh Statistics before creating report
hope this may helpful to someone..
Thank you @jigneshthummar I did not want to believe that one MUST process orders before seeing them in reports, but you are right, we do. For everyone else here is what you need to know…
Admin Panel / Sales / Orders ~ will show you all your orders, regardless of an order’s status. So you must start here.
To Process Orders:
select “View” under Actions or check the box and double click on that order/row. You MUST change the status to other then “Pending” to see information via the Admin Panel / Reports menu.
After Processing Orders (1st Refresh)
Admin Panel / Reports / Refresh Reports / check most if not all / Refresh Statistics for Lifetime / Submit
Note: you will know it worked as the dates will change.
see Note about Timezone at the end, if you try this and it does not work for you. You should try it without changing your Timezone first and if it does not work, than your TIMEZONE setting MAY be why.
Now it should work…
Admin Panel / Reports / Sales / Match Period to Order Created Date / select Dates From and to /
Note: I did click “here” at the top of the report where it says, “Last updated: Nov 13, 2011 5:33:49 PM. To refresh last day’s statistics, click here” You date and time will of course vary. (2nd Refresh)
I created a test bed of 14 orders of various statuses, I left 3 set to “Pending”.
Admin Panel / Sales / Orders ~ shows 14 Orders
Admin Panel / Reports / Sales ~ shows 11 Orders
I verified that reports were generated were there was pertinent data to that Report. I was able to generate reports for the following report menus:
Admin Panel / Reports / Sales
Admin Panel / Reports / Products
Amdin Panel / Reports / Customers
Hope this helps others as a new Magento developer, it confused me at first.
Note about Timezone:
Admin Panel / System / Configuration / General / Locale Options / Central Standard Time (America/Chicago)
If on PST, use Pacific Standard Time (America/Los_Angeles)
Verify your /app/etc/config.xml is the same…
Pacific Standard Time (America/Los_Angeles) will be America/Los_Angeles
Central Standard Time (America/Chicago) will be America/Chicago
Here is what the code snippet looks like in the /app/etc/config.xml:
Remember to Refresh after changes to be safe...see both Refreshes above. My assumption is that you MUST Refresh after making changes if you want to see your changed data.