| Report builder - Text assignment - Urgent Urgent [message #242556] |
Mon, 04 June 2007 01:39  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
