CODEWITHSUNDEEP
visual-studioreporting-servicesreportbuilder
master houyi
master houyi

Reputation: 11

How to fix problem with text not showing in Preview mode for SSRS 2019 using Microsoft Visual Studio Community 2019?

I just got the latest versions today for working with SSRS: SSRS 2019, Visual Studio Community 2019 (Version 4.8.03752) with SSRS Templates (Microsoft SQL Server Reporting Services Designers Version 15.0.1659.0).

I have a textbox with the report title which doesn't show in preview (both in header or body) and a textbox in footer with page counts that doesn't show. In the body I have a Table with a few columns that don't show values but do show the table cells. I noticed that values did show for returned records on first try but not for column headers; however, when I resized one cell, no values were shown at all for anything. Now, no text values show at all in Preview mode.

When I export report to PDF, everything shows (title, body, footer). This also works when I published to the Portal.

Here is what I tried without success:

  1. Changed the font color to all texts to red but text values still don't show.
  2. Deleted the report data files (.data) but text values still don't show.
  3. Open the report file (.rdl) with Report Builder but text values still don't show.

So, it is in the editors (VS and Report Builder) that the problem only exists as rendering (PDF, Word) works and running in Report Portal works.

Thanks.

Upvotes: 1

Views: 8775

Answers (2)

Jaber
Jaber

Reputation: 11

My issue was resolved by unticking the "Allow height to increase" check box for the text box.

enter image description here

Upvotes: 1

aardvark
aardvark

Reputation: 338

I faced this same issue using the standalone Report Builder application, and I resolved it by placing the textbox inside a rectangle. From then on, it rendered in preview mode as expected. However, I'm not sure how that would affect auto-growth.

Upvotes: 0

Related Questions