0

Prevent leading zero from disappearing.

Jet Reports Historic Posts

June 16, 2009 09:27

None

Follow

In the following report I specify Job 0660 and on first run it's ok.
But when running it an second time you can see that Jet changed the filter to 660 even though the cell type is Text.
How can I keep the leading zeros. Sofar the only solution has been the filter: 0660|0660 but that is just plain weird.
Cannot expect customer to enter Job each time when report is run.
BTW: not all jobs have a 4 position No. so something like RIGHT("0000" & MyVALUE, 4) will not work.

• Temp.xlsx

• Facebook
• Twitter
• LinkedIn

7 comments

• 
  Jet Reports Historic Posts June 17, 2009 10:28 Official comment

  Ok,
  
  What happens if you put @@0660 in inputcell (Optionjob), but retrieve your information from =SUBSTITUTE(OptionJob;"@@";"")?
  Does that save in performance?
  
  Greetings
  Hans Dutting

• 0
  
  Jet Reports Historic Posts June 16, 2009 11:38

  Hi Sebastiaan,
  
  Have seen this issue once or twice before. How about formatting the cell as a text?
  And otherwise using =T(CellReference) did the trick for me.
  
  Hope this helps. Please let us know.

• 0
  
  Jet Reports Historic Posts June 16, 2009 12:41

  Setting the format of the inputcell to text gives the same problem when you want to report or design, in your pop-up-optionmenu it also converts 0660 back to 660.
  Also Excel converts 0660 when getting back in designmode to 660.
  With the T function its the same. The problem is Excel.
  Maybe a bold solution but put "@@" in front of a single filter @@0660. (in the customer inputcell)
  
  I also have customers who use zero's in front of Codes. Its horrible!
  Greetings
  Hans Dutting

• 0
  
  Jet Reports Historic Posts June 17, 2009 08:04

  Nice idea the @@ instead of 00|00 but this also is an performance hit.
  I have run my report for different projects with both filters but with the @@ in general runs about 30% longer.

• 0
  
  Jet Reports Historic Posts July 29, 2009 15:05

  Sorry, this is an old issue, but did anyone try these 2 methods ??
  
  
  
  In that case use NP(“format”,c11,”00”) and that will return “01” etc.
  
  =TEXT(A1,"0000"), this will bring back a 4 digit number all the time.
  
  Just throwing a few things out there.

• 0
  
  Jet Reports Historic Posts July 30, 2009 11:27

  If the number always was 4 characters this would be possible but in this case our customer also users 6 characters numbers together with 4 character numbers….
  
  But thanks for the input…

• 0
  
  Jet Reports Historic Posts September 30, 2009 06:18

  Thanks guys for the tip :)