Hi,
I've been trying to get this to work for some time but it doesn't If I use your sample report I can't get it to refresh because I don't have credentials, which is fine. If I point it to the sharepoint list I created based on your instructions it complains there are columns missing. Specifically the user.title, etc. line doesn't work. I've managed to get it to go past that line in the advanced query editor but when I try to refresh it says ID 2 doesn't exist in the rowset. If I manually add that then it says ID 3 doesn't exist. If I add that it says ID4 doesn't exist and so on.
Your instructions are incomplete on how to build this the same as what's in your sample isn't what you get if you follow the instructions. Please explain how I can redirect your sample data to my list I created.
Thanks
Stuart