Resolved the issue. Logically what I was doing was correct from an IIF and SWITCH perspective but it did not like having the other function (custom code) mixed with...

I know this post is old but I was wondering if anyone experienced the same thing I have. First off I think this CLR is very cool. I use it...

WOW! I have still had issues with this even though this post is over a year old and from what I tested your settings WORKED. How did you think you...

This still pushes me to a second page.

Thanks. I will give that a shot and let you know!

Thanks for the reply,

My body and report size are both 8.5X11 and my margins are set to all 0s.

To answer you second question, I get different results depending on what...

Thanks for the reference!

thanks....I see the light now 🙂

and can someone tell me how to paste the code so it looks EXACTLY like I have it in T-SQL? IT always looks terrible right after I post it.

OK....Here is how I got it working if anyone is interested. Thanks for all the help and input!

select replace('<?xml version="1.0" encoding="UTF-8" ?>' + (

select 'Jason' as '@publisher_label',

replace(replace(replace(convert(varchar,getdate(),120),' ',''),'-',''),':','') as...

Closer:

This works except for the --'http://JCSQL.com/api' as '@xmlns',

it gives me an error:

'xmlns' is invalid in XML tag name in FOR XML PATH, or when WITH XMLNAMESPACES is used with...

Sorry, this is ACTUAL data that I am working with and I should have definitely not used it here.

I think I have just been chasing my tail. I was expecting something different but like you said that is the way (correct) the XML is stored.

THanks for you help.

even with the TYPE option specified, I am still getting the special character returned for &

sorry did not see your reply on page 2...let me take a look.