Show SubTotal without showing the line items of the group

[MyComputerGuy]

I am a relative novice with Crystal Reports 9.0 but have created a Production Scheduling report showing Job#, Release Date, Release Quantity, etc. I would like to add a column showing the total quantity shipped. Each Job has multiple Releases and Grouping & Subtotaling gives the total however I am trying to sort by Release Date and Grouping by job messes that up. I suspect that I need to create a Sub-Report but those attempts have generated additional pages, not just an another field on the report.

As a hardcore Techi, I know it can be done, but have hit the wall trying. I must bow graciously to those more experienced. Thanks in advance for direction & expertise.

 

[ShawnPDuffy]

Can you send me the .RPT file? (WITHOUT DATA PLEASE) I think I know what you are describing, but don't want to assume.

Thanks,
Shawn
Oregon, USA
shawn dot duffy at transcore dot com

 

[lbass]

Please note that it is site policy to keep responses in the forum, not handled through e-mail.

Please provide some sample data of your main report and explain your report structure. Are there literally no groups and only a sort on release date?

You say you want totally quantity shipped in your last column--total quantity per what? Per job? Some sample data and a little more explanation might help.

-LB

 

[MyComputerGuy]

Currently, these fields exist in the database:
Job#, Release_Date, Release_Qty, Shipped_Qty, Order_Qty
Shipped_Qty is for each release, But I want to see a total shipped for each job.

Sorted by Date now shows:
Job # Release_Date Release_Qty Shipped_Qty Order_Qty
12345 01/01/2005 100 100 400
12999 01/02/2005 200 200 800
12345 03/01/2005 100 100 400
12999 03/02/2005 200 200 800
12345 06/01/2005 100 400
12999 06/02/2005 200 800
12345 06/15/2005 100 400
12999 12/02/2005 200 800

Grouped by Job#, Subtotaling Shipped_Qty
Job # Release_Date Release_Qty Shipped_Qty Order_Qty
12345 01/01/2005 100 100 400
12345 03/01/2005 100 100 400
12345 06/01/2005 100 400
12345 06/15/2005 100 400
Subtotal
12345 200

12999 01/02/2005 200 200 800
12999 03/02/2005 200 200 800
12999 06/02/2005 200 800
12999 12/02/2005 200 800
Subtotal
12345 400

What I would like to see is:
Total
Job # Release_Date Release_Qty Shipped_Qty Order_Qty
12345 01/01/2005 100 200 400
12999 01/02/2005 200 400 800
12345 03/01/2005 100 200 400
12999 03/02/2005 200 400 800
12345 06/01/2005 100 200 400
12999 06/02/2005 200 400 800
12345 06/15/2005 100 200 400
12999 12/02/2005 200 400 800

The purpose of this is to quickly see that by 06/01 we need to produce 100 of Job# 12345 but it makes sense to produce the additional 100 for release on 06/15 at the same time.

Thanks All....

 

[lbass]

A subreport is the answer. Insert a subreport that uses your middle display of data--where you group by job and insert a sum on quantity shipped. Suppress all sections of the subreport except the group footer. Link the subreport to the main report on {table.job#}, and place it in the quantity column. Right click on the subreport->format subreport->borders and remove the borders by changing each line to "None".

-LB