Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 20 Apr 2010 at 3:37am
is the date range a parameter? if not, 2 options come to mind. 1) use a stored proc and return the dates either in a separate table(dataset) or as part of your datatable or 2) use a subreport to determine the date range (degraded performance as you need to read the data twice...once for the date range and once for the report)
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 20 Apr 2010 at 4:25am
I normally have two formulas, one for the start date, one for end date. Then I do a minimum on the date field to get the start date and a maximum of the date field to get the end date.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum