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

Supress the rows that does not show everyday for the last 5 days

Status
Not open for further replies.

Sahubba

Programmer
Mar 16, 2011
108
0
0
US
I am trying to supress the rows that does not display each day of 5 days.
My lay it is.

Record selection
{CKPT_SEND_TO_CACHE} in currentdate to currentdate-6
and
{@Time} in Time (2, 00, 00) to Time (2, 30, 00)

Group 1: Table Name
Details: {INITIALIZE_TIME} {CKPT_DEPENDENCY_CHK} {@Date Diff}


I want the group to supress if the deatils does not output all 5 days.
I want this
Table Name
3/2/2013
3/3/2013
3/4/2013
3/5/2013
3/6/2013

I want to supress these rows
Table Name
3/2/2013
3/4/2013
3/5/2013

Thanks
 
Try a Distinct Count on date within the group. Use Group Suppress if it is less than 5.

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.


[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
 
thanks......I think I was over analyzing it...... :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top