| How to display non database values in report??? [message #357993] |
Fri, 07 November 2008 10:32  |
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  |
 |
Littlefoot
Messages: 21811
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
