I have a report that receives its data from a stored procedure and when I preview the dataset all the data is in all the fields. However, when I preview the report or deploy it the data in one of the fields is not displaying. The data for that field is retrieved from a nested sub query in the stored procedure using the top N clause. I have another field in the main SELECT statement and it is showing that data just fine.
In trouble shooting the problem I created a table and just dumped the data into it and changed the dataset to pull from that table and when I do that the field shows the data just fine. Doing this for the final solution will not work however.
Any thoughts on what could be going on?