Home » Developer & Programmer » Reports & Discoverer » Report builder - Text assignment - Urgent Urgent
Report builder - Text assignment - Urgent Urgent [message #242556] Mon, 04 June 2007 01:39 Go to next message
vishaljoyejob
Messages: 4
Registered: June 2007
Location: Mauritius
Junior Member
Hi all,

I have got a report which reads text from an oracle table and displays accordingly. From the text in the oracle table I want to assign a value which is available in the report.

For example, I have got the following text:
"...Note that you have an overdue amount of &f_overdue... "

here the f_overdue is a field in my report. How do I handle this.

Many thanks beforehand mate.
Re: Report builder - Text assignment - Urgent Urgent [message #242598 is a reply to message #242556] Mon, 04 June 2007 05:05 Go to previous message
vishaljoyejob
Messages: 4
Registered: June 2007
Location: Mauritius
Junior Member
In the database table the value of the text is as follows:

field name: content
value: "...Note that you have an overdue amount of &f_overdue... "

Modify the SQL query statement when retrieving the text from the database as followS:

select replace(content, '&f_overdue', :cp_amount)
from table

Note that :cp_amount is a placeholder column holding the required amount.

And the problem is solved.
Previous Topic: Lis File is not getting generated
Next Topic: Printer Displaying "L" in a strange way
Goto Forum:
  


Current Time: Tue Dec 06 04:54:05 CST 2016

Total time taken to generate the page: 0.07926 seconds