November 10, 2016 at 10:18 am
Good Morning/Evening Guys,
I would like to ask what would be the most likely reason why a Dataset result set will not appear on the report Level but does appear in the query analyzer inside ssrs. the report I created derives it's result on a Table Valued function as our client wants to avoid using Stored Procedure but still we need to be able to pass parameters in the function for the report. any guidance/wisdom you can impart on me is very much appreciated.
Best Regards,
Noel
November 10, 2016 at 2:01 pm
A few quick hypotheses off the top of my head:
1. A filter in the report tablix might be removing the results
2. A visibility expression in the group/tablix might be hiding the rows
3. The data source in SSRS might be pointed to a different DB
4. The default user in the data source might not have permission to run the query
5. If you're looking at the report in SSRS using Chrome, it often won't show any results (I use IE for SSRS)
6. There might be something wonky in how SSRS is passing the parameters to the query - make sure the data types match.
7. If any of the parameters are populated by datasets, the queries for those datasets might be incomplete. Let's say we have a parameter @store, and I have a query for that parameter which lets me choose store 1, 2, or 3. If there is also a store 4 and I enter it, the report will bring up no results because it doesn't think that's a valid value (this might just be a 2005 issue).
8. In Visual Studio 2005, you sometimes have to refresh the datasets to get new data to show in the report.
I haven't used table-valued functions in place of SPs, so I don't know what additional complexity that might offer.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply