Crosstab Query And Cache List Data (sharepoint)

[jerem]

Hi,

My data is on Sharepoint. I have a simple Crosstab query that works well unless I choose the option "Cache List Data". In that case I get a Type Mismatch error. Any idea what it could be?

TRANSFORM Sum(PivotData.QuoteTotal) AS SumOfQuoteTotal
SELECT PivotData.FullName
FROM PivotData
GROUP BY PivotData.FullName
PIVOT PivotData.StatusText;

 

[jerem]

Turns out that the issue was a data type issue due to Null value. Still don't know why it was working when Sharepoint was not caching.