Dataset not showing in the left side ?
If you are using BIDS with SQL 2008 R2 you can only get the “Report Data” menu by clicking inside the actual report layout itself.
- Click inside the actual report layout.
- Now select “View” from the main menu bar.
- Now select “Report Data” which is the last item.