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

Select Records to a Crystal Report

Status
Not open for further replies.

RuyPedro

Programmer
Jun 8, 2003
1
PT
Sorry ! You may say that answer to my question is a lost of time but understand that I'm new at Access, programing and Crystal Reports.
Sorry to 4 my bad english...
So give me a hand....
The question is : how can I print in a crystal report (8.5 version) ONLY the records that say yes to a condition I make and don't write some lines without any data (the records say no to the condition) ?
Thanks
Ruy Pedro

 
To strip rows from the dataset returned, use the record selection formula (Report->Edit Selection Formula->Record) with something like:

{table.field} = "Yes"

If you want to create a decision type of column, create a formula (Insert->Field Object->Right click Formulas and select New) and place something like:

If {tbale.field} = "Some condition" then
"Yes"
Else
"No"

Hope this helps.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top