I'm using VS22 and Microsoft RDLC Report Designer 2022. My problem is : I have a matrix with data in it and if a visibility change occurs on any of the elements in the page, my lines are filled with "#Error". Here is a small example I made :
The columns contains the same fields used in the one which doesn't work.
-And here is the exact same part with the title opened
-Here is the value of the last column :
=IIF(Lookup(Fields!DateTime.Value,Fields!DateTime.Value,Fields!StopOnLoad.Value,"dsProduction_dtProdDetailSection") = 1 OR Lookup(Fields!DateTime.Value,Fields!DateTime.Value,Fields!StartOnLoad.Value,"dsProduction_dtProdDetailSection") = 1, Nothing, IIF(Fields!Stable.Value = 0, "[", "") & FORMAT(Fields!CurrentFlow.Value, "N2") & iif(Fields!Stable.Value = 0, "]", ""))
I tried using the less possible datas on my report and updating the dll files of Microsoft.ReportViewer in my C# project.