Cross tab dessign question

rbuser

Hi, this is not a RB directly question, but i want to know if it's
possible to create a crosstab report instead of generating temporal
tables.
I have a table with ItemReference, SellQuantity and SellDate.
My customer wants a report where in the left column appears the
Itemreference, and in the column headers appears week numbers. In the
intersection of row, column i must have the SellQuantity sum for each
week.
Is there an easy way to do it?
thanks
--
Guillermo Castaño Acevedo
Gerente de Sistemas - Grupo Millennium Ltda
GuillermoC@GrupoMillennium.com
www.GrupoMillennium.com

digitalmetaphors

Sounds like a crosstab report will work. You can use SQL calculated fields
in the dataset which can provide the week number and total for the week.
Sort the records by week number. Then feed that data into the crosstab.


Cheers,

Jim Bennett
Digital Metaphors