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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional populating of report

Status
Not open for further replies.

stevehatpa

Technical User
Feb 2, 2006
9
0
0
US
I am only a Crystal Reports user, but am attempting to change a past coworkers report. We have a a report that grabs various information, such as name, address, account number, etc and puts it into a report for printing out. There are some of them that put the name and address of someone, even though they no longer have an account.

1. Is it possible to write a formula for the account number that says not to put the other information in if the account number is null?
 
Hi,
Yes..In the Record Selection formula editor put:
Code:
Not IsNull({account_nbr}) 
or
Trim({account_nbr}) <> ""
Use your actual field name of course..



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Turkbear,

I think that did the trick! Thanks for the help.

-Stevehatpa
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top