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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / FRx Exporting to Excel...
Microsoft Dynamics SL (Archived)

FRx Exporting to Excel - Blank Columns

(0) ShareShare
ReportReport
Posted on by BHouse 315

I wrote an FRx report that has conditional columns.  This means that say for period 10 there are no actual amounts so instead I print the budget amount.  I hide the actual column with a command NP (no print).  The report is beautiful in the FRx drilldown viewer.  When they export to excel they are getting extra blank columns in between the ones that have amounts in them.  It seems that the NP columns are taking up a column on the excel report even though there is no data in the column.  Is this working as designed or is there a way to eliminate these extra blank columns?

*This post is locked for comments

I have the same question (0)
  • MikeC Profile Picture
    MikeC 20 on at

    Yea that's just Excel doing its job.  If you choose "Export to Formatted Excel", it will automatically hide the blank columns for you but it won't NOT include them.  There's not much control over Excel exports.

  • Sheila 500 Profile Picture
    Sheila 500 10 on at

    I am having a similar problem.  When I suppress columns that have all zeros using the "XO" setting, and set the output to a formatted Excel worksheet, not only are the zero'ed columns suppressed, but also some (but not all) columns that have values in them are also suppressed/hidden.  If I send the exact same report to a drill down document, the column formatting is fine.  Anyone have a solution?

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans