how to pass values of resulted by query of main report to subreport parameter?

Friends, while I was generating excel sheet,to merge the cells in columns which are having same data, I am using this logic. Logic is, I am using subreport for each column in report/excel sheet.in subreport I need the same value of main report query resulted, as parameter value which I want to assign as value in where condition of subreport query.