grouping in FR
I have table like this
Invoice# Item Amount
1 Bag $10
1 Shoes $15
1 Hat $20
2 Pen $5
2 Paper $7
I need to group into 1 table with Invoice Number and Amount like that
Invoice# Amount
1 $45
2 $12
I don't know how to do. I read about the grouping of FR and see it strange.
Could any one help me with this simple thing?
Invoice# Item Amount
1 Bag $10
1 Shoes $15
1 Hat $20
2 Pen $5
2 Paper $7
I need to group into 1 table with Invoice Number and Amount like that
Invoice# Amount
1 $45
2 $12
I don't know how to do. I read about the grouping of FR and see it strange.
Could any one help me with this simple thing?
Comments
it relys on one joined query accross multiple tables to return all the data required
the orderby clause of the query is ordered by the order of the conditions in the group headers.
Hi,
The main problem if we use grouping of FR is like that:
FR use separate Band for Group
all the field we use for group will display on a separate line above the data.
For example, in this case we use group by Invoice#
system will display like this:
1
Amount
10
15
20
But we need to display on the same like and group the Amount too
1 45