I've checked else where on google and can't seem to find anything on this topic so I figured I'd ask it here. I have an SSRS report with some custom code to calculate the Top N sum (needed to use custom code since the SUM function sums the entire dataset and not the filtered dataset). The code is below for reference but I know it's working, as on the preview tab in Visual Studios 2008's ssrs report builder it displays the total fine. The problem is when I export the report (to any format, but looking specifically for excel), the value in the total shows 0. I was under the impression that the rendered version is what is exported, but it seems I was wrong, but even so, shouldn't the export save the same result that the preview shows?
Has anyone seen this issue, and figured out a solution? Thankfully I tested the export before doing my sums for each column of the report (there are roughly 25 columns which need to be summed, and only finding out this after would have been terrible news).
The data is coming from an Analysis Services cube.
Unfortunately I cannot attach a sample of the report as it contains confidential information.
Thank you in advance!
Public total as Integer
Public totalField as new System.Collections.HashTable
Public function AddTotal(ByVal product as String,Byval value as Integer)
if (totalField(product) is nothing) then
total = totalField(product)
total = total + value
Public function GetTotal(Byval product As String) As Integer