Count Number of rows
Assume that I have created table called " StudentInfo" and each student attend specific grade. I want to count how many students in "GradeOne". How can I do that ?
***Edited by Moderator: Pooja Gadige to add capability tag***
Coforge DPA
GB
@AhmedE40 Hi
In your report definition, you can define column as "Grade" and summarize it as "Count". You can have a data page with source as report definition and get count in data page.
Hope this helps.
Regards
Bhavya
Tools & Solutions
EG
@Bhavya Thank you very much for your answer. But my question is to count specific rows based on the grade. For example : In "GradeOne" we have three rows. In "GradeTwo" we have only one row. Can you please attach screenshot ?
Coforge DPA
GB
@AhmedE40 Hi Configure your report definition something like below:
Your output will be as :
As per my RD, it gives me in a specific category how many code are there. You can replace this with Grade and ID.
Hoep this helps.
Regards
Bhavya