Reputation: 63
I'm create a SSRS report where I'm trying to create sub query with 2nd report working fine but its giving me repeat Records
see the below image anyone know where i'm wrong
Upvotes: 0
Views: 257
Reputation: 2941
It looks like you are calling "Report1" from "Report2"
Your screen shot confirms my suspicion that the subreport is embedded in the details group on Report2.
All you need to do is on Report2, insert a row outside the detail group and add your subreport in that line and take it out of the details group. That should do the trick.
Upvotes: 0