Search results for query: *

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?

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

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

I had been using code written by one of the members here. ( if {?par} <> "ALL" then {t.CODEID} = {?param} else if {?par} = "ALL" then true ) I had modified it and it worked all the time until now when I am facing an issue as follows: Sample Data: CODEID CODETYPE A 3 B 3 C...

Here is the question. I have one department that keeps adding product names to the database. For me to get it in Report I have to retrive it like this If({t.CODE})='FPG'then {t.PG} And I need to write this formula for all products and those are growing. I was thinking about having it done...

Who can recall what "Ewer" is without looking anywhere online?

I am not sure where to post it. All of a sudden my coma key does not work. When I am trying to type it does nothing however once in a while it gets going like 100 commas and I have to use BkSp to erase it. Anybody familiar with this nonsense?

I have value that I've got by extracting portion of the field. Now i need to link this field to the table where these values are Numeric. However extracted are strings. How do i write function to convert Str into Num? Thanks

I had never used Right or Left function creating a views. I need to have field [NAMEOFTHETABLE]=12345 to trim to have everything before =. In Crystal I would use Instr function but in a query I am not sure how to do this. Please, help. Thank you.

Can somebody help me? I have HP Slimline PC at home and all of a sudden my daughter said something Stand By mode but she can't elaborate. What is happening - PC is shutting down while I am working. Light is still on, monitor black. I can turn it off manually and start it and work as nothing...

How is different Driving While Intoxicated vs Driving Under the Influence? Isn't this the same thing?

I have a field that can contain data or NULL value. So all I need is to say when it is NULL - display 'Non Paid' and when it is Not Null display 'Paid' SELECT DISTINCT 'STATUS' = CASE PMTSATAS WHEN NULL THEN 'NOT PAID' WHEN Not IsNULL THEN 'PAID' END from dbo.ASI_ESP_INCENTIVE_1ST_VW So far...

I had asked this before and I am asking again because it doesn't make any sense and I need serious help. My Report is based on view I had created in SQL Server. I am connecting to CR9 using ODBC and from there it is pretty simple. _____________________________ Rep Name Group (Supressed)...

I have data that looks like this ID ProductWanted ProductPurchased 12 aaa aaa 13 aaa ccc 13 aaa bbb My goal is if there is more then 1 product exists per ID - I need to not to show it. I need to...

Oy, vey! We are having a discussion about "maven". M-W says one who is experienced or knowledgeable : expert; also : freak 4a People are trying to determined if one who knows a lot about little is a maven OR/AND a the one who knows a little about everything is a maven. What is your take on...

I've typed into m-w and no result for 'coldesack' Yesterday watching Fresh Prince of Bel Air heard Will telling his Uncle that his baldness is a coldesack. an anyone explain what is this word IS?

Have you ever used or heard anyone using 'Fastidiousness'? Is there shorter version more used? Thanks

I am swept by formulas all of a sudden. prod qty proqty goqty aa1 1 10 120 aa1 2 9 120 aa1 0 8 120 aa2 0 20 10 aa2 5 50 10 I have prod field trimmed so everything for aa goes into same group. So my group is...

Please, help me with formula. Mine is dropping few TOTQTY. I'd tried and moved () everywhere. Doesn't work. Please, look at this: (If({CODE})='PG'then {RATES_VW.EQUIV})*{RATES_VW.TOTQTY} PG EQUIV TOTQTY PG 1 1 PG 1 43 PG 1 6 let say Formula would give me 44 instead of 50...