Sharepoint refresh - 3 lists - no data

Good news. I believe Refresh is working... and it has alwasy been working as it correctly reported.

I have managed to uncover what's going on and a difference between Desktop and Service (which requires more research).

I have a TRUE/FALSE field that is used as a primary filter. Only I've now discovered it's turned up in the Service after a refresh as 0 and -1.

For those that are interested here's how I found it. I built a diagnostic page to tell me what data was present:

Of course this told me that I had data - it didn't tell me why it wasn't being displayed...   aka filters...

Removing the page level filter and my report starteed to work (except that it was unfiltered).

So... what is this True/FALSE thing anyway... This needed some closer investigation.

Here's the load part on the Desktop... everything looks OK.

But after it's all published to the Service and refreshed... it turns up as 0 and -1 (not what I was expecting, and not what's happening in Desktop).

Lastly here is the Sharepoint definition of that field... At least now I know what's happening... I might go back to the desktop and reload the list (clean) and see what happens.

- David