March 25, 2015 at 1:58 pm
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?
April 8, 2015 at 10:48 am
I am not sure if this applies to your situation....
I ran into a problem returning data when a stored procedure used an alias for a field. The sproc would not return the data in SSRS, but I could see it is SSMS. I solved the problem by using a cte and subsequent select statement in the sproc to return the records to SSRS. It worked, so I am using this solution wherever I have an alias in play.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply