question

AkshayPatil-8330 avatar image
0 Votes"
AkshayPatil-8330 asked AkshayPatil-8330 commented

Problem with SSRS Preview

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
screenshot-2.png (160.1 KiB)
screenshot-3.png (164.3 KiB)
screenshot-4.png (167.1 KiB)
screenshot-5.png (160.0 KiB)
screenshot-6.png (169.5 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AkshayPatil-8330 ,
Has your issue been resolved?
If you have any questions, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Regards,
Joy

0 Votes 0 ·

I did not want to use report wizard. However just changing the font solved the issue for me. Thank you!

0 Votes 0 ·

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @AkshayPatil-8330 ,
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://docs.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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.