Wednesday, October 03, 2012 10:24 PM
Greetings and thanks in advance for the help, Here is my situation:
The Below script works fine in BIDS, but does not work when hosted on our sharepoint 2010 server,
=Max(Iif(Fields!Country.Value = "Total", Fields!OOS_Rate.Value, 0))
The dataset has already been rolled up, (with the country replaced by the word "Total" for the summary line) and I wanted one particular piece of data from the summary row for a table near the top of the report. I can create another dataset as a workaround, however I'm curious what is causing the issue so I can avoid it in the future.
Thursday, October 04, 2012 2:55 PM
This is strange, because it should work.
What result do you get?
Thursday, October 04, 2012 3:43 PM#Error is the result that displays in the columns, It doesn't raise any warnings in BIDS or Report builder, it's really bizarre.