Finance | Project Operations, Human Resources, ...

Export report to excel alignment issue

(0) Share

Report

Posted on by premK6969

198

Hi there, we got an requirement to resolve alignment issues for Ledger Transaction List Account. The problem is when we are exporting the report to excel, we have some empty columns and those should not be there in Excel while export the report to excel. Please guide where exactly i need to focus to resolve empty columns issue in exporting reports to excel in D365 FO. Thanks in advance

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you specify what alignment problems you have and what lines should not be there in Excel?

Some screenprints would help here.

As an alternative, have you tried using other forms/reports to export the data to excel, such as the trial balance list page in GL or a financial report that can be designed in line with your requirements?

Best regards,

Ludwig

Was this reply helpful? Yes No
premK6969 198 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig, we want to export Ledger transaction list report from screen to excel. After importing we had noticed empty columns in the report and after analyzing we identified that the blanc columns are coming because of headers alignment with Lines and because of this we are facing blank columns issue. How can we make headers not effecting the export to excel or can able to show headers in screen and hide while exporting to excel so that we can have only line table. Please find below screenshots for reference.

Was this reply helpful? Yes No
Suggested answer

Fangyuan Hou on at

Like (0)

Report
Copy link

Link copied!

Hi,

There are some limitation when export to excel for the SSRS report. Please help to have a check the below docs.

docs.microsoft.com/.../exporting-to-microsoft-excel-report-builder-and-ssrs

Please feel free raise a support ticket to us if you can always repro without customization, we will escalate to the report designer to have a further check.

Was this reply helpful? Yes No