Recent content by nickayle

I think i missed these 2: AskField2 if {vr_10630.trantype} = "AS" and {vr_10630.TRANDESC} = "Standard Cost Variance" OR {vr_10630.StkItem} = 0 Then True Else False PStockQty {vr_10630.Qty} thanks!

the formulas in this report seems to be never ending. And i would have taught to total some #'s would have been like taking candy from a baby. But i guess not. I got so far with this, then i got lost. This is my 2nd week working with this. I really hope you can help. thanks! Here is what's in...

Hi, Iam fairly new to crystal and new to this application. I have an inventory report that gives the qty on hand, the unit cost and the ext cost. I need to find the total on the ext cost. the extcost field is a formula: {@TInvQty}*{Inventory.LastCost), therefore not allowing the insert grand...

Hi, synapservampire, I have set up the defaults for the date and last name: when the report prompts, it automatically brings up the default date "1/1/1970" and name "All" - should it work this way. ALSO after inserting the code to the record selection formula it says that a string is needed...

Hi Ido, I have 3 prompts in my report start date, end date and lastname. Is there a way i can just put in the dates and it returns a result OR i can just put a last name and it return that. The way my report is working now is that I have to put in the start date, end date and lastname in order...

save data with report was checked. that works like a charm. Thank You, Thank You, Thank You. nic

Good morning Ido, I tried the code that you send, I even tried using the soundex cmd, neither of those worked. the results are still the same(seems like i have to key the last name as is in heat) Thanks again for your assistance! nic

Ido, it seems like if you don't have the exact name/spelling of the last name exactly how it is in heat, it would not return a result.(i think that was the problem) tell me something, is there a way to just put the beginning letters of the last name and it brings up those customers? Again I Say...

Thank you for the quick response. what i have done is this: i have a parameter prompt call lastname, i have place this in my group footer which is suppress. in my select expert i have profile.lastname = {?.lastname). not sure if this is what you mean. If its not, can you break it down further...

Good Day, I have created a report in crystal 8.5 that displays my customers information. I have tried to prompt on the customers last name by using the parameter prompt. It returns no results. How can i set up the report to prompt for a customer by last name. ie the users can put in the last...

Thanks again guys, the distinct count on summary for all groups and grand total works. thank you LB. what happen was i had my report footer suppress and the total field displayed there. Just realized it. nic

it appears that iam unable to do a distinct count on the same field twice. I have tried it for grand total and summary but the ok button is greyed out. Many Thanks, nic

Madawc, i have tried distinct count and that gives me individuals counts. in the ex above the results would be 1 1 1 this is good, but i also need at the end of the report: total 3 I will search up running totals. Thank You Again For Your Quick Respond! nic

Hi, Good Morning, is there a way i can get a total of my group? i think i have tried all options, but nothing seems to be working. ie, i have grouped by callid, i want the total on changed callid, not on the # of ids' in the group. Iam able to get the total on the # of ids, but not on the group...

You are right, i tried this again with just 2 table and it worked perfectly. but when i try to link 2 more tables it screws up the information. I know my linking is off, will have to do some more searching on this. Thank you again! nic