Drill Through Parameter Cognos 10.2.1

[kgcognos]

In my summary report, I have 2 amount columns that I want to use drill through to see the list of orders that make up the amount. One column is for This year amount and 2nd column is for Last year amount.
I set up 2 Order reports to drill through. The reports are identical the only difference is the year filter. One report selects This year and 2nd report selects Last Year. My drill through is working fine with this setup. When I click on This year amount it drills through This Year Order Report. 
When I click on Last year amount it drills through Last Year Order Report.

My question is, is it possible to drill through just 1 Order report instead of having 2 separate reports?
Is it possible to set on a parameter on the Summary report when a column is clicked? ie it will set rptparm to '1' if This year column is clicked or '2' if last year.
I can then pass this parm to the Order report and filters the correct year based on rptparm value.
In this way I don't need to maintain 2 drill through reports.

Thank you in advance.

         

[MrPogle]

One way to do this is to add a couple of data items to your query and make each one some text to identify which report you want to see when you drill down e.g. ThisYear and LastYear for both the name of the data item and its contents.

In the target report, have a parameter called something like pReportYear in a filter which will be a case statement something like:

case when ?pReportYear? = 'ThisYear' then ThisYearTotal else LastYearTotal end

In your source report, define the drill down on the yearly totals as you already have but include as a data item value ThisYear or LastYear depending on which total your're defining the drill for, for the ?pReportYear? parameter.