Hi
i need to generate single report by category wise from different tables. Is it possible?
Please refer the below format.
Report Category
Category : A
S.No Name Category value
1 name1 A 1
2 name2 A 1
3 name3 A 1
Total 3
Category : B
S.No Name Category value
1 name1 B 1
2 name2 B 2
3 name3 B 1
Total 4
Category : C
S.No Name Category value
1 name1 C 1
2 name2 C 2
3 name3 C 2
Total 5