Joined: 06 Feb 2008
Location: United States
Online Status: Offline
Posts: 55
Topic: Pass a subreport parameter fro the prior year Posted: 03 Mar 2010 at 9:25am
Hello,
The main report has a date range parameter. I would like to use this parameter to link to the subreport for the previous year.
For example:
Main report parameter is 1/1/10 to 2/28/10
I would like to select data from my subreport for 1/1 09 to 2/28/09.
I've tried {field} >= dateadd("YYYY",-1, minimum({?Date Range})) and {field} <= dateadd("YYYY",-1, maximum({?Date Range})) but this does not select any records.
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