SSRS Reporting

Question

Hey,
I am using SSRS Reporting and Facing an weird issue, hope you guys help me out.

For Creating Report I am Using Visual studio 2019. My Report is simple just used grouping in it with totals and subtotals.
The Issue is When i Review the Report in tool by Clicking the preview button.

Some of the Columns not showing data on some rows. its shows empty space. but the weird thing is when i Export to the PDF, Excel etc it Showing Complete data.
Please let me know why is this happening and how can i resolve this problem.

If you see the image above the status and TRX number not showing data on Some columns. But When i Export it will Show the complete data Please help me out
Thanks and Regards

Answer 1

hey @Zoya ZY1 Wen
thanks for your reply. Yeah the issue was weird and it occurring on other reports as well sometimes some headers got disappear.
But thankfully the issue resolved.
I just made a report with using Report Wizard and its working perfectly fine.
the issue Occurs if i create and empty report and add table my self.
Regards.

Answer 2

Hi @Sammar Abbas Nasir ,

It's a little hard to narrow the issue.

I tested in my Visual Studio2019 and I couldn't re-produce the issue.

May I know if the issue only occurs in this report or other reports also have the same issue?

Could you please help check run the report in Report Builder to see if the preview model will lose data or not?

You may also try to remove cached report data in Visual Studio for a try.

How-to-remove-cached-report-data-in-Visual-Studio

Regards，

Zoe

---

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.
Hot issues October

Answer 3

Alright @ZoeHui-MSFT thanks