>I have a table used in report with two fields SOMEDATE and SOMENUMBER.
>
>I have made group by SOMEDATE in report.
>
>I want in group footer to show total SUM of SOMENUMBER for dates before date that is current in group.
>
>How to do that? (preferably it would be variable)
You can create a report variable, and assign it an expression similar to:
iif(Condition, Value_To_Sum, 0)
Make it SUM, and reset it as appropriate.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)