Summary Problem

[kobiav]

I am trying to do to filters on one report i.e.
I have a products table and customer_products table,
I am counting the amount of products and showing the total products purchased per product:

Product Name Total



Now I added startDate and endDate parameters and configured a selector to return between those dates. this was successful but when I want to display all products and products between those dates I have a problem, it seems that the filter is for the whole report and I cant find a solution to shoe seperate columns with seperate filters.
The table I want is:

Product Name 1/1/2005 to 1/7/2005 Total

1 200 1,200
2 1,000 3,500


Please help....
Thanks,
Kobi

[Jacksc]

This seems like something you could do with the running totals functionality of Crystal Reports (http://www.saveonsupport.com). You would add multiple running totals all evaluated on different criteria. Go to the field explorer and add a new running total. Then in the evaluate section click the formula button and add your filter criteria as a formula.

[kobiav]

Hi,

Thanks for the quick answer!
I tried that using the following configuration:
I used count on product_name, for each record, reset by change of group and I get 1,1,1,1,1 instead of real cumulative numbers....

Kobi

[Jacksc]

You could try using "sum" instead of "count" everything else seems okay.

[kobiav]

Sum on a name?

[Jacksc]

Oh, I see, that wouldn't work. What groups do you have on your report?

[kobiav]

I have one group called pr_name which is product_names, that is my group by.

I tried to add one more group with the purchase_date and then filter by the purchase date but it changed the whole fields in the report....so I removed that group....

I can send you my report so you can look at it but it is connected to ny db.