Welcome to SSC. When posting data questions, it best to provide DDL and consumable sample data for other users. We don't have access to your server, or data, thus you...

What is your question here? You've made some statements about what your goals, but not asked a question.

As per the documentation on TRY...CATCH (Transact-SQL), however,...

Those links are to your local server, they aren't going to be accessible by us; we're not on your network.

This would be easier with some consumable sample data...

Could you please provide your data in a consumable format please? Have a look at the link in my signature on details on how to achieve this. You're much more...

Duplicate of a topic you made 2 days ago, and received an answer to. Rather than posting a new topic, if you have further questions, you're better off replying on...

For example:
[Code]SELECT 1;
SELECT 2;
GO[/query]
That's two statements, run in the same session, with 2 result sets.

It won't contain any information, as there is no data in the database. Think of it like an empty box, it still takes up space with or without stuff in...

It sounds like what your trying to describe is a feature called Dynamic Data Masking (DDM), which you can read about here: https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking. DDM, however, was introduced with SQL...

Add Opening Balance too. You can have more than two fields in an expression.. Opening Balance + Credit - Debit = Closing Balance

Not sure what you mean by "Row Wise balance". Is this simply Credit Amount - Debit Amount? That would be:
=Fields!CrAmount.Value - Fields!DbAmount.Value