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 strongm 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: *

  • Users: Ladyazh
  • Order by date
  1. Ladyazh

    Quesry runs Slow in SQL - fast in Crystal

    I can run query from Crystal in SQL Query Analizer fast. Not when I am opening View design - time out!
  2. Ladyazh

    Quesry runs Slow in SQL - fast in Crystal

    I have this Report that uses a view i've created in SQL Server. I can only run it in SQL Server for 1 ID at the time. When I run Crystal - I can have 6 IDs and it is running in a seconds. What gives? It drives me crazy...ODBC connection. Nothing fancy. Anyone ever experienced that?
  3. Ladyazh

    Numeric field under string caption

    WOW! that was esy wasn't it? Never knew this!!! THANKS a million!
  4. Ladyazh

    Numeric field under string caption

    Field CoName 0 A 0 B 1 C 2 D 3 E If {?Field}<>0 then {t.Field}={?Field} else If {?Field}=0 then true I works well. Now I need to find way to have user to choose not from 0,1,2,3 but Y and N thanks
  5. Ladyazh

    Numeric field under string caption

    Sorry {?Parm} can not be "Y" - it is numeric and default for it is number.
  6. Ladyazh

    Numeric field under string caption

    Hi! I had probably said it wrong. If{?Parm} = "Y" then // {?Parm} is numeric field so it is not ='Y' it is 1 It goes like this If Y show all Numbers else If N show only Zero values
  7. Ladyazh

    Please, help me with SQL

    Thanks, will test it now.
  8. Ladyazh

    Numeric field under string caption

    I have a numeric field. I need to have it as a parameter. If Y then show everything, if N shoe only 0s. I set it up as 1 as Y and 0 as N. Now how do I show captions in Crystal so user will see Y and N and not numbers? Thanks
  9. Ladyazh

    Please, help me with SQL

    Please, help me to write following: name contact id AAA e 12 AAA b 12 NULL e 11 BBB b 11 So if contract is e then name. If contract is e and name is null then name then contract b and name. Thanks. P.S. I always want cotract e but if not avail then b and...
  10. Ladyazh

    I lost grasp of an old formula

    WOW! It'll take me a while...LOL
  11. Ladyazh

    How to get value greater then NULL from a NULL field?

    If Not(IsNull({t.value})) then {t.value} else 0 gives an error asking for a boolean and it doesn't have a parameter in it. I need to enter parameter and get everything greater then parameter BUT field is NULL at this moment. {t.value} > {?Value} is cool but if field is NULL? If {?Value}...
  12. Ladyazh

    How to get value greater then NULL from a NULL field?

    My Param is {?Value} Field is {t.value} and it is NULL. task is to put a filter on a field and get all values greater then a filter - how do I do that? If Not IsNull {t.value} then {t.value}={?Value} doesn't work. Thanks
  13. Ladyazh

    I lost grasp of an old formula

    One more here. Both of my parameters should be excepting multiply values. I use join({?CodeID},",") for the string but what should I use for the Numeric? Thank you
  14. Ladyazh

    I lost grasp of an old formula

    I think it is working...so far it is!!! Thank you very much!!!!!!!!!!!!!!!!!!!!!!!
  15. Ladyazh

    I lost grasp of an old formula

    I am not sure we are there yet. Turkbear, {?GroupOne}, {?GroupThree} and {?GroupFour} are parameters. It is purely depends on CODETYPE=1, 3 or 4. So {?GroupOne} works with CODETYPE=1 and so forth... I have to tell that there are only 3 CODETYPEs 1,3,4 and several CODEIDs (can grow to whole...
  16. Ladyazh

    I lost grasp of an old formula

    OMG! Thanks to both of you..I am off to testing all of it!
  17. Ladyazh

    I lost grasp of an old formula

    I see, I will try different approach here. Here is data as we saw it before "GroupThree" is CODEID CODETYPE A 3 B 3 C 3 "GroupOne" is CODEID CODETYPE A 1 B 1 C 1 "GroupFour" is CODEID CODETYPE A 4 B 4 User should be able to select...
  18. Ladyazh

    I lost grasp of an old formula

    What I meant by CODETYPE=3 group's CODEIDs should not be mixed with CODETYPE=1 and CODETYPE=4 CODEIDs. is that : As and bs and Cs from group CODEID and CODETYPE=3 can not be mixed up with As and bs and Cs from group CODEID and CODETYPE=1 can not be mixed up with As and bs and Cs from group...

Part and Inventory Search

Back
Top