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...

In the sub-report I have the following:

=Fields!Started.Value

In the main report, it's just the sub-report that's there. By that I mean the sub-report control is on...

I could very well be aggregating on the subreport, in the main report. I'm far from a SSRS expert. In fact, I've not done that many sub-reports on a report....

pietlinden, I'm at work now. I've just checked the sub-report. It does use a stored procedure. Like I...

I'm at home now, so can't look up whether or not I use a stored procedure or not, but I think I do. I do know that it uses a...

Ah, thank you, Steve! OK, now I'm getting your drift, as to why Query Store is so useful.

Umm, not sure how to approach this. I read the article, but was confused in a few places. Some of this is due to the fact that I really don't...