Crystal Reports cross tab, running totals and date parameters

Message

     hi all 

as the title says iv now moved onto cross tab reports!

i am trying to do more or less the same report as my last one if you can remember (DBlank and lockwelle) thats if ye read this post.

basically it will have "rep name" field for column and "product description" field for the rows and i need the "quantity" field total in the cells corresponding to each.

i have been goin through the CR manual but uts not very good only basic's really.

i need to get the "quantity" totals fo each cell (not the final totals) but i also need to minus the "returns" from this total.

i got this with the help of DBlanks code below on a normal report
where table.type I = invoice and thble.type C = credit

You can use 2 RTs here and subtract them in a formula. 
If you just need an overall report # create one RT as:
RT Name="Sales"
Field to SUmmarize=Quantity
Type of Summary=SUM
Evaluate=USe a Formula as: {table.type}="I"
Reset=Never

Second Running Total do the same thing but name it "Returns" and make it evaluate on formula as {table.type}="C"

Create a "Total" Formula as:
{#Sales SUM}-{#Returns SUM}

any input would be great as this is my first cross tab and so far not much is happening!

i am also looking for a way to allow someone to search between specific time periods.
in my normal report i used 2 date parameters but when i try this here it jus crashes.

sorry for the long post but mayb it mite help other users.

thanks so much for any help given.

Katie

Edited by katie1200 - 02 Jul 2009 at 7:20am