Can i use two parameter in oracle report
i want to make a report with two parameter when user select user name in one parametr other show names of all users and user select one name ane detail of that user is shown in report.or if user select any other field other parametr show data of that selected column to selected by the user to generate report
Software/Hardware used:
oracle report
Software/Hardware used:
oracle report
ASKED:
December 24, 2010 9:56 AM
UPDATED:
January 6, 2011 4:42 PM
RELATED QUESTIONS
Answer Wiki:
I don't know of an easy way to do that in the Report's parameter form. Lists of values from parameter form's items don't allow the use of bind variables (parameters) by default, and AFAIK you can't change the LOV's query at runtime.
However, there is a way to do it using the Reps_UTL.pll library, but I have never tested it. If you have access to My Oracle Support (formerly Metalink) see note 185951.1
If you are calling your report from a Forms application, you could do it creating as many record groups as needed, and changing the LOV's record group in the first item's when-validate trigger.
To see all answers submitted to the Answer Wiki: View Answer History.
Previous answer from Rechil:
“U can design one report with two parameter list.”
————————————–
Reports don’t have parameter lists. Parameter lists are objects used in the calling application to send parameters to the form, report or other product they are calling, but the called application doesn’t see them as parameter lists.
In addition, you can’t use two parameter lists to call a report. At most one paramlist is allowed. It would not make any sense using two parameter lists given that you can add as much parameters as you need to a single parameter list.
@ Carlosdl, can u please, disclose it with a better example here ! As Zaraiqbal asked ….
what you want to do is probably easier if you used Forms…