NEED HELP WITH CROSS TAB

[Sombo]

I am using Crystal 8.5 accessing an Oracle Database.
I am trying to Pivot my Dataset to use a Cross Tab.

My report passes 3 parameters. WHS#, Prod_Type, and a ShpDate range, then calculates the inventory.

The client wants the report formatted like this.
If he passes a ShpDate : 8/16/04 - 8/20/04,
WHS# : 11, 13, 22
Prod_type: Shirts, Caps, Bottles.

The report needs to be formatted like this.
I have grouped report on WHS# and Prod_type, but not sure how to pivot the ship dates to spread across 6 days.

WHS# Prod_Type 8/15 8/16 8/17 8/18 8/19 8/20
--- --------- ----- ----- ----- ----- ------ -----
11 Caps 2 0 8 100 45 16
11 Shirts 0 0 44 456 0 0
----
13 Bottles 0 10 66 71 0 0
----
22 Bottles 0 11 0 0 0 56
22 caps

Your advice and input will be greatly appreciated folks.

Thanks,
Sombo

 

[lbass]

If you have a field like {table.shipdate}, you can insert a crosstab, and use {table.shipdate} as the column field. For the row field, if you don't want summaries at the WHS level, create a formula {@concat}:

totext({table.WHS#},"00")+" "+{table.prodtype}

Use this as the row field, and then use a count of {table.item#} as the summary field.

-LB