Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sunsree

    Hierarchy in crystal

    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...
  2. sunsree

    Hierarchy in crystal

    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
  3. sunsree

    Hierarchy in crystal

    Hi! I have a table like the following | Emp_Id | Mgrno |Levels| |--------+--------+------| | | | | |--------+--------+------| |Brinkman| | 3| |--------+--------+------| |Nobelr |Brinkman| 2| |--------+--------+------| |Stackr |Brinkman| 2|...
  4. sunsree

    passing the parameters to the SQL Query

    iT GIVES AND INVALID CHARACTER (DATABASE ERROR) IAM WRITING THIS IN THE WHERE CLAUSE EXACTLY HOW YOU HAVE GIVEN .......
  5. sunsree

    parameter question

    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
  6. sunsree

    passing the parameters to the 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...
  7. sunsree

    parameter question

    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
  8. sunsree

    Passing parameters .....

    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...

Part and Inventory Search

Back
Top