Field Name Changes by itself:
I found very annoying thing happened today. I created a report with option sheet.
Some of the columns are using data from "Stockkeeping Unit" table. I use NL("rows", and several nf() functions.
I keyed in the column headers (I did not use the drag and drop from the browser), and I named the header for "item no." with "No.".
I saved the file and ran it. I saved it again as a report, and sent it to the users. When they run the report, the result shows that the header changes to "Item No." which is the default field name of that field.
I tried it myself, opened it on design mode, changed the header, saved it. When I ran it, sometimes the header changed but not all the time.
When I remove the option sheet, it works fine.
Anybody has experienced the same problem?
I
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi,
I've never seen anything like that at all. Care to upload the report and tell me exactly which cell it is so I can look at it?
Regards,
Hughes -
Jet Reports Historic Posts Hi,
I recreated the file and it works fine for now, but i got another problem.
On the report, I have on cell B1: hide+? and on column B35 there is an excel formula to show "hide" or "show".
2 users ran the report with different set of filters on two different computers and both have the following problem.
One report has 52 rows with "show" on column B, only 45 are really visible, and 5 are hidden even when the text on column B are "show".
The other one has 25 rows with "show", but only 21 are really visible.
I have 2 version, one that creates 20 to 30 daily worksheets overnight, and this one that users have to run it manually.
I don't have any problem with the overnight report which does not have "option" sheet.
This is a temporary report for only 16 weeks and it's quite messy. You will also see 2 columns are using array formula which give me proper results on the overnight one, but the one with "option" sheet gives us a little headache (F2 -> ctrl+shift+enter). I saw Hughes' suggestion on another post that suggested not to use array formula with Jet Reports.
Thank you
Please sign in to leave a comment.