Don't use an expression to change the format of a field on SSRS, change the the format property of the cell. Using FORMAT converts the field to a string.

Andrew doesn't have an entry in your sample data, is that intended? This exact code won't work if so (you should be able to amend it easily enough), but using...

I'm not sure what the relevance of the above is. If you want the number "3" to be displayed as "0003" you would use the format "0000", not "####". The...

Do you mean you want to Display "Presentation Layer Loaded", "SuccessfullyLoaded" and "Total Scrape" first, and then the rest? What is your defining order for these, is it "Presentation Layer...

Can you provide some Sample data and expected output please? See the link in my signature for details on how to supply this.

Otherwise, I did quick

What do you mean by "not showing up"? If a cell has a value in the formula bar, but not in the cell, it's because the value of the formula...

Using Substring:
USE DevTestDB;
GO

CREATE TABLE #Source (String varchar(255));
GO

INSERT INTO #Source
VALUES
('model://MONEY/GBPCHF.3Y.BG0L.125'),
('model://INDEX/IMAREX.PANAMAX'),
('model://INDEX_New/JIBAR.Z2AR.12M1/LAST'),
('model://FXG_LBMA/EU.ME.LBMA.A3G_USD.FXG/PRICE');
GO

SELECT *
FROM #Source;

Perhaps I am missing something, but the position of both CMDTY and SRV_Name are in the same position in your example, so the following will always work:
SELECT...

Personally, I think it really varies on the data. There are some things where I will use NULL, where other times I will use a "Magic Number", or something else....

Could you provide Sample data, along with the expected output please. We have no idea what the problem is from your above post, as we don't have access to your...

I also would advise against using GOTO statements, you would be better off using TRY...CATCH syntax.

Normally the ACE drivers are installed when you install Excel, do you have that installed on the machine you are using? If you have an older version of Excel installed,...

I assume that the path you have selected for your Excel Connection Manager is valid? Also, do you have the JET/ACE drivers installed?

Personally, if this is the case, I would embed the SSRS report and CCTV page into another web page. Then you can display both pages.

I also don't know...