Search results for query: *

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

Hi, Iam trying to display the last entry of a journal field. iam using crystal 8.5. i have tried grouping by the calllog.callid field and placing the journal text field in the group footer: the result brings up all journal entries for that call id. Any help you can give that would display the...

I got the page number corrected by right click on the page# and format field. Thanks Again! nic If you have a reference article(site) on that page counter formula you can direct me to, that would be great.

I used the formula from that site that you attached. that worked beautifully. Thank you all so very much! one last thing-the numbers are displaying 1.00 rather than 1. how do i correct this? Thanks Again, nic

Hi, I have been searching on ways to put the page numbers on my reports(my main report has 4 pages - would like the report to display this- ie page 1, page2 and so on) The default shows the subreport page as 1 and 5. My first subreport has 2 pages(would like the subreport to display these two...

ok, thank you all. i got the heading, i removed the grouping from my main report and insert the text manually. Thanks Again! nic