use a tally/numbers table and DATEADD. Maybe I should add a link to Jeff Moden's article on Tally tables.

December 10, 2018 at 6:52 pm

#2015954

Rod,
did you ever get this figured out?

Not bad for a beginner!  I should ask you what you tried first. (It helps if you post that too, because people are more likely to help you if you...

Since you have a bunch of GETDATE()'s... why not just stuff that value into a variable, and then just compare to that?

DECLARE @CompareDate DATE =...

The whole point of doing the delete in batches is that it doesn't increase the size of the log.

or am I missing something?

As for processing a...

How about this? (Thanks for the data, but if can provide CREATE TABLE scripts, you'll get better answers, because people can just copy & paste to create your setup.

When you set up the connection to your data source, did you specify Oracle as your source? Looks like SSRS is expecting you to be connecting to a different data...

Is your backend Oracle? That looks like PL/SQL, not T-SQL.

It shouldn't. The only way I can see that making a difference is if you're filtering the report based on who's running/reading it (using a filter on the username).
You...

That looks normal. You don't have any filters on the subreport, do you?
What happens if you make the parameters for the subreport visible (temporarily) and open it by itself?...

Why not use LAG() to get the previous ship date for a tracking number?  This is ugly, but I think it'll work:
SELECT x.tracking_number
    , x.ship_date
    ,...

This is close...

CREATE TABLE #tblA (
    Yr INT
    ,Title CHAR(3)
    ,Country CHAR(2)
    ,Age TINYINT
);
CREATE TABLE #tblB (
    Yr INT
    ,Title CHAR(3)
    ,Country CHAR(2)
    ,Age TINYINT

This sounds like a job for PowerShell
https://community.spiceworks.com/topic/468653-powershell-script-to-remove-the-password-never-expires-in-ad-to-users-in-a-file

You'd be able to tell because when you drop the field on the wrong report, you'd get something like
= FIRST(DataSetName!FieldName.Value)

instead of just the fieldname.
=FieldName.Value

I...