haideraqeel86
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by haideraqeel86
-
-
I have same problem...Varshab94 what do you mean by uninstalling JDK1.8 version
How can we use ireport paramerter in sql query column
in Products
Posted
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