This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Doesn't seem like any of the other 'truncated' issues are the one that I have... Sooo, I have text in a Database that is being queried using Report Builder. When It queries and displayed in the report it only has ~8000 characters in it. I tried several things to expand the capacity of the text box within the report itself, but it appears that the complete text (~25,000 characters) is not being brought in during the query. When I peek into my database and my UI there data is there (all 25,0000+ characters).
the text box is pretty simple, so I'm just not sure how to overcome the truncation. Below is the what gets pulled from the Dataset:
=Fields!shortstory.Value
What was the query statement when you created the dataset?
This was all done through SSRS Report Builder, so it appears to be this?
<Grouping Name="Note">
<Expression Name="Note">
<AttributeRef>
<!--Note-->
<AttributeID>G635b35c1-006e-4214-933b-a859f63645d7</AttributeID>
</AttributeRef>
</Expression>
</Grouping>
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi Robert-7539,
How are things going?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia
I'm still stuck... Seems that I'm stuck with the limit set by Report Builder. I don't have direct access to the DB, so I can't try to pull the data any other way other than through Microsoft's Report Builder, which appears to be the issue as it will only query x amount of characters.
Then you need to arrange so that you get access, or talk with someone who has. You also need to find the actual query which is submitted. You can use Profiler to determine this. (You = you personally and the DBA or someone else you collaborate with).
Actually, I don't... The issue at hand here is trying to have SSRS (Report Builder) pull all the data that's in that field rather than truncating it. If there isn't a way to do that(and expanding the text box isn't the solution), then we'll simply have to come up with another alternative for a large dialog box (maybe we'll limit it to 4,000 characters x 2 or 4 fields, which would give them the ability to express 16,000 characters). Anyway, I'll try to work on another way to burrow the information through...
Well, you need to verify that Report Builder gets more characters than it displays. If the data is truncated when it reaches Report Builder, there is not much it can do.
Have you set the "Can grow" and the "Allow height to increase" properties? Please read documentation.
A workaround is explained here.
Yes, I tried that... That's just the 'form'. As it turns out, the query is actually only grabbing ~8000 of the characters. I've manually increased the form text block to a gigantic size, but that doesn't help pull the data into/from the query...
Did you try running the query in SSMS to see what happens?
The fact that the cut-off limit is 8000 characters makes it sound to me that this is data-type issue in your query.
No, I tried to use MySQL Workbench, but too naïve to figure out how to pull the data from the https: database with another application versus Report Builder...
MySQL Workbench? So I don't know SSRS, but can it really work with MySQL as a data source? I assumed that you were pulling the data from SQL Server.
I'm actually pulling the data from a database via SSRS. That is what seems to be the issue. I think the query system that SSRS uses limits a query to 8000 characters. So, when it pulls that field, which is ~12000+ characters on most rows, the data is truncated as SSRS dataset query will only pull 8000 characters. :(
"From a database?" Yes, that could be the issue, but if you don't give us more detail about that database, we cannot help you.
Hi Robert-7539,
As it turns out, the query is actually only grabbing ~8000 of the characters.
In addition, what is the data type of the column?
Please check the data type and data of column shortstory in the SSMS.
Best Regards,
Amelia
Yes, I believe that's the issue. I'm going to have the data type changed from ? to ?. What type is it best to be set at?
Hi Robert-7539,
Thanks for your reply.
You can try to change the data type of column from xxx(n) to xxx(max). max indicates that the maximum storage size is 2^31-1 bytes.
Please refer to Data types and Modify Columns which might be helpful.
Best Regards,
Amelia
This only effects the way/amount of data that can be stored in the DB right? I'm stuck with Report Builder truncating the data as the query is pulled.