web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / SSRS Report Export to ...
Microsoft Dynamics AX (Archived)

SSRS Report Export to Excel

(0) ShareShare
ReportReport
Posted on by Karthik Desappan 5,682

I have done a SSRS report in AX 2009.When I export Report data to excel the cells are merging that's why i can't sum the amount in correct cell.

If u have any idea about that this issues let me know very soon because this report is very urgent in client side.

see below is an example of ssrs report export to excel.

plz find attached file for issues like that......

 

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 239,035 Most Valuable Professional on at

    Sorry, I didn't get the problem. What exactly gets merged and how does it prevent you from summing up amounts?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Karthik,

    This issue of cells getting merged is use to be due to the design issue.

    if size of cells are not properly defined and in report some how text box overlap between column, hence this issue use to be there.

    Please try to look into your report layout design.

    Please verify

  • Community Member Profile Picture
    Community Member on at

    Hi karthik,

    please download the existing report rdl file that matches with your report design. you can open that rdl file & design your custom report according to the source rdl file.

    after development please do export the report to excel or any other format without any cell merging  

  • Karthik Desappan Profile Picture
    Karthik Desappan 5,682 on at

    Hi Nataraj,

    how to Download the RDL file.Plz Explain Me....

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi Karthik,

    if you have deployed reports in report server, then go the server and open the corresponding report( the report similar to your development report) then please find the attached snap to download the rdl file.

    the downloaded rdl file is only for your reference. you can learn more concepts form the existing one.

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans