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

Anybody?
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2011 8:35am

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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics