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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / SSRS/Fetch based repor...
Microsoft Dynamics CRM (Archived)

SSRS/Fetch based report "export to excel" functionality issue.

(0) ShareShare
ReportReport
Posted on by amritesh 362

Hi All, I am facing once issue in "Export to excel" functionality in ssrs custom report in MS CRM 2015. In report there is one datetime custom field and one createdon OOB field in the report. When i run my report, all fields are displaying in the report viewer. But when I export it into excel file then my custom datetime field has been missing(header too) in excel file. But when I export into PDF format then all fields are present like report viewer(working fine).
Please suggest any idea to resolve this issue.

*This post is locked for comments

I have the same question (0)
  • Inogic Profile Picture
    Inogic 651 on at
    RE: SSRS/Fetch based report "export to excel" functionality issue.

    Hi,

    Can you check if there is any expression added to set visibility of that column? as we can hide/show the columns on basis of render format. For reference find below link,

    http://satishmsbiworld.blogspot.com/2015/04/how-to-hide-column-in-export-data-from.html

    Hope this helps.

     

    Thanks!

  • Trent A. Profile Picture
    Trent A. 30 on at
    RE: SSRS/Fetch based report "export to excel" functionality issue.

    On the Table's column, right-click and check for the column's visibility settings. It's probably set to an expression that prevents it from being exported. 

    pastedimage1597894149901v1.png

    How this happened to me. I took a base report from the report wizard, then started modifying it. For each date field, CRM report wizard creates two columns with visibility expressions, one for viewing/pdf/print and one for excel. If you deleted the one for excel, and modified the one for viewing only, then the column visibility flag is still set not to export. 

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Aric Levin - MVP Profile Picture

Aric Levin - MVP 2 Moderator

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#3
MA-04060624-0 Profile Picture

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans