Capturing Total MTD date vs just based on Date Range 1

[rwn]

I have a sub report that shows summary data for the current Month that is run by date range. When Container report when it is run, the user enters a Begin Date and and End Date to see Detail information for that date range on the Container Report. The subreport needs to show summary Monthly totals. So, I need to have the Month subreport show the Complete Month data for the date range entered. For example: the user enters 4/1/2012 to 4/15/2012, the Month Supreport needs to show data from 4/1/2013 to 4/30/2013.
the current formula that Im using (and not working) is:
{@ShippedDate} in date(month({?Pm-?End Ship Date}),1,1) to {?Pm-?End Ship Date}

thank you!

 

[pmax9999]

Try:

{@ShippedDate} in Date(Year({?Pm-?End Ship Date}),Month({?Pm-?End Ship Date}),1) to (DateSerial(Year({?Pm-?End Ship Date}),Month({?Pm-?End Ship Date})+1,1)-1)

I see that you are using a Formula ({@ShippedDate}) within the record selection formula which, depending on the contents of the formula, can be very inefficient and slow the report considerably. There is often a better approach - if you find the report is very slow to run, post back with the contents of the formula and we may be able to offer a suggestion to improve speed.

Cheers
Pete