Hi, I am new to Jet Reports and have the following question: sometimes, the cell in which the formula is in, turns "blank", that is, usually you can read the function in the cell, but in some cases it does not show anymore. It is stll there and the report works, only the formula is just not visible. Any ideas? Thanks a lot.
Date
Votes
8 comments
-
Jet Reports Historic Posts Check cell A1 in design mode if you have the following value: Auto+Hide+Values
-
Jet Reports Historic Posts Hi Jackies, thanks for your reply. auto + hide + values in A1 is there. The function though is in C14.
-
Jet Reports Historic Posts When you are using +Values in cell A1 and you enter report mode by clicking the Report or Refresh button in the Jet ribbon, all Jet formulas will be removed (or hidden). This is by design and is part of Jet Reports.
In Jet, there are 2 modes: design mode and report mode. In design mode, all Jet functions are visible and return optimized values that are not guaranteed to be correct. The values are optimized so that they are returned faster to make editing the report easier. In report mode, Jet functions are not visible if you are using +Lock or +Values in cell A1 and the values are not optimized and are guaranteed to be correct (or at least to be the correct value for whatever query you're doing, not necessarily a guarantee that your function itself is correct). You toggle between design and report mode by clicking the Design, Report, and Refresh buttons in the Jet ribbon or menu.
In order to distribute reports to people who do not have Jet installed or who are licensed as Report Viewers (who are not allowed to edit Jet functions) you must put +Values or +Lock in cell A1 and save the workbook in report mode so no Jet functions are visible. Another benefit of saving a workbook in report mode is it can be opened much more quickly because there are no Jet functions to be recalculated. Does this information help?
Regards,
Hughes -
Jet Reports Historic Posts Dear Hughes, many thanks for your detailed answer.
I realized that I might not have described my problem clearly. I am well aware of the 2 modes, design anf report, and that in report mode the functions are hidden. My problem is, that the function does not show in design mode. When you click on the cell with the function, the function is shown in the fx-line but the cell itself is blank. it is not a matter of writing- or filling-color. When I run the report and change back to design mode, the fuctions is visible. When I close/save the workbook and re-open it, the functionis is invisible again. This is most irritating while working in design mode.
Kind regards
Caritas -
Jet Reports Historic Posts Hi Caritas,
I have never heard of this before. Can you create an example workbook where it exhibits this behavior and upload it?
Regards,
Hughes -
Jet Reports Historic Posts Hi,
A formula is usually evaluated once you write it.
Lets take a formula (I'll use example from one of my reports) to list all packaging items used in the warehouse in November.
You will notice it will dissapear.
=NL("rows","consignment","Actual Packaging","Document No.",NL("Filter","Posted Whse. Shipment Header","Original Order","Posting Date",NP("DateFilter","01/11/2014","30/11/2014")))
This is because the first entry it would return is BLANK
But after you will put a filter to ignore blank entries, your formula will show up properly.
Took me a bit to figure this one out to be honest.
Annoying little thing, innit? :) -
Jet Reports Historic Posts all packaging items used in the warehouse in November.
___________________________________________________________________________________________________________________________________________________www.marcelavivar.fr -
Jet Reports Historic Posts Hi, I am new to Jet Reports and have the following question: sometimes, the cell in which the formula is in, turns "blank", that is, usually you can read the function in the cell, but in some cases it does not show anymore. It is stll there and the report works, only the formula is just not visible. Any ideas? Thanks a lot.
CNothen, as RSP concluded, the first result in your NL("rows") function is blank.
I have two solutions.
1) when I'm developing, If i keep 'losing track' of the NL("Rows") function you can highlight it Yellow so that you always know where the function is.
OR
2) add a filter saying Field "<>@@"
To recycle RSP's example:
=NL("rows","consignment","Actual Packaging","Document No.", "Document No.", "<>@@",NL("Filter","Posted Whse. Shipment Header","Original Order","Posting Date",NP("DateFilter","01/11/2014","30/11/2014")))
"Document No.", "<>@@" reads as "Document No. does not equal blank.
But be careful with this criteria. It will imply that Document No. has always been filled in, when clearly, there are cases where Document No was left blank.
Please sign in to leave a comment.