SP2 causes OWC 10 Pivottable to return empty report

G

Greg

Our corporate workstations were recently upgraded to SP2.

Several of our reports quit working.
The impacted reports contain expressions using Month() function and nested
iif() functions.
Anyone know what the root cause or fix is?
 
G

Greg

Don't know the reason ... but found a work around.

In my Pivot I had created a calculated detail field/expression with a nested
iif to create a filter:

broken in SP2 >> FLAG1:
iif(month(date1)=3,"Yes",iif(month(date2)=3,"Yes","No"))

Under SP1, I could place the FLAG1 field in the filter area and pick "Yes"
or "No" or "All" and all was well.
On the SP2 machines the filter dropdown would display a string of "Yes" and
"No" check boxes ... almost like it interpreted each as a unique choice
rather than just one "Yes" check box and one "No" checkbox.

Regardless, If I just changed iff return values to numbers instead of "yes"
and "No" text values, the report works in both OS versions.

Working >> FLAG1: iif(month(date1)=3,1,iif(month(date2)=3,1,2))

Hope this helps someone else.
Greg
 
Top