Home » Developer & Programmer » Reports & Discoverer » How to display non database values in report??? (Oracle Developer Suite 10g, Windows XP)
How to display non database values in report??? [message #357993] Fri, 07 November 2008 10:32 Go to next message
Messages: 44
Registered: August 2008
Location: Coimbatore

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
Messages: 20850
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.
Previous Topic: create user parameter
Next Topic: multiple pdfs from a single 6i report
Goto Forum:

Current Time: Sun Oct 23 15:31:21 CDT 2016

Total time taken to generate the page: 0.04519 seconds