passing parameters... [message #259174] |
Tue, 14 August 2007 10:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
brintha
Messages: 28 Registered: August 2007
|
Junior Member |
|
|
Hai all,
Is it possible to pass parameter to a formula column or restrict the records based on the value that is returned in a formula column?
I need to generate a report based on the parameter sent and the parameter that is passed is not retrieved in the base query. It is displayed using formula column in order to avoid replication of same records except for one column in the record.
pls help me out if there is any possibility or of u have any other idea regarding this. It is urgent.
regards,
brintha.r
|
|
|
Re: passing parameters... [message #259229 is a reply to message #259174] |
Tue, 14 August 2007 15:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Yes, it is possible to create a user parameter and use its value in a formula column. For example, if user parameter's name is P_100 and formula column is CF_100, you may reference the parameter asfunction CF_100Formula return Number is
begin
return (:p_100 + 1);
end; Display it in the Paper Layout as any other column (its source should be the CF_100 formula column).
This was easy. Now, I must admit I don't understand the reason you tried to explain. Avoiding replication of some records? What does it mean? Why don't you use DISTINCT, for example?
Or, if it is about restricting column replication, why don't you make those columns part of a break group?
Whichever it is, could you explain it once again, please? An example would be great (possibly based on Scott's schema) so that we could reproduce it.
|
|
|
Re: passing parameters... [message #259280 is a reply to message #259174] |
Tue, 14 August 2007 23:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ab_trivedi
Messages: 460 Registered: August 2006 Location: Pune, India
|
Senior Member |
|
|
Hi
Can u give more detail that what type of report you want to prepare because what you want is possible. But be more clear about your problem.
Ashu
|
|
|
Re: passing parameters... [message #259324 is a reply to message #259229] |
Wed, 15 August 2007 01:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
brintha
Messages: 28 Registered: August 2007
|
Junior Member |
|
|
Hi,
Thanks for ur reply. I ll explain in detail. There are two tables say location and location_refnum. location_id is the primary key for location and it is the foreign key for location_refnum.refnum_id is primary key for location_refnum.
now the location_refnum(refnum_id) will have more than one refnum_value depending on the type selected.In real time there may be even hundreds of refnum_values.
But the requirement is the refnum_value must be displayed for those records which has a specific 'type' value. This type is in location table. for type = 'customer' say then then the refnum_value will have only one value. i want to display that refnum_value alone and not others(leave them empty)but ill display its type and location_id.
The replication comes if the refnum value is retrieved using the base query since many refnum_values are there for same location_id and refnum_id.
I displayed the refnum_value using formula column to avoid the replication where i gave a condition like the refnum_value must be displayed only if the type = 'customer'.
I got it right in my report. There was no replication thereafter.Now I have to pass parameter to the refnum_value and get the records which matches the same.
thanks and regards,
brintha.r
|
|
|
Re: passing parameters... [message #259608 is a reply to message #259324] |
Thu, 16 August 2007 02:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
sispk6
Messages: 164 Registered: November 2006 Location: pakistan
|
Senior Member |
|
|
if you are passing parameters from a form to a report then use
"run_product(5 parameters)" if you are using 6i--see help
and if you are using higher version use
"run_report_object()"
and if you are passing parameters from one report to other and they are master detailed reports then
then you can use "drill down reports" , view topic drill down reports there is a sample report there.
else use parameter forms, simplest of all
|
|
|