How can we use ireport paramerter in sql query column

[haideraqeel86]

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

[hozawa]

Should be using Jaspersoft Studio because iReport development has ended.

In Jaspersoft Studio, just create a parameter "Month" and use $P{"Month") in your sql statement.