OraFAQ Forum: Reports & Discoverer » How to Return Values in a Text or Boiler Plate

Home » Developer & Programmer » Reports & Discoverer » How to Return Values in a Text or Boiler Plate (Oracle Reports 6i, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Return Values in a Text or Boiler Plate [message #543483]

Wed, 15 February 2012 00:35

stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...

Senior Member

Hi,

Well i like to display the Values in Boiler Plate/Text.

For Example, i have Report with Address Columns.
for Tin No: i have Hard coded as TIN: 34XXXXXX01 and
i like to change this hard coded item as TIN: 34XXXXXX02
so during Runtime if the input is changed the above item to be changed.

Inputs given in Report Parameter;

if the input is given as 81

TIN: 34XXXXXX01

if the input is given other than 81

it should print as TIN: 34XXXXXX02

How to give it in the Boiler plate.?

Pls Reply ASAP...

Regards,
Stalin

Report message to a moderator

Re: How to Return Values in a Text or Boiler Plate [message #543486 is a reply to message #543483]

Wed, 15 February 2012 00:52

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Something like this might do the job.

select decode(:input, 81, '34XXXXXX01', '34XXXXXX02')
  into retval
  from dual;

Report message to a moderator

Re: How to Return Values in a Text or Boiler Plate [message #543552 is a reply to message #543486]

Wed, 15 February 2012 03:34

stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...

Senior Member

As per your reply i have put the coding as below,
but it returns error.

function B_11FormatTrigger return Boolean is
TIN Varchar2(30);
begin
  select decode(:prd_code, '81', '33656220441', '33261562667')
  into TIN
  from dual;   
  return (TIN);
end;

How to return the Values?

Report message to a moderator

Re: How to Return Values in a Text or Boiler Plate [message #543553 is a reply to message #543552]

Wed, 15 February 2012 03:38

cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester

Senior Member

You wouldn't do that in a format trigger, you'd do that in a formula column.

Format triggers can only return true or false.
I suggest you create two boilerplate items. One with each value. Than add a format trigger to each that checks prd_code and returns true or false as appropriate.

Report message to a moderator

Re: How to Return Values in a Text or Boiler Plate [message #543570 is a reply to message #543553]

Wed, 15 February 2012 06:34

stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...

Senior Member

your Reply is the Exactly the Right one cookiemonster.
I followed the same way before your reply...

thanks a lot...

Regards,
Stanlee...

Report message to a moderator

Re: How to Return Values in a Text or Boiler Plate [message #543576 is a reply to message #543570]

Wed, 15 February 2012 07:08

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Though, one item is easier to maintain. So, another option is to create a formula column and put that piece of code in there and display only one item (based on that formula column).

Yet another option is to avoid items at all and create user parameter (let's call it TIN). Populate its value in After Parameter Form trigger (using the same code you already posted; you'd just precede parameter's value with a colon (so it would be "... into :tin ..."). Then, display its value in paper layout editor as

TIN value is equal to &tin

Report message to a moderator

Re: How to Return Values in a Text or Boiler Plate [message #543632 is a reply to message #543576]

Thu, 16 February 2012 01:06

stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...

Senior Member

yes littlefoot your way for proceedings also we can do,
but cookiemonsters method is little simple and quicker to do with out setting any parameters as you say.

so before his answer i used that option only.

Anyhow thanks for your replies...

Stanlee...

Report message to a moderator

Previous Topic:	arabic numbers in report 11g
Next Topic:	how to add union to report query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 01:40:58 CST 2024