Problem with SSRS Preview

Akshay Patil 6 Reputation points
2021-04-09T10:44:17.607+00:00

Hi, While working on Visual Studio I am getting a bug and I tried but couldn't fix it. Whenever I create a report (not using wizard) and I add a table in report and add columns in it and when I preview it even if there are no empty fields the table is showing empty. However if i click on print preview then only i am able to see the row information and also if I shrink the column size in the design window to really small then i can see the rows in design window

These are the Screenshots
DESIGN:
86285-screenshot-2.png
PREVIEW:
86245-screenshot-3.png
PRINT PREVIEW(I can see the data)
86234-screenshot-4.png
Design with compressed columns
86292-screenshot-5.png
PREVIEW with Compressed column size
86293-screenshot-6.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,631 Reputation points
    2021-04-12T01:55:41.763+00:00

    Hi @Akshay Patil ,
    Are you using vs2019? Could you share the version number? Since the last time the problem of not being able to create a new report in vs2019 was fixed, the situation similar to yours has appeared one after another (data is not displayed in the preview). A similar case is as follows:
    https://learn.microsoft.com/en-us/answers/questions/345982/ssrs-reporting-1.html?childToView=347416#answer-347416

    You could try to create reports using Report Wizard and its working perfectly fine.
    In addition, I suggest you submit the requirement at https://feedback.azure.com/forums/908035-sql-server.
    If the requirement mentioned by customers for many times, the product team may consider to add this feature in the next SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided.

    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.