Group on Joint Data Set

dmitrygusev

Is it possible to group on result of Joint Data Set?

The problem. I have two Databases, the first (db1) is containig one table:

TableA

---

row_id | counter

---

5 | 1
6 | 1

---

The second (db2) contains TableB:

TableB

---

row_id | group_id

---

5 | 1
6 | 1

---

What I need is to get the following result:

Result

---

group_id | total

---

1 | 2

---

Where group_id is the TableB.group_id and total is the sum of TableA.counter grouped by TableB.group_id

I can declare two datasetes for each database (db1_dataset and db2_dataset) and make a join on row_id column.

Now, how can I group on group_id? Is it possible? Or is there any other solution rather than group on joint data set?

mwilliams

Hi dmitrygusev,

You should be able to make a table in your report, bind it to your joint dataSet, insert a group that groups on group_id, then put the group_id and an aggregation that sums your count_id in your group header/footer.