This question that has come up a few times on the project on which I am currently working.
‘How to ensure that Sub Report data in Reporting Services is included when exporting to XML and CSV formats?’
This is not the default behaviour of RS but luckily the answer is very simple.
- Right-click on your sub report and select properties.
- Note down the sub report name in the Name: field of the General Tab.
- Go to the Data Output Tab and type in the same name into the Element name: field.
- Ensure that the Output: radio button is set to Yes. Setting it to Auto doesn’t appear to work.