In i Report I'm using parameter in SQL query, but the parameter field is not showing in the data set. I have a fee Structure Table which 12 Months Columns for Amount, I'm trying to get the desire month by passing the parameter as column, but the parameter column is not showing in the data field. Here is my Query, I'm Passing FeeStructure.$P!{Months} as a Parameter Column. SELECT StudentInformation.ID, School.School,School.Logo, Branch.BranchName, Parents.Parents, StudentInformation.StudentName, ClassS.Class, Section.Section, StudentInformation.AdmissionNo, StudentInformation.NOC, StudentInformation.FatherName FROM StudentInformation INNER JOIN Branch ON StudentInformation.BranchID = Branch.ID INNER JOIN ClassS ON StudentInformation.[C/Class] = ClassS.Id INNER JOIN Parents ON StudentInformation.ParentID = Parents.ID INNER JOIN School ON StudentInformation.SchoolID = School.ID AND Branch.SchoolID = School.ID INNER JOIN Section ON StudentInformation.[C/Section] = Section.ID
