I'm new to SSRS and have been tasked with converting our Crystal Reports to it. The problem I'm running into is when trying to hide the detail rows which contain the data for the group calculations, the expressions no longer get calculated. How can I hide the detail data, but still execute the expressions in those rows so that the group summaries are accurate?
Values before setting row visibility to hide -
Values after setting row visibility to hide -