March 6, 2010

Reports passing parameter

Create a manual data model with a query…select * from emp where sal between :low_sal and high_sal………


 
do proper layout model….
 

Give values

Go to sys admin in apps Register the concurrent executable and program
While Definig Concurrent Program,Go to Parameters Tab

copy Both of  token name from the object navigator…(Reports).Save it in as 2 different token id in parameter tab


save it
Go to Application Developer to create valuesets




Now while submiting reports these valuesets can be used.

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...