Search results for query: *

Hi I have this IF {CUST.COUNTRY}='' then 'U.S.A.' else{COUNTRY.NAME} I am using that so that all us states come under one heading but I also need to compare the customers state with the address state and if the customer state does not equal the address state to make it the address state else...

Hi I have a report that shows the invoice id and the sale but it is duplicating both of these records. I am guessing it is a linking issue but not sure how to fix it, any ideas? i was thinking of surpressing the duplicate but that wouldn't work in the sale amount unless it could match the sale...

Hi I have a tax report that shows the counties with the orders for each county. I would like to give the option to show summery or detail, how would I do that? Thanks

I did a payment audit report and I would like to get it to print each payment account together, like all case for the specific date range then visa, mc and so forth. Right now it prints all of them together for each date. How can I get the report to do each account by itself? Hope this makes...

Hi I have this formula: if {INVOICE.INV_TOTAL}<0 then "CREDIT ON FILE" Is there a way I can give my bookkeeper the option to have this print or not? I don't want it to print on all the credits since some are adjustments. If so how would I do that?

What am I leaving out of this formula IF {INVOICE.TRANS_TYPE}='R' and {INVOICE.POSTADJ}>0 then {INVOICE.POSTADJ} else {INVOICE.REMITTED} IF {INVOICE.POSTADJ}<0 then "CREDIT ON FILE" It tells me the remaining text doesn't appear to be part of the formula (its pointing to this line IF...

I need a formula to do this: If invoice total is negative don't show payment applied or invoice balance. How would I do this?

I am doing a credit form and I want to show negative numbers in the Invoice Balance but when I look at the form it isn't showing the negative numbers just the sign - Any ideas how to get the negative numbers to show?

Hi I am doing a credit form and where I show invoice balance I want it to show the negative but when I print it only shows the - and no numbers. How do I get the negative numbers to show? Thanks

I created a invoice form and right now it shows the items/description/price/total for each item ordered, but it has a line between each item and I don't want that. How do I get rid of the line between each item. Thanks

I was looking at a report someone else did and they have a date range its labeled Pm-?Beginning Date and Pm-?End Date does the Pm-? have any significance in crystal. As I said I am new to crystal and still in the learning stage. Thanks

Hi I am doing a tax report in Crystal and am listing all the counties in New York, now I want to take 5 specific counties and combine them so I just get one output for that and I want to call it NYC Tax. Is there a formula I could use to accomplish this? I am new to crystal and can't seem to...