hihi..i'm new member and also new to use crystal report 11. Need some help from all member here......appreciate for all your help

 

Num      Supplier Num       receipt value      percentage        month to date

2          ZHOZHO                 753,422          18.19                            ?

3          PERVIE                    603,878          14.58                            ?

           

            Total                       3,754,869        90.66

            Others                     386,731          9.34

            Grand Total             4,141,600        100.00

 

This report will appear top 20 record for each month, this oly the sample for few record.

The Question is, how i want to display month to date total for the record?

 

Let say for example: when i key in february to view the feb report, then month to date field will total up january and february value and show in column, or if i key in march then month to date field will show total up for jan+feb+march)

 

p/s: each month the top of 20 supplier will different. Maybe this month PERSAD is top 20, but at the following PERSAD will not in the top 20 list.

 

so, i don't know how to show the montht to date total.

 

thanks

 

thanks in advance.

Do you have records per supplier that you are trying to sum?

Do you mean year to date? Your description seems to be about Jan to your parameter not the month total.

Can you give more details about what data you are trying to sum and if you already have your select statement working.