Can i use two parameter in oracle report

5 pts.
Tags:
Oracle development
Oracle Reports
Oracle Reports User Parameters
Parameters
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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.
    70,220 pointsBadges:
    report
  • Subhendu Sen
    @ Carlosdl, can u please, disclose it with a better example here ! As Zaraiqbal asked ....
    29,780 pointsBadges:
    report
  • jkeri
    what you want to do is probably easier if you used Forms...
    360 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following