Electronic reporting: how to control visibility/display of format element?

(0) Share

Report

Posted on by Lexicon_

141

I'd like my project invoice to not print types (hours, items, expenses, etc) that have no transactions. Currently it's just printing everything and having amounts 0.00 in place. I've used a bunch of different functions and data sources in the Enabled field but my invoice export is completely refusing to pick it up and work according to it.

I've done testing as well to see what values the count function prints for various data sources, and then constructing my functions accordingly to ensure the block doesn't print in my invoice, but I think at this point in my experimenting it's not about what data sources I'm using, it's just that the report is NOT looking at that Enabled field at all.

Is there something I'm missing please?

All responses (1)

Answers (1)

Verified answer

Lexicon_ 141 on at

Like (0)

Report
Copy link

Link copied!

I figured it out!

The named ranges in my attached document (Excel in my case) MUST be entire rows e.g. $1:$5 and not a block like $A1:$C5.

Because I named my hours/items/expenses ranges by the block ($B4: $H10), the cells on the sides of that block in Column A and Columns I onwards to the left are still being "printed" and thus cannot be hidden.

ER formatting works row by row and doesn't fully support named ranges that are side by side.