General information
Category:
Reports & Report designer
Title:
Report Data Grouping Problem
Dear Experts
Table1 has four fields as
group n(2)
sno n(4)
country c(20)
amount n(5)
Data in fields is as
group--sno---country--amount
--11---1101--India-------500
--11---1102--Iran--------400
--12---1203--England--200
--22---2207--Japan-----300
--25---2510--Egypt-----100
--26---2615--China-----700
--32---3202--Russia---800
I want to make Data groups based on every Unique First Digit of group field as
according to above data THREE data group are made as
First Group=1
Second Group=2
Third Group=3
How to make data groups?
What should I write in Group Expression and Print When columns
I need following output
group--sno---country--amount
--11---1101--India-------500
--11---1102--Iran--------400
--12---1203--England--200
amount sub total 1100
--22---2207--Japan-----300
--25---2510--Egypt-----200
--26---2615--China-----700
amount sub total 1200
--32---3202--Russia---800
amount sub total 800
Please help
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only