I took on the task of picking up where someone left off, in trying to fix a report in SQL Reporting Services (SSRS) that someone else had composed but did not finish.
To make a long story short, I found the cause of the problem with the report that others did not. The previous consultant had modified or perhaps composed from scratch the stored procedure that this modified report is based upon.
In any case, a document is missing off of the report. But, I found the document in SQL by copying one of the "UNION ALL-ish" queries, modifying the query, and running it in SQL Management Studio. Viola! I saw the missing document!
So, I added this modified query to the stored procedure and executed it.
Next, I went to Report Builder in SSRS where the layout of the report was created and refreshed the main dataset that is based on this stored procedure. The three other datasets in the report are not based on it.
Anyway, the report ran, but that document is still not showing up on the report like it did in SQL Management Studio.
Frankly, I'm not as familiar with Report Builder as I am with Business Intelligence Development Studio. Is there some other "refresh" that I should do in Report Builder to get this document to show in SSRS?
I'm really befuddled as to why adding this additional query that displays this missing document did not allow for this document to show in the report.
Any ideas are much appreciated! Thank you!