Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What formula to use for removal of data from Crystal report

Status
Not open for further replies.

MDSMAS200

IS-IT--Management
Oct 19, 2007
20
US
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
 
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

 
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
 
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
 
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
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top