asked
SSRS String Parameter Maximum Length
Hi, I have a simple report, it has one parameter(string type) that I use to temporary save a XML from the database (I need it to display in the report). The thing is that when the XML is over 2000 characters long it does truncate and obviously the interpretation of the XML fails. In fact, in the development preview window the XML doesn't returns like one single row but like three separate rows. Is there anyway **to extend the max characters** entered to be greater than 2000? Please help and thank you very much
This sounds like you are using the wrong solution to the wrong problem! Why do you need to temporarily save some XML in a report parameter? If it is coming from the database, why not just get it from the database when you need it, rather than trying to pass it around as a parameter?
Hi Kev! thanks for your response. Well, I use the parameter to save the XML because is the only way that I found to show the information, this is because the only data in the database is the XML save it in a column XML type. I use like reference the next solution:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c89d9410-f5b4-43ee-a132-9b9f1cc0f6e7/ The problem is when the XML is over 2000 characters long. I really appreciate any suggest!
if there is a limit of 2000, then shred the XML in the query and return 'real' data instead?
I've tested the string parameter length and I have no problem creating a parameter with 65535 characters. If I overlap this length, then error is shown. But his was an internal parameter. If you are using a parameter and then passing the parameter back to some query, then the 2000 characters can be an issue related to the Maximum GET request length which is 2083 characters. So if the parameter is passed in the URL then you can reach the limit of 2083 characters as you have the report path on the beginning and eventually other parameters.
9 People are following this question.
