Hi,
I can confirm items 1 and 2 have been fixed in ACRSv1.7.0.44 however I have come across further issues.
1) When opening the report after exporting, I receive an error stating "PivotTable field name is not valid" Please see screen shots attached. When selecting the workbooks containing the pivot tables all fields are empty.
2) I have followed your instructions above regarding item 3 and have used data markers in the formula as described. I have attempted prefixing the data markers with &= (i.e. &=&=SUMIFS(&=ManufacturedData.Quantity,&=ManufacturedData.BoxType,$D{r},&=ManufacturedData.ManufacturedQuarter,">="&$V{r},&=ManufacturedData.ManufacturedQuarter,"<="&$L{r})
and without prefixing with &= (i.e. &=&=SUMIFS(ManufacturedData.Quantity,ManufacturedData.BoxType,$D{r},ManufacturedData.ManufacturedQuarter,">="&$V{r},ManufacturedData.ManufacturedQuarter,"<="&$L{r}) but neither solution works. I have attached screen shot Formula Errors to show output of rendered file.
3) You stated above there are some invalid data in formula &=&=SUMIFS(ManufacturedDataQuantity,ManufacturedDataBoxType,$D{r},ManufacturedDataQuarter,">="&$V{r},ManufacturedDataQuarter,"<="&$L{r}) but this formula uses named ranges. I have discovered both ACRSv1.7.0.43 and v1.7.0.44 do not support the use of named range and the named ranges created do not "grow" dynamically as the data is placed at rendering time.
I will send the .rdl file by email which contains the report design including the named ranges used. I believe the named ranges should expand dynamically as data is placed during rendering time but this is not the case.
Please investigate !