reporting services - Trying to get the Sum Max when using hidden rows in SSRS -

I have seen everything and I have not found my exact status, so I am posting my first question. I have a report that I have grouped at several levels. Therefore, my report has a customer / header / statement / release grouping. I wrote a custom expression so that only one value, which is the maximum value in the group, is shown in detail, in which all the values ​​shown in the release are. I then set my visibility toggle to toggle the header, then expanded, then released and I have to add those maximum values ​​to a field on the report. The custom presentation you write works correctly when you are looking at the detail level. This gives the correct value, which is the maximum value in each release.

I need to report again, only adding that maximum value and rolling in the header group, so that I can get the maximum value of

I used to have Max in my exchange I tried to get the correct maximum value to use the function, but I can not get the SSRS 2008 R2 for that amount, and I have tried to write a custom expression that does not have the maximum (non-Jiro value non- Zero Which is divided by the number of records) and both methods work properly until I try to rollup and give the amount at the next group level.

I have also attempted to use the group variable and custom code and save it in a variable, but to correctly return it to my report or to get that value correctly I do not have any luck.

At its most basic, it seems that I should be able to set a sum (Max (Value! Column! ValueColumn.Value) and handle SSRs how to separate it, but repeatedly I have no luck after trying. I can not adjust the SQL because I need the details of the level which shows the report, although I can add more fields, as long as I have a group or Yoga does not add, which reduces the granularity of that data.

Any new avenue will be very helpful to detect.

Thanks in advance, Chad

I found that the extra piece I was missing was the result that I needed to give me. The expression looks like this:

  = current (property (Max (IIF (left! Field! Job new value, 1) = "s" and field! 1STol.Value 1, CDB (Fields; Week 1STol.Value), 0), "Job Itam"), "Job Itam", SM, "Job Itam")  

In this I wrapped Max's original expression, to get this rollup value, both at the jubytim level, both a sum and a currency. Now when I open the grouping, I get the right running value at every level.

What exactly does it give me, the total running in each of the four levels, even with the "max" value at the extension level. It allows me to have a maximum value inline on the report, without a hidden line, or report the footer.