Crystal Report Formula needed
-
i am having a like this Name -Nikhil Bhivgade Class-6th ------------------------------------- 1 English 100 50 Pass 2 Maths 100 50 Pass 3 Science 100 20 Fail 4 History 100 20 Fail -------------------------------------- in report footer i want to display failed subject Sr.No and Name you Failed in 3.Science,4.History
-
i am having a like this Name -Nikhil Bhivgade Class-6th ------------------------------------- 1 English 100 50 Pass 2 Maths 100 50 Pass 3 Science 100 20 Fail 4 History 100 20 Fail -------------------------------------- in report footer i want to display failed subject Sr.No and Name you Failed in 3.Science,4.History
Use a global variable. Global variable is visible for all the sections of the report. String Append Sr.No and Name of the subject based the status pass or fail. The formula can be: FormulaA : [Used in the PageHeader][Display of Formula Suppressed] Global stringvar FailedDetails; FailedDetails = ""; FormulaB: [Used in Detail Section][Display of Formula Suppressed] Global stringvar FailedDetails; WhileReadingRecords; if (status = "fail") FailedDetails = FailedDetails + SrNo + " " + Subject FormulaC: [Used in Footer Section] [Display of Formula Not Sppressed] Global stringvar FailedDetails; FailedDetails; For more information: Search in google with the keyword - "WhileReadingRecords" and "WhilePrintingRecords" The above formula do not work by copy paste. You need to make some adjustment based on the Syntax. Hope it Helps :)
-
Use a global variable. Global variable is visible for all the sections of the report. String Append Sr.No and Name of the subject based the status pass or fail. The formula can be: FormulaA : [Used in the PageHeader][Display of Formula Suppressed] Global stringvar FailedDetails; FailedDetails = ""; FormulaB: [Used in Detail Section][Display of Formula Suppressed] Global stringvar FailedDetails; WhileReadingRecords; if (status = "fail") FailedDetails = FailedDetails + SrNo + " " + Subject FormulaC: [Used in Footer Section] [Display of Formula Not Sppressed] Global stringvar FailedDetails; FailedDetails; For more information: Search in google with the keyword - "WhileReadingRecords" and "WhilePrintingRecords" The above formula do not work by copy paste. You need to make some adjustment based on the Syntax. Hope it Helps :)
It is returning me false any suggestion