Trouble grouping with my table
I have a basic Master-Detail table setup.
My Master table has fields AccountID, AccountName, Heading
My Detail tables has fields TranID, AccountID, Amount.
I want a report output similar to DEMO Report #17 (where the Detail
transactions are summarised on one line for each Master)
As you can see from my Master table I have a Heading field
(indicaticating it is a header account; no transactions can go to that
account). I want to use the Header field (containing either a H or a
blank) to indicate my groups.
For example: my Master sample data is
ID Name Heading
1 Account1 H
2 Account2
3 Account3
4 Account4 H
5 Account5
6 Account6
7 Account7
8 Account8 H
.
.
and my report should be
Account1
Account2 $10.00
Account3 $ 5.50
------
$15.50
Account4
Account5 $12.00
Account6 $ 9.00
Account7 $14.00
------
$35.00
Account9
.
.
So basically, I want to group on the header accounts (whick have a H
in the header field)
Should I change my table feild design, or can I setup a report to
handle the existing data.
thanking you
My Master table has fields AccountID, AccountName, Heading
My Detail tables has fields TranID, AccountID, Amount.
I want a report output similar to DEMO Report #17 (where the Detail
transactions are summarised on one line for each Master)
As you can see from my Master table I have a Heading field
(indicaticating it is a header account; no transactions can go to that
account). I want to use the Header field (containing either a H or a
blank) to indicate my groups.
For example: my Master sample data is
ID Name Heading
1 Account1 H
2 Account2
3 Account3
4 Account4 H
5 Account5
6 Account6
7 Account7
8 Account8 H
.
.
and my report should be
Account1
Account2 $10.00
Account3 $ 5.50
------
$15.50
Account4
Account5 $12.00
Account6 $ 9.00
Account7 $14.00
------
$35.00
Account9
.
.
So basically, I want to group on the header accounts (whick have a H
in the header field)
Should I change my table feild design, or can I setup a report to
handle the existing data.
thanking you
This discussion has been closed.
Comments
Groups in ReportBuilder are determined by the changing of the break value
given by the user. If you would like Account 1, 2, and 3 in the same group,
you will need to make their break value (Heading) the same, then change the
break value for the second group so a new group will begin for Account 4, 5,
6, and 7. It is usually best to use a field that contains similar
information for all the grouped data. For instance in a Customer - Orders
table, you may group on the customer number since there are many order
numbers for each customer.
ID CustNo OrderNo AmountPaid
1 1 1 100.00
2 1 2 200.00
3 1 4 200.00
4 2 3 10.00
5 2 5 500.00
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Just curious about the internal workings of RB, as it is processing
each record of the dataset, can I fire the Grouping event manually
(depending on a record field value)?
ie I have no grouping on my Report structure at all, then run the
Report and process the records in turn, and fire the Grouping event
when I wanted
thanking you