Can not show Sub Report after changing to R2

Question

Hi everybody , 

I've got a strange problem ,we have a reporting with a sub report to show the classes of a student with discipline which is not the same
as the class in the main report. 

For ex: 
Class A 
     student 1(sub report level 1)
           the other class of this Student (sub report level 2)     ===> first place 
     Student 2
           the other class of this Student

Class B
     student 1  
           the other class of this Student                                    ===> second place 
     Student 2
           the other class of this Student 

It works with SSRS of SQL 2008. A month ago, we did a update, and change to SQL 2008 R2 . after that , the probleme appears.
as you can see in my examle, Student 1 can have ClassA and B , so in the report, in the first place and second place, the sub report 
should show the the classes. but actually in the "first place" , the sub report shows well , but in the "second place", we got nothing. 

I've tried to modify this sub report try to find why, and I got this:
In this sub report, I have 2 datasets, if I delete one of them, the report could be showed correctly.
but this report works fine with SQL 2008 !

Is it a knowen issue or anybody could give a solution for this ?
Thanks 

Answer 1

I think you already have the solution, not sure why you have two datasets.

Perhaps this tricked the upgrade, but all these issues are like fix and forgot, why would you need to know more?

But if you are really interested and can reproduce this nuance, then by all means go submit a bug to MS Connect.

---

Arthur My Blog

Answer 2

In fact , I have two DataSets to get different informations, and I need the infos to show in the sub report,
if I delete one of them, my client will not be satisfied . :(

Or maybe I can merger the sql of this two DataSets , but it is really not a good idea .... 

Any suggestion will be greatly appreciated