I'm going to assume you want to see items that are on open sales orders, as opposed to ones that have already been invoiced.

The report you want is called the Order Action report (Reports | Order Reports | Order Action). It is very customizable, and you can remember each customization as a Template.

Play with it, you will likely get something good. You can also ExcelDirect print it to Excel.

If this is not what you are looking for, please explain in further detail.

Steve