Show contact info in report only if Certain Company

[FearOfFormulas]

I'm new to this crystal reporting thing so be gentle. I need to have a company's contact info show up on a report only if it is a certain company # that is being shown otherwise I want that field to be blank...any suggestions would be greatly appreciated...thanx

 

[synapsevampire]

Are you saying that you want to identify duplicates or only pull a certain companies rows?

To limit rows in the database, use Report->Edit Selection Formula

Try something like:

{MyTable.MyCompanyNumber} = 12345

Or you might create a parameter to prompt for a company number.

Insert->Field Object->Right click parameters and select New

Set the type to number (assuming that your company field is number)

Then set the record selection to:

{MyTable.MyCompanyNumber} = {MyCompanyNumberParameter}

To remove duplicate rows, select Database->Select Distinct Records.

Though this is version dependent and your post doesn't include any technical information about versions or the data to be used.

-k

 

[lbass]

If you just want the fields to be blank except when the information is for a specific company, then use either a section suppression (format section->details->suppress->x+2) or a field suppression if there are other fields in the section you do not want suppressed (format field->common->suppress->x+2). In either case, enter a formula, e.g.:

{table.companyno} <> 123

-LB

 

[FearOfFormulas]

Thanx for the Input. I used the Suppress Statement with the Formula and it worked great...thanx for Everything