Search results for query: *

Rather odd question I have. My Report consist of tons of fields where Legal paper size will not help. I have 20 fields out of which 1 is page long Description. The rest are regular size fields 4 to 40 characters. Have anyone ever came across of non-standart Report design so you can share with...

I just read Cliches thread and though when they say The more you buy the more you save (during sale of course) it IS true because you save more but you spend more too. So is this 'politically' correct to use this statement for sales people? Is this statement THE most misleading or THE best...

Please, help me to resolve this problem. I have few string and 1 Number fields on my Report Groupped by Code. Code ID1 ID2 OrderNo Cost(Number) I need to have Count of ID1 per Code Count of ID2 per Code which I just inserted Count and it works. Now I need Count{ID1}*Cost then result...

I am having a Number field that I am displaying as Amount with decimals. If I choose Custom style - decimals value dissapears and all numbers come up with .00 If I write formula '$' & "" & {t.field} it comes up without decimals... Can you please, help? I need to display $ 500.34

Hi, another issue I am stuck with. I have some order numbers that are <NULL> but I need to group by Order Number. <NULL>s won't show up. What to do? Thanks. I am using CR9.

I have fields ID Stage 1 Finished 1 NC 1 NULL 2 Finished 2 NC 2 NULL 2 Finished I wrote formula StageStatus If isnull{table.stage} or {table.stage}='Finished' then 1 else0 Then I am inserting field SUM@StageStatus and I am getting result: ID Finished 1 2...

I am using field in Detail section that has Phone Fax Email Web I want to display Phone Number: Fax Number: Email Address: Web Address: But using If formula gives me 'boolean needed' error. Any suggestions? I can use Case statement in my view but I preffer not to.

I am having a blast with another piece of data. Do I have to use SUB? ClientID AdrsLoc Adrs AddLoc Loc AddLocDesc 111 Office 1Street Phone Home 213000000 111 Office2 2Street Fax Home 213000001 111 Office 1Street Email Office 2@q.tv 111...

I have another fun thing to deal with. Type Location Desc Phone Office 2349456754 Phone Home 2345678999 Email Corp bbre@aa.org Email Office oops@rt.com Email Corp1 qqq@aa.tv What I am looking for is to get every possible combination of...

I have a strange question. My formula CountOrd counting orders if isnull({vw.DPT}) then 1 else 0 So when Report comes up with zero records - formula showing 1 anyway. I wrote another formula If not isnull ({vw.ID}) then {CountOrd} ID is the field Report can not be without. So it still comes...

> ALZHEIMERS' EYE TEST > > > Count every " F" in the following text: > > FINISHED FILES ARE THE RE > SULT OF YEARS OF SCIENTI > FIC STUDY COMBINED WITH > THE EXPERIENCE OF YEARS... > > (SEE BELOW) > > > > > > > HOW MANY ? > > > >...

I am running my SQL quesry and output result is Order Stage 123 NC 123 <NULL> 123 Completed So I need to count how many different stages my order has. NC-1 <NULL>-1 Completed-1 But value <NULL> doesnt get read somehow by CR9. Is there way around? I need to count everything...

Result of my SQL is OrderNo Result 123 NC 123 Completed 122 NC 112 NC 112 NC So I can have several similar Order Numbers but i need to select only those with "Completed" as a Result. I will be writing it in CR 9. Thanks

My 'moister' post got 42 posts I never hoped for. So here is another word from my 6th grader. Yesterday she reads 'his hands rap ... steering wheel' - I am not sure exactly of the sentence but she said she sees it for the second time and could this be type of 'wrap' word? I wasn't sure. Do you...

I used formula {table.city}& ", " &{table.state}& ", " &{table.zipcode} But if any of those are NULL formula will not show nothing. How should I go about it? Tahnks

Hi, I have Line Name in Details. It is part of the formula If {Field1}= 'PP' then "<b>Line LineName:</b>&nbsp&nbsp&nbsp" & {FieldName} else "" Sometimes I have 3 lines of text. I want to display words "Line Name" just once. And have 3 description underneath. Sometimes condition {Field1}= 'PP'...

Any ideas on how to say that some 'food' have more moisture in it...moister? My daughter brough it from 6th grade and we had fun trying to figure it out.

Hi, I have semicolons after the string I am displaying. How do I get rid of those. I wrote formula but it does not work, it looks for an integer. Field is a String though. Please, help.

I am having a cool problem. There is 3 screens for my Report to be attached to. Only 1 Variable - IDNo but at each screen it has different name - ID, Ind, Cus. So I have to call IDNo for each screen in one SQL statement. Otherwise I will have to create 3 Reports that are identical and it is very...

Hello, I am stuck with a problem (I am using CR9) I have groups of products with names that are like this Product_Description MNB-9-Spring MNB-9-Fall M-NN-8-Winter M-NN-8-Summer AA-BB-NN-4-LA AA-BB-NN-4-CA When I group I need to group MNB-9 in one group and calculate total for this MNB-9...