Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
The recently released 2020 SSRS has a critical bug that needs to be addressed as soon as possible.
Reports worked from VS and previous version now won't run in the portal.
It seems when rendering the SQL back to MSSQL server, a parameter that is similar named as an existing one has its content replaced.
i.e.
@prmUser and @prmUserName
If @prmUser = "123" and @prmUserName = "Username" and report sql has select * from table where userid = @prmUser and username = @prmUserName, SSRS is replacing the @prmUsername with - username = "123"Name
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.