Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Tuesday, February 25, 2020 9:22 PM
Using Visual Studio Community 2019 with SSRS Add-In (Microsoft SQL Server Reporting Services Designers Version 15.0.1659.0) on Windows 10; SSRS 2019. In trying my first report where I added a title using a texbox, I could not see the title in Preview. I also tried a Table which had the same issue (column header values and data values don't show). Doing some testing, text values do not show in Preview mode in Report Builder from SSRS 2019 nor from SSDT 2017. However, text values do show on the report Portal and when exporting report (PDF, Excel, Word).
I also tried installing everything again but did not fix the problem. I also tried installing everything on a different computer and still the same problem came up.
In going online for help, I found a person who fixed it by repeatedly deleting and adding a text, closing application during each try. This worked sometimes. I also found a person who fixed it by setting the CanGrow field of the Texbox to FALSE which I tried and it worked. In short, people have reported this problem but could not find a good solution. It seems this problem has existed for years.
Does anyone (Microsoft?) know how to fix this problem?
Thanks!
I can't put links yet (new member) but you can find similar posts by searching for:
ssrs-not-showing-any-text-in-preview
text box in ssrs not showing data unless i untick the allow height to increase!
How to fix problem with text not showing in Preview mode for SSRS 2019 using Microsoft Visual Studio Community 2019?
All replies (3)
Wednesday, February 26, 2020 6:38 AM
Hi Master Houyi,
Welcome to MSDN forum.
Please have a try to install Microsoft Reporting Services Projects extesnsion into your visual studio 2019.
If it isn't solved, you could report it in Q&A, then product team experts will response to you as soon as possible.
Hope it could help you.
Best Regards,
Dylan
MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [email protected]
Wednesday, February 26, 2020 3:21 PM
Hello. Yes I have. I called it "SSRS Add-In" but it is the extension. When using the extension to develop a report and when trying to Preview the report, is when the problem of not seeing the text values appears. Please refer back to my original post for details of problem. Thanks. Master Houyi
Thursday, February 27, 2020 8:26 AM
Hi Master Houyi,
Thank you for reply
I try to add a textbox on rdl file, and keep switching to preview mode, the text could always display, please see this:
Besides, I find the rdl file will be auto built when we switch to preview mode. Please check this on your side. If the rdl cannot be auto built, please have a try to repair your visual stuido.
Best Regards,
Dylan
MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [email protected]