How to use aggregate and groupby clause for reporting in VBCS.

Summary

How to use aggregate and groupby clause for reporting in VBCS.

Content

How to use aggregate and group by clause for reporting in VBCS.

Business Scenario:
We have below mentioned objects in one to many relationship:

Table A:

AID (Primary Key)	Name	Type	Comments
1	Test	Business	-
2	-	-	-

Table B  (Contains list of all questions asked): AID references Table A primary Key

BID (Primary Key)	AID (Foreign Key)	Question	Title	Comments
10	1	Java	Do you know Java	-
11	1	Driving	Do you know driving	-

Table C (Contains answers for each of the questions asked by different users): BID references Table B primary key

CID (Primary Key)