Jump to content
We've recently updated our Privacy Statement, available here ×

haideraqeel86

Members
  • 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

  1. 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

×
×
  • Create New...