I'm not fluent in the SSRS VBA syntax, but that replace looks strange. I think you need only the "inner" parameters, i.e.

=Replace(Fields!Justification_Text.Value," ","")

But since the error message mentions the VT...

• This reply was modified 4 years, 4 months ago by kaj. Reason: Changed 0X0B into 0x0B

I'm sorry about the misinformation. I didn't pay attention to the list of "Applies to" services.

I remembered some excited chatter some months ago about the functions now being available, but...

Without knowing your data, it might be as simple as that the VT control character is used in your column to indicate a line break, instead of the more "normal"...

In SQL Server 2019 you can also utilize the GREATEST function.

https://docs.microsoft.com/en-us/sql/t-sql/functions/logical-functions-greatest-transact-sql?view=sql-server-ver15

I now realize that my original response didn't fully appreciate that the originally case based select can't just be converted to a "normal" where clause where the criterias of the...

Well, I'm not so shocked about the lack of stored procedures as you seem to be.

The use of stored procedures for any kind of web/object oriented programming has long been...

You might get better answers if you made it more clear what your circumstances are and what you want to achieve. After all you posted your question in a forum...

Not really sure, you seem to have used the logic from IPS.InOrOut = 'O'?

I would probably start by converting the original CASE-based logic to something more standard, like

            
September 28, 2021 at 4:33 pm
            
#3934217

            
            
                                                
        

Well, I don't see a WHEN NOT MATCHED section, so how can you expect it to insert new rows?

https://docs.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver15

Try googling "tsql running total" and you will see a number of tutorials about how to do that.

Okay, I was wrong. It does seem to support proxy setup:

https://docs.microsoft.com/en-us/previous-versions/windows/desktop/ms760236(v=vs.85)

https://docs.microsoft.com/en-us/previous-versions/windows/desktop/ms763680(v=vs.85)

So you might want to fool around with those parameters, if you need to utilize a proxy in...

Is the SQL server you're using allowed a direct outbound connection to the internet?

If you're using a proxy, then this must be set up in the internet settings on the...

Hmmmm.... May I offer you a couple of alternatives that I find a tiny bit more elegant?

-- Set up test data...
DECLARE @CallLogCommonCount TABLE (
   ...

You haven't really provided actionable data about what your data looks like and what you want to achieve, but here's a wild west shot from the hip:

declare
...

• This reply was modified 4 years, 5 months ago by kaj. Reason: Little typo

Maybe something like this?

with 
    tcount as (
    select codetypeid,code, count(*) as trows
    from #test
   ...