E_DPSG
Board Regular
- Joined
- Jul 17, 2008
- Messages
- 82
Okay - So long story short, I have a pivot table that gets its data from sql server using a data connection. Simple refresh and populate the data. One of the fields is being utilized as a filter for the pivot table.
My problem is that on refresh today the filter values are missing 1. Did it pack up and leave? Not sure. The field contains 3 possible values. 2 are present, the 3rd looks like a blank. If I drop into the record set the missing value is present in the data.
Any ideas as to how to get the one value back?
Thanks guys
My problem is that on refresh today the filter values are missing 1. Did it pack up and leave? Not sure. The field contains 3 possible values. 2 are present, the 3rd looks like a blank. If I drop into the record set the missing value is present in the data.
Any ideas as to how to get the one value back?
Thanks guys