Forum Discussion
Second Level of Sub Report Error In Paginated Report
Hi Anonymous ,
Please review the following threads which has the same problem as yours, hope it can help you.
SSRS 2008 R2 - Lookup from subreport
No, the lookup function won't go beyond the scope of the report. Your question isn't very clear on what exactly you're trying to accomplish (which would be helpful) but I'll try to guess.
If you're looking to pass some values to the subreport from the parent's dataset you could check this blog post about doing that, though I haven't tried it myself. You could also use a shared dataset to avoid rewriting your queries if you need to use the dataset again in both of the reports.
According to this msdn social thread it doesn't appear to be possible to pass a value to the parent report from the subreport. However, another thread on sqlservercentral.com seems to have some promise but it didn't seem to work for everyone. Once again, I haven't tried it myself.
Report Builder functions - Lookup function in a paginated report (Report Builder)
Best Regards
Hi and thank you for the info. This was not about lookup function going beyond the scope of the report like using a lookup function to lookup data in another subreport.
This is about a subreport that has a lookup function within its own report fails. Here is more info:
Report 1 has Report 2 as a subreport. Report 1 has its own dataset1 and passes parameter to Report 2.
Report 2 has a subreport Report 3. Report 2 has dataset2a and dataset2b. Report 2 has a lookup function in a table using dataset2a lookup on dataset2b. Report 2 passes parameter to Report 3.
Report 3 has one dataset3 and no lookup functions and is the last report in the chain.
Report 2 loads fine and you can see Report 3. Report 1 does not work. Removing lookup function in Report 2 fixes the issue.
Is this more clear?