Home » Developer & Programmer » Reports & Discoverer » problems in selecting tables based on parameter
problems in selecting tables based on parameter [message #151991] Tue, 20 December 2005 07:00 Go to next message
aalia
Messages: 1
Registered: December 2005
Junior Member
hi,
There are 2 tables clients and employees
I am using reports6i the problem is in the parameter form there is a parameter which has lov of 6 values.
If i select the first value of lov the report should fetch data fron clients table and if i select any of the remaining values of lov the report should fetch data from employees table .so please any one can help me its urgent.How to go about it.

Report message to a moderator

Re: problems in selecting tables based on parameter [message #152287 is a reply to message #151991] Thu, 22 December 2005 04:08 Go to previous message
vijaygunturu
Messages: 3
Registered: November 2005
Junior Member
Hi,

create a lexical parameter in the from clause of the query.
Depending on the value choosen fo the parameter,replace that
lexical parameter with the table name.

Regards,
Vijay

Report message to a moderator

Previous Topic: RWRBE60.EXE Error message
Next Topic: Two queries in one report
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 20:04:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.