thats the best thing you could have said "what second dataset"
I was using 2 datasets, one for the main data set which had all of the information in the table, then a second with the stored proc
i have removed the first one, so nows there is just one data set using the stored proc. And its working.
SSRS Newbie at work! Thanks for your help