Hi Guys,
We have some accounts staff that need to manually add a list of jobs from our Ship tracking system on a job by job basis.
This is simply to keep a list of cash in hand transfers from the company to the ship.
We have three versions of this report, one GBP, one EUR and one USD.
The way it was created, was for column headings where users enter the list of job information, and then a few additional columns querying the datasource for company name and similar information.
On two versions of the report, when saved in report mode, a viewer can add additional job lines to the report, refresh, and the company information will be pulled through automatically. However, on one version, instead of pulling the data, it clears whatever the user has entered. I know this is not good design per se, but it works for them. I have checked to see if the was Auto+Hide+Lock on the sheet, but there was not.
I am just wondering what could cause this behavioural difference between the report versions.
I can upload an example if needs be.
Cheers
Eds
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Eds,
It's not just whether Auto+Hide+Lock is on that specific worksheet. If +Lock or +Values is in cell A1 on any sheet in the report, then you would get this behavior. Did you check all the other sheets?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
The user now informs me that the report that was working was never actually refreshed. I think this one had auto calculate formulas turned on in the Excel options, so when they entered data, Jet automatically retrieved additional data from the datasource.
The one I was testing, was being used by a different user, who probably did not have auto calculate on, meaning they kept pressing refresh. I guess that Jet is designed to remove anything that is entered when in report mode.
The solution for this seems to be to turn on auto calculate, and just remember to never refresh the report :D
When the report increases in size, they will simply copy down the Jet formulas, (a simple NL("First",table,field,some-id,id-value)), so that it looks at the data they are inputting.
Cheers
Eds
Please sign in to leave a comment.