Hi! i have used the parameter the Mgrno and when i enter the Brinkman iam getting only upto the first level that the stackr and the Nobler (level 2 ) is displayed but i wanted to get the the (level 1) also and i am unable to specify the condition the level no as i wanted it to be parameterized...
Hi!
I tried to work the same way but it did not work out for me so can you please walk me thru the steps... IT would be great if you can help me with this problem.
Thanks
Hi!
I have a table like the following
| Emp_Id | Mgrno |Levels|
|--------+--------+------|
| | | |
|--------+--------+------|
|Brinkman| | 3|
|--------+--------+------|
|Nobelr |Brinkman| 2|
|--------+--------+------|
|Stackr |Brinkman| 2|...
No i put the above formula in the select expert in the formula but the query is working as it is before but only thing i dont see it getting passed in the where clause......... in the show sql query
Hi!
iam using the following forumla to give some conditions to the field like
if
{?paramname} = 'All' then true --- (All is added manually in the default option to get in the dropdown list.)
else
{fieldname} = {?paramname}
and when i run the query everythig works fine but it is not...
Hi!
The above parameter passing worked fine but i have one more question like i put that in formula and i wanted it to pass in the where clause in the SQL Query to improve the performance.... It would be great if somebody can help out.
thanks in advance..
sunsree
Hi!
I am trying to pass parameters to the where clause when i initially create it, it is shown in the where clause but when i added the parameter in the formuls like i want to pass the city name = 'All' and if it accounts All it should fetch all the records no matter what the city name is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.