Q:

Crystal Reports XI - Trying to move the contents the vertical side of the page to the horizontal side

I am trying to create a report using Crystal Reports XI that is able to look similar to an Excel spreadsheet.  One of the requirements is that it needs to be a landscape page and they want a header that shows the ItemID's in the header. 
All the headers that I need to show is as follows (In the order from left to right)
- Invoice Number
- Account Name
- Item ID (Dynamic, currently a list of at most 30 items)
The data showing under the header is needing to be able to show a quantity per Item ID, the actual account name, the invoice number that the items were found on. 
 Example of the desired appearance of report
In my report so far, I have managed to create the Dynamic ItemID header using a subreport, the details section in the subreport and the format as multiple columns option on the details section.  Now I am having issues with trying to make it so that I can put the other information needed into the report without having to make the report look for statically defined item ids. 
Is there any way to do this?  Any help would be appreciated. 
EDIT: Additional image of what I am trying to do
EDIT 2:A picture of the cross tab attempt

A:

You need to create formulas for each and every item in ItemID column. 
So your formulas would be:
Create a text field with name Monitor and rest of columns and place them one by one like you placed in image. 
Now to get the data write formulas like below:
if ItemID="monitor"
then Quantity

Place this formula in detail to get data for monitor and in the same way create formulas for all items in the column. 
Let me know if you need further assistance.