Well, this is weird:

My server: SharePoint 2013 Enterprise farm with SRSS up & running & several simple reports working.
My development environment: Microsoft Visual Studio 2013 Pro with SQL Server Data Tools for Visual Studio

The Problem: I am designing a "MainReport" with several datetime parameters, containing a tablix, and I need to display in a cell the value of a field that is in another list.

  • My main list is called "Documentation"
  • It has a lookup field that references a "Document Set" library called "Contents".
  • I need to obtain a metadata field value from the document set list.

My approach: To achieve this I've created another report called "SubReport" who has a query that filters the items by ID (received as a parameter) and shows the right value in a textbox.

I can run this "SubReport" alone anytime I want to.

Then I've added this "SubReport" inside a cell of "MainReport"'s tablix, configured all the properties, and using the expression editor I'm sending the current row ID as a parameter.

Question: What's weird?

Answer: It only works the first time you run the main report, if I do a refresh or try to filter again the report it shows "#Error" inside the cell instead of the "SubReport" right value.

This means that if I come back to design the "MainReport", remove the "SubReport", and add it all again, the report will show the right output again.

Solution: You tell me, please.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.