You could use a expression on the format of the textbox. YOu'll need to likely tweak this a bit, maybe use a Row Number function instead of the ID's value,...

This doesn't look like the logins are "disappearing", but that the there is no user linked to that login on the database. When creating the login, are you also creating...

Here's a very quick "introduction" that I wrote up while waiting for the coach. This might give you some idea on what you can do with powershell:
[CmdletBinding()]
Param(
 ...

Add an expression to the colour on the text box which returns the colour. To start you off:
=iif((Fields!YourField.Value = "TOP RAIL") Or (Fields!YourField.Value = "BOTTOM RAIL"), "Red", iif((Fields!YourField.Value =...

When you say query, what is your goal? To run the same query on multiple instances, which will return many resultsets, or are you aiming to run one query/process that...

With LAG([FieldName],2), I'd also expect the 2nd row to return a NULL as well. The 2 is telling SQL Server to return the result from 2 rows prior....

A Calendar table is the right method, so if it's not working I would guess you're SQL isn't right.

You need to use the dates in your Calendar table...

Yes, it does (as shown in the picture in the highlighted text).

https://www.microsoft.com/en-us/sql-server/sql-server-downloads