Doubt in Reports 6i

[vamsioracle]

Hi all


I was working with a report which shows all the invoices for a particular supplier. There was a requirement to show only the validated invoices and remove cancelled invoices from thereport and accordingly i added one condition " cancelled_flag <>'Y'. so that it retrieves data where cancelled flag is not 'Y'.

Now in the apps environment, there is a parmaeter to show only the cancelled invoices. When it is checked YES then no data is coming in the output. How can i handle this problem with respect to the parameter. Can i use two queries in the data model that gets selected based on parameter in apps environment.

please help
thank u

[debasisdas]

based on user input try executing different queries dynamically.

[vamsioracle]

based on user input try executing different queries dynamically.

Thank you very much for your support

but

could you please elaborate it . how to do that

[debasisdas]

In your case u need to execute two statments

execute one by default but when the user chooses some other option try to execute the other query.

It this way the query will be framed dynamically at run time.

[vamsioracle]

thank u

I worked on a query to dynamically select query based on parameter, it was working fine in toad but in report builder it was throwing an error missing expression.

the query is

select decode(:P_CANCELLED_FLAG,'YES',(Select (4+3) from dual),(Select (4+4) from dual)) from dual


the select clause here is replaced by actual select statement in the report. this is a demo one.


please suggest me the problem.
ASAP

thank u

[debasisdas]

Can y specify what is the use of

Select (4+3) from dual
in the query

[vamsioracle]

hi

the query is juat a sample. in place of that i hav to place the query in the report builder.that was testing purpose query which i used in report builder.

Any way the syntax i had put was the same way but ithrows missing expression error.

thank u

[vamsioracle]

Thank u very much for ur continued support

I was able to solve that using lexical Parameters in before report trigger.

thank u