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

Record Selection Formula

Status
Not open for further replies.

rbh123456789

Technical User
Mar 3, 2010
80
CA
CR 11.5

//This is my record selection forumula
{RPT_R_MONTH.PreviousDate}<= {?date_end};
{RPT_R_MONTH.ID} <> 432;

There is a record (432) that i want to exclude from Crystal. When '{RPT_R_MONTH.ID} <> 432;' is in the formula, it stops the '{RPT_R_MONTH.PreviousDate}<= {?date_end};' parametre from working and it pulls ALL the records and ignores the {?date_end} parameter.

When the RS forumla does NOT have the '{RPT_R_MONTH.ID} <> 432;' portion, the forumla works fine, but then i have the problem of the extra record.

Any ideas?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top