Hi,I've created a report which has columns but whenever the reported is exported as Excel then certain columns are added in excel.Kindly suggestion something thanks.
*This post is locked for comments
Hi,
I am assuming that you're talking about a RDLC layout.
If so, you must check the alignment of all controls: if your Header and Lines don't align, Excel might add an empty column in an intent to align them.
Check out this post:
blogs.msdn.microsoft.com/.../rdlc-export-to-excel-some-hints
There could be multiple reasons for this.
- There may be possible that the column that appear on the RDLC report are hidden based on the base of some value in the column but when you export it as excel it will appear.
- The columns on the RDLC layout have 0 width and that is why they apprear in the excel but not on the RDLC layout(preview) of the report in NAV.
Let me know if you have any query. Thanks
Thanks a lot.... It helped
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Saurav.Dhyani 2 Super User 2025 Season 2
RK-25090803-0 1
