October 22, 2004 at 1:56 pm
I'm trying to convert reports from Crystal to RS. I have textboxes that use nested IIF statement in the details section. I would like to aggregate these text boxes (sum) at each Group level. I can't seem to get this to work. Any ideas, please? IE: January 0 February 0 March 25 Total 25
|
October 25, 2004 at 8:00 am
This was removed by the editor as SPAM
October 25, 2004 at 7:00 pm
if you could add as many details as you can I would be happy to help you but the information you have provided is not nearly enough to help you.
October 27, 2004 at 2:06 pm
I'm basically using this expression, and I'm using this statement at the
details level , then would like to sum these values up at each group.
=iif((ReportItems!MONTHCOUNTER.value ) =First(Fields!month.Value,
"MonthtoDate"),(fields!Net_Amount.Value ),0)
Is this an aggregate of aggregates? or is there another way of doing this?
The iif part basically checks to see if the month of the data is the current Net_amount. then example:
details March (the results of the above expression) 0
April 0
October 25
monthly total = 25 (sum the details)
Location = 100 (sum of all the monthly totals)
Hope this detail makes sense. Thanks!!
=iif((ReportItems!MonthCounterMonth.value ) =First(Fields!month.Value, "MonthtoDate"),
runningvalue(fields!Net_Amount.Value ,sum,"MonthYear"),0)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply