When I run my reports, all of the amounts are converted to Values. That wouldn't be a problem, except I've built most of my reports to reference specific cells for segments of our general ledger account and some of those segments have leading zeros. IE, we have a fund "001", Cost Center "000", Program "0001", etc. Every time I want to refresh or go back into Design mode, I have to redo 90% of my referenced cells.
Cell A1 has "Auto+Hide" in it, not "Auto+Hide+Value".
My hunch is that some box somewhere got checked when it shouldn't have. Any help would be greatly appreciated.
James Wilkins
Controller, Jewish Community Centers of Chicago
Date
Votes
6 comments
-
Jet Reports Historic Posts Hello James -
What version of the Jet Excel add-in are you using?
A feature was added a few years back to support leading zeros when filtering functions (since Excel does not support leading zeros for numbers).
For example, I have a database with the following table:
I build my report as follows (using a tick mark to let Excel know that I have leading zeros):
And get this result:
How does this differ from what you have? -
Jet Reports Historic Posts Thanks for the quick response. We are Jet Essential 2015 Update 1 15.1.15166.0 (64-bit).
I get the same results, *except* that when I go back into Design Mode, all of the numbers under Dept change to a single digit.
I couldn't insert pictures or anything, so I've attached an excel spreadsheet that walks through the example but uses 2 tables - one with the amount and one with the name. -
Jet Reports Historic Posts Hello James -
Could you provide a simple report that contains the issue? That way, I could see your actual functions.
Thanks, -
Jet Reports Historic Posts Did you try to modify the type of the cell as text instead of standard or number ?
-
Jet Reports Historic Posts I have not tried just changing the format of the cell. I'll do that.
Attached are 2 spreadsheets - same report, just one in Design Mode and one in Report Mode. -
Jet Reports Historic Posts Thank you.
Typically, when a Jet report is run, Excel functionality is used to create temporary (hidden) backup copies of each worksheet. When the report is returned to Design mode, these backup copies are used to restore the contents of the sheets back to how they looked before the report was run. Excel functionality is then used to delete those copies.
The the case of your workbook, something had interfered with the deletion process. This interference caused multiple copies to be created and also forced the wrong backup to be used to restore your functions (this is what removed the tick mark from '001 and caused Excel to change that value to just 1).
I have removed all the excess backup copies and restored the '001 to the cells where it appears it should be (you'll want to check that, obviously).
Are you now able to run the report *and* return it to Design mode?
Please sign in to leave a comment.