What concerns me, with the increase use of AI and ML, is the intentional suppression or exclusion of some data. I've seen this in action. My previous job was working...

I've known of synonyms in SQL Server for years, but haven't created them. Definitely can see the usefulness of them, especially when some tables' named have been appended with things...

In my previous job I was primarily a developer. However, I also managed our SQL Server and our Active Directory. In one location we moved to I helped pull cable...

We use NuGet a lot for .NET development. Love it. We've talked about setting up a NuGet server, so we could deploy our own packages in-house. I know this is...

Thinking about what you said, Jeff, I believe you're right. There's a lot of "a database is just a fancy file folder" mentality. Therefore, those who tend and maintain it,...

Getting great feedback here, thanks. Looks like it is more where I live and the nature of many of the jobs here, that I'm getting overwhelmingly short term, contract jobs...

I wasn't aware of tables variables, until I read your article, Ben. So, no, I've never used them. I've either used temp tables or CTE, but only when needed. We've...

Yes, I finally figured it out. The sub-report on the main report has a property about keeping the border around the sub-report, if there is a page break. All of...

Like this article! I've seen and am seeing that 10th century models of work. Kinda sad. I'm witnessing lots of work that's being done, only because that's how its always...

Jeffrey,

Here are the stored procedure parameters:

 CREATE PROCEDURE [dbo].[spStopDetailsByEntryID]
       @EntryID int
 AS

And here's a pic of the sub-report's parameters

And here's what it looks like from...

Something else I want to mention, in case this has some bearing on my problem, I've only tested this by using the Preview functionality within Visual Studio 2017. I've not...