How to display non database values in report??? [message #357993] |
Fri, 07 November 2008 10:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ranjith_amrita
Messages: 44 Registered: August 2008 Location: Coimbatore
|
Member |
|
|
Hi,
I want to generate report based on the user entered values. I dont want any values from the database.
Eg. I am calculating Simple Interest. I = P * N * R.
P, N and R are user input values. How to send the I value to Report and show it???
I used only queries to generate reports.
Thanks, Ranjith
[Updated on: Fri, 07 November 2008 10:34] Report message to a moderator
|
|
|
Re: How to display non database values in report??? [message #358020 is a reply to message #357993] |
Fri, 07 November 2008 14:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Create 4 user parameters: P, N, R and I; all of them should be of a NUMBER datatype.
Don't touch P, N and R. Open I's Property Inspector and write its Validation Trigger as:I := :P * :N * :R;
return (true);
Go to Paper Layout Editor and draw 4 fields - one per user parameter; run the report.
Parameter form will display all 4 parameters (so perhaps you'd want to remove "I" in the Parameter Form Editor.
That's all.
|
|
|