Home » Developer & Programmer » Reports & Discoverer » Report builder query (Reports 6i)
Report builder query [message #305075] Sat, 08 March 2008 03:09 Go to next message
Messages: 145
Registered: January 2008
Senior Member

Is it possible to pass a report query itself as a parameter from Form?

I have problem to check "where" condition in the query builder.

Say for example, I have defined the user to choose the parameter like "all company or one company", "all departments or one department" etc..

If the user select "all", I need to iqnore the where condtion in report query builder.

Re: Report builder query [message #305077 is a reply to message #305075] Sat, 08 March 2008 03:16 Go to previous messageGo to next message
Messages: 21127
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You might research use of LEXICAL parameters.
Re: Report builder query [message #305183 is a reply to message #305075] Mon, 10 March 2008 01:06 Go to previous message
Messages: 29
Registered: February 2008
Location: Karachi, Pakistan
Junior Member
Dear Ilango

There is One way that you can Defined on your WHERE CLAUSE;
for example

where comp_code = decode(:PARAMETER.COMPANY_CODE, 0, comp_code, :PARAMETER.COMPANY_CODE); 

when you enter the 0 in parameter they will get all company codes.

u can also define in your parameter list.

like :-

SELECT comp_code, comp_name from company
union all
select 0, 'ALL' from company
order by 1;

Best Regards
Muhammad Irfan Bakali
Previous Topic: Do not print Button in Preview
Next Topic: Want to Generate excel report form Pdf directly
Goto Forum:

Current Time: Fri Jul 21 10:16:59 CDT 2017

Total time taken to generate the page: 0.09510 seconds