Suresh B. (6/3/2011)

---

JWIDM76 (6/3/2011)

---

... will I be able to uninstall the expired version and install fresh from the new discs that come with the new book(s) and be up and...

"The following FOR XML features are not supported with WITH XMLNAMESPACES list: EXPLICIT mode, XMLSCHEMA and XMLDATA directives."

Okay, this is the message I was getting in the first place, which...

I'm using 2005. I need to specify namespace AND use CDATA. I was wondering if there was a method for achieving both.

Thank you.

I believe I need to use FOR XML EXPLICIT because of my need for the CDATA directive, and I also want to be able to have a collection based on...

Thank you Steve. Those are good tips. I'm doing my sort and grouping within the query now and all is well. I appreciate you're assistance.

Jennifer

It's hard to say what is wrong exactly without seeing your layout and where exactly "textbox12" is located. I personally utilized the formula to replace the normal behavior of...

That is a great article on simple-talk, I actually already used it.

Attached is what I get when I sort the category group by Sum(Fields!Amount.Value). I want it to be...

Maybe this will help shed some light for you. I'm doing something similar in one of my reports based on what I learned from this article:

http://72.32.35.89/sql/sql-server-2005/advanced-matrix-reporting-techniques/

Thank you!