What formula to use for removal of data from Crystal report

[MDSMAS200]

Hello,

I am working on a Crystal Report, and I need to do a formula to get the results I need. I have no experience with formulas, so I hope someone here can help me.

What I am needing is, if a field contains a value, I want it to not print that line on the report. I have been working with the IF THEN ELSE statements, but I am just not getting it.

Also, is there a good site that explains in layman terms about formulas?

Thanks,

Mike

 

[AndyMc]

Mike,

If you don't want the record to come into the report if the field contains a certain value, you can use Record Selection. Go to Report, Select Expert, New, and enter your criteria there.

The Crystal Help does a very good job in explaining formulas. There are also several Crystal How-to Books out there.

Andy

 

[AndyMc]

Mike,

Also Sage and many Sage Resellers offer Crystal classes. The 1st two-day class gets into formulas a little and the 2nd two-day class gets into formulas a lot more.

Andy

 

[MDSMAS200]

Andy,

Thank you suggestion, but I was unable to get the results I am needing. When I tried using Record Selection, it blanked out all of my data.

What I am doing is a Sales Commission Report. I have the report to pull all invoices within a date paramater. I want to eliminate all invoices that were for intercompany transactions. What I am trying to do, is via the Bill to Name, I have linked that to a sort field within customer maintenance. In that sort field, we have IC for the company names that are intercompany. For those companies, I would like it to not populate that invoice number and related data for it.

As for training, I live in a small city. The one Crystal class available is a 2 day crash course of how to use Crystal, which I have already attended.



Mike

 

[AndyMc]

Mike,

Try linking to the customer maintenance file from the customer number to the customer number. Take off the link to the SORT field.

Then from Report, Selection Formulas, Record, enter for MAS version 4.10 or 4.2:

{AR_Customer.SortField} <> "YOUR INFO" (Replace "your info" with your intercompany transactions info.

Andy

 

[MDSMAS200]

Andy,

I had gone back and removed that linking. Also, we figured out that we had to populate all the companies sort field with data. What we initially tried was just putting in IC into the sort data fields that were intercompany. We then tried to have the report pull from the blank fields. I can take it that doesnt work. We put a C in a couple of the companies sort fields, and then through Report Selection, was able to get only those companies to show.

Thank you for your help!

Mike

 

[AndyMc]

Mike,

If you go to File, Report Options, and Check the box that says: 'Convert Database NULL Values to Default', you should be able to leave the SORT field 'blank'.

Andy