Parameters to Drill Through by Date Range
I have a drill through report that breaks my data out by month, so when I click on the count it shows me all occurences for that month. I am using the following parameters in startdate and enddate to achieve this:
=DateSerial(Year(Fields!Month.Value), Month(Fields!Month.Value), "1").AddMonths(0).AddDays(0)
=DateSerial(mid(Fields!Month.Value,4,4), mid(Fields!Month.Value,1,2), "1").AddMonths(1).AddDays(-1)
I also have a Total column that totals all months in range. What I'm having trouble with is having the total column accept the entire date range, while individual columns are showing data for the month in question.
Ex.
Service Jan Feb March Total
AD 7 5 3
15
When I click 7, it shows me those 7 occurences in January. When I click 15, I want it to show me all from Jan, Feb and March.
Any help would be much appreciated.
April 11th, 2011 2:01pm
Hi tomigafa,
To this requirement of yours, I would recommend you make use of the Action of Go To Reoprt to month and total seprately. If you click the month such as Jan or March, it just pass one special month as subreport's parameter's value, the subreport should receive single
value parameter, if you click Total, it should pass all the value from start month to endmonth to anohter subreport, this subreport should receive mutiple value parameters. I think this method should help you.
Thanks,
Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
April 14th, 2011 1:46am