REPORT FILTERING

Hi There, Wonder if you could help, I am writing a report and wish to calculate the sum of values within a date range for a period of time for example January February March April 2000 9088 43434 4555 The above is an example of the report layout and the values shown beneath the headings will come from same table, so the question is how do I calculate the values as shown from the same table. Thanks

Hi Andrew, For sure we can help. I see at least two different ways to do it in a report. It may involve a bit of coding. Question: is this report only shows one line? One line per year? You want to have sums for which field of which table? Did you think about using the Date Table as a DataItem?

Hi Andrew, Take a look at Sales Statistics report 112, Might be a reasonable starting point. Regards, Andy.