In migrating reports from SSRS 2014 to SSRS 2016 / PowerBI RS, we have some reports with text that renders fine in SSRS 2014 but is hidden in SSRS 2016. However when downloaded to Excel, the text appears.
I have attached below two simple RDL files that contain their own stand alone SQL statement (so no SQL table is needed). These files both render fine in SSRS 2014.
The yellow cell is the cell we want to focus on. The yellow cell is also set to unhide/toggle the group "GroupB". When the report named ARenderBug.rdl is executed on PowerBI RS it will not show the text or the toggle in the yellow cell unlike the other report or SSRS 2014.
Both files appear the same but differ in the "can grow" property. In the case of the working report, the "can grow" property per row is the same option per cell (false or true). But in "ARenderBug", there is a mix of "can grow" property states per cell. If the yellow cell is set to "can grow" false, and either of the two cells to the right is set to true, then the text and plus sign disappear from the browser display in the yellow cell. But it will still appear on Excel downloads etc.
For the reports attached, they are still using "shared data sources" and so I cannot render them locally. You can repro this by uploading those reports to your server and trying to render them without making any other changes. Can you please attach the ones with the local data source you mentioned earlier that can be rendered without any changes? Thanks.
Thanks, I can repro and can see the cause of the issue now. We'll need to do a bit more investigation however on the desired behavior. Do you have a link to the bug you opened at https://connect.microsoft.com/SQLServer?