Search results for query: *

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

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?

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

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

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

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

Thanks, will test it now.

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

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

THANKS

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

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

Thanks I shall try that!

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

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

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

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

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

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

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