Why does your body need to access the page number?

If ther'es multiple tables, i need multiple tables in my sample data. I can only work with what I'm given.

Initially you asked for the min and max for...

Why do you need it in the report body? Can you not put it in the footer?

With a lot of data, this won't be that quick, but:
CREATE TABLE #Weights
  (TotalWeight varchar(20));
GO

INSERT INTO #Weights
VALUES
  ('14 lb 7.6...

So, after getting home, I noticed that you don't actually explain what you want your expected output to be. In your earlier query you only reference code and id, but...

As I'm leaving the office now, I'll finish this later, but to save another user creating the sample data:
USE TestDB;
GO

CREATE TABLE #Sample
  (RECEPÇÃO...

Consumable sample data, expected output? Does my above SQL not help? 🙂

Does seem you've missed the aim I'm afraid.

Firstly, this is the SQL you should be looking for:
SELECT CAST(a.validtimestamp as date) AS DateStamp,
      ...

Could you provide a full SELECT statement and consumable Sample data please (normal drill). That JOIN on it's own doesn't really mean a lot to us.

At a guess,...

Duplicate of https://www.sqlservercentral.com/Forums/1869456/I-am-not-getting-COLUMN-TITLES-in-every-page-Why-is-that. Please direct answers to the original thread.