I feel like I'm on a witch hunt now, as I've asked in your questions so many times (with no reply),but Jigjitsigh, DDL and Sample data... please.

You're doing...

Chrome is not supported by SSRS I'm afraid. Well, not 2008. SSRS 2016 does, and was the first to officially, support it, but prior to that you will often get...

GAH!!! Comic Sans!!!! MINE EYES!!!!!!!!!!!!! MINE EYES!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Ok, back to normality. CHAR(10) is the Line Break character. So you'll need to use the REPLACE function.
REPLACE(StringData,';',';' + CHAR(10))

I would also avoid using FORMAT as well. CONVERT and the style code 126 returns the display format you are after.

If, however, you are storing your datetimes as...

Looks like you have a many to many relationship. It's true that an order will contain many items of equipment, and a piece of equipment can be within many orders,...

Hi jagjitsingh,

I don't mean to be rude, but you've been asked and shown enough times to post your questions properly (with DDL, Consumable Sample Data, Expected results, etc)....

MAX(LEFT(c1, 1)) OVER(ORDER BY id ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING)
Let's split this into several sections:
LEFT(c1, 1)
Returns the left most x character(s) from a string. The...

I have to ask, but why are you permitting dates to be stored as I string in the first place? They should be stored as a date or datetime(2). Storing...

Use a CTE and ROW_NUMBER(), ordered by Date Descending. Then only return the rows (from the CTE) where the value of your ROW_NUMBER() column is 1.