Hi, I have a report that became more an more complex. I have a matrix with several grouping levels and each textbox contains a huge expression with SWITCH and IIFs. Besides is more and more difficult to modify something in the report or troubleshoot it (without skipping or loosing something) I would like to know if there is any limitation, how the performance will be affected by that? Would be a better solution to find a way to write a code in report instead? Or something else...? Thank you!Geozah

It is always recommended that make a document for all the expressions you have used in the reports or simply try to modify query if you can provide that functionality by sql so it will be easier for future team members to modify something on later date rather finding one by one expressions in the text boxes.

It is always recommended that make a document for all the expressions you have used in the reports or simply try to modify query if you can provide that functionality by sql so it will be easier for future team members to modify something on later date rather finding one by one expressions in the text boxes.

Hi, I have a report that became more an more complex. I have a matrix with several grouping levels and each textbox contains a huge expression with SWITCH and IIFs. Besides is more and more difficult to modify something in the report or troubleshoot it (without skipping or loosing something) I would like to know if there is any limitation, how the performance will be affected by that? Would be a better solution to find a way to write a code in report instead? Or something else...? Hi Geozah, Generally, you could add custom code to your report when you need to perform complex functions and you need the capabilities of a full programming language to accomplish them. However if the build-in expression functionality can meet your needs, you'd better choose build-in expression functionality, as using .NET embeded code or Custom assemblies can give you serious performance degradation. Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Thank you both for your answers. Have a nice day! G.Geozah