Search results for query: *

I hope someone can help: I am using crystal 10 with sql, my problem report is using two number parameters. I want to be able to use the two parameters in a formula is get a percentag. The factor in my report is the selling day. Example if there is 22 (monday-friday) selling days in january and...

LB [2thumbsup] Thank you ;-) micheleg

LB, I will try this in the am... The only other formula is on invoice data which is also in ARO_InvHistoryDetail and there are not any conditinal formulas. Ill let you know how this works out I appreciate it

This is how my data appears prior to using my formula: PL SOITEM DESCRIPTION SO MISC.ITEM EXT.AMT SERVICE SERVICE 50.00 REPAIR LABOR LABOR 100.00 65 41951 KEY PAD STSMAN 47.00 34...

i am sorry, I see what your asking, and I made a mistake on my first post, the files are ARN_Inv.HistoryHeader and ARO_Inv.HistoryDetail, the somisc item code and soitem number come from the Inv.HistoryDetail file, the only files I have pulling from the Inv.HistoryHeader is Invoice Date and...

by the way, i have tried your first suggestion with the joins, the report is running now, the report takes about 45 minutes to run...... yeh one problem at a time. I'll just be thankful to get this report to return accurate information.

I have accessed the history files before so I don't think that is what this is. I am currently using MAS90 3.5 with Crystal 8.5. The data files I am using are: ARO-History Invoice Date Cust. No. ARN-Detail SO Item Num SOExtChargeAmt ARN-CustomerMaster Customer Name Sales Rep...

Tables involved are: ARO_History ARN_Header AR1_Cust.Master Linked in that above order order with equal joins...... Selection formula giving me the problem is: ARO-SOItem <> "items" result returns the items excluded which is correct, except as I previously stated, SOMISCITEMCODEs in ARN_Header...

I have a mas90 crystal report, i created, not canned, the problem I am having is I am lossing data when I select certain criteria. This is a sales report and there are certain inventory item numbers which appear as line items on my invoices that I must exclude, which is fine I am able to exclude...

I have a gross profit report sorted by product line (which I have created as groups. I need to combine the totals of some of the product lines into one line. Current setup product line gp 0033 33% 0034 36% 0035 30% Required result Paper...