January 2, 2019 at 6:59 am
I have added option(recompile) at the end of my stored procedure but, the report still doesn't return any records. Any thoughts? I've also added "dummy" variables.
January 2, 2019 at 7:15 am
There's not a lot to go on there. There's a huge number of reasons why your report isn't returning anything. You'll need to provide much more detail to get a truly helpful answer. That said, there are two prime suspects for me when I have the same problem.
First could be that the account under which you're running the report doesn't have permission to see the data. Second is the possibility that there's no data to find. If there are any parameters on the report, try widening them i.e. if you've only run the report over a day, run it over a week or a month.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 2, 2019 at 7:25 am
Thanx. I was running a different date range on the procedure from the report. All is well.
January 2, 2019 at 7:30 am
NineIron - Wednesday, January 2, 2019 7:25 AMThanx. I was running a different date range on the procedure from the report. All is well.
Been there, done that 😀
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply