I have a simple report running from live data (not a view or reports server table). Everything in the report is correct except two date fields I'm pulling. Weird thing is...they return the date fields from the record above the line of the actual record in the data.
For example:
Name............Address.........Transfer Date........Begin Date
Joe Fox.........123 Main St....04112010.............05122011
Jane Doe.......245 Cox St....08152010.............09222010
So in my report, Jane Doe is returning everything correctly but the dates are those of Joe Fox.
Any suggestions?