ADDING TOTAL AND SUBTOTAL FROM TWO DATASETS

Question

Hi there!

I working in this report with two dataset, I need to add a subtotal and total, the balance is coming from Dataset2, and I bring this Balance with a Lookup .... everything is working fine, but I can't bring the subtotals 

Thank you

Answer 1

Hi YSABEL

Can you give out some more idea, on scenario screen shot for our reference.

You can get more idea on below link, hope this will help you.

Nested aggregate error with SSRS subtotal and grand total

Thanks

Suhas

---

Mark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful.

My Blog

Follow @SuhasKudekar

Answer 2

Hi 

I have a table with two dataset, I joined both dataset with a Lookup, a brought all the student who is taking the listed classes with a particular professor ( I used parameter) with balances here I did a lookup to the dataset Student where is the balance, Now I need a sub total for class and a Total by Professor

MAT101

MAT110

MAT201

MAT205

Thank you

Answer 3

Hi Ysabel1111,

Based on my understanding, you are retrieving data from another dataset with Lookup() function within a tablix. Then you want to perform a subtotal and total, right?

In your scenario, since you are using Lookup() function to retrieve the second dataset’s data, you should embed the Lookup() function within Sum() function to perform subtotal or total. Please refer to our test steps and results:

1. We use Lookup() function to retrieve Balance field from DataSet2.

2. Specify the subtotal and total expression like below, then preview the report.

Besides, you can only create one dataset, then specify the query to join the two tables. So that you can specify data for a tablix without Lookup() function.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

---

Qiuyun Yu
TechNet Community Support