Solved

# Suppress a text label if value falls within group range

Posted on 2012-03-20
329 Views

How can I suppress a text field if the Admitted date (blue) falls within the dynamic range of the date shown within the group (orange)? The Admitted Date doesnt have to be an actual value from the group date column, but if the date can be found within the dynamic range, I'd like the text field (Green) to be suppressed.
cr-issue.JPG
0
Question by:susnewyork
• 3
• 2
• 2

LVL 100

Expert Comment

Not sure you can do it but try this in the suppression formula

{YourDateField} >= Minimum({DateRangeField})
AND
{YourDateField} <= Maximum({DateFieldRange})

mlmcc
0

LVL 1

Author Comment

I had tried that but there is nothing limiting the formula to the groups dates.
0

LVL 100

Expert Comment

Sorry.

{YourDateField} >= Minimum({DateRangeField},{Groupfield})
AND
{YourDateField} <= Maximum({DateFieldRange}, {Groupfield})

mlmcc
0

LVL 2

Expert Comment

I am assuming that the dates in the dynamic range (orange) are in the details and you are grouping on the user:

In the green field's Suppress conditional formula:

AdmittedDateField in minimum (OrangeDateField, UserField) to maximum (OrangeDateField, UserField)
0

LVL 2

Expert Comment

lol. mlmcc beat me to this. figures.
0

LVL 1

Author Comment

I've been helped by mlmcc for at least 7 years under different user accounts. I'm testing this out now. Thanks.

I need to modify my original request a bit i think. I need to show the text field if the Admitted date falls within 30 days of the Treatment Plan Date within the details section. Any more ideas?
0

LVL 100

Accepted Solution

mlmcc earned 500 total points
Try

If those are 2 dates in the record
Suppress with

mlmcc
0

## Featured Post

### Suggested Solutions

C# Crystal Reports 15 61
Select Cross-tab total 2 41
Ignore parameter if no value entered 22 34
Help with a Crystal Report Formula 8 35
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…