FRx Exporting to Excel - Blank Columns

(0) Share

Report

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

All responses (2)

Answers (0)

Sheila 500 10 on at

Like (0)

Report

Re: FRx Exporting to Excel - Blank Columns

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?
MikeC 20 on at

Like (0)

Report

Re: FRx Exporting to Excel - Blank Columns

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.