Create a crosstab report with several columms

I am using Crystal Reports X and would like to create a cross tab report.  The report will consist of the following information:
Cust#-Category-Item#-Qty Shipped

The total of my Qty Shipped column will reflected as total per month.  Once the crosstab report is created I would like to create a summary of the details in a section below.  Any help is greatly appreciated.

Thank you.

M.R.
mrizoAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
shakir77Connect With a Mentor Commented:
slight correction-
since you want to sum up on Item#, this field should be used in Summerized Fields section.
0
 
mlmccCommented:
Use the cros tab wizard to walk you through the process.

Start a new report and select cross tab as the tyope.

mlmcc
0
 
mrizoAuthor Commented:
Thanks for your prompt response.  I knew that much to start my report.  However, I have some doubts regarding how many rows or columms I can add. See attached file.  The numbers represent the qty. sold.  Please advise.

Thank you.

MR.
sample.txt
0
 
shakir77Commented:
In the cross tab wizard, Row selection should be for "Customer"  "Number"      "Category"      "Item # "
and date should go in column.
By this you will be able to do sub total and total for row/columns and grand total as well.




0
All Courses

From novice to tech pro — start learning today.