Home » Developer & Programmer » Reports & Discoverer » Boilerplate text and hidden fields
Boilerplate text and hidden fields [message #274003] Fri, 12 October 2007 11:49 Go to next message
brendan_j_moran
Messages: 2
Registered: October 2007
Junior Member
I have created boilerplate text that references three fields. The end result is supposed to be a barcode that will be read by a mail inserter. However when I string the three fields together I get a space in them. How do I get rid of the spaces? I have f_field_1, f_field_2 and f_field_3 all of which have their visible property set to no. I then have a boilerplate set like this. &f_field_1&f_field_2&f_field_3. The output is this: *000001 01 01. How do I get rid of the spaces? I have also used the <> as per the help (&<f_field_1>&<f_field_2>&<f_field_3>) but that does not remove the spaces.

[Updated on: Fri, 12 October 2007 13:25]

Report message to a moderator

Re: Boilerplate text and hidden fields [message #274022 is a reply to message #274003] Fri, 12 October 2007 15:13 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Don't use 3 fields. Create a FORMULA COLUMN which would return CHARACTER, and its result will be concatenation of those three fields:
RETURN (:field_1 || :field_2 || :field_3);
Use this formula column as a source in the boilerplate text:
&formula_column


Also, note that you might need to concatenate '*' in front of the returning string and as the terminating character of the same:
RETURN ('*' || :field_1 || :field_2 || :field_3 || '*');
as some barcode readers can not read the code without those characters. Check it in time!

[Updated on: Fri, 12 October 2007 15:13]

Report message to a moderator

Re: Boilerplate text and hidden fields [message #274293 is a reply to message #274022] Mon, 15 October 2007 07:34 Go to previous message
brendan_j_moran
Messages: 2
Registered: October 2007
Junior Member
One detail I left out is that part of the barcode (:field_2 & :field_3) has the source as Page Number & Total Pages. I have not found a way to reference those in the PL/SQL block for a column formula.

[Updated on: Mon, 15 October 2007 07:39]

Report message to a moderator

Previous Topic: Field value showing in report builder but not in OTM
Next Topic: Migration from Oracle Reports 6i to 10g
Goto Forum:
  


Current Time: Thu Dec 08 10:27:58 CST 2016

Total time taken to generate the page: 0.22705 seconds