Supressing sections

[sqw]

Hi
Please can someone help me. I have a report that run and returns calls logged by our customers and the date they were logged. I want to supress some sections if the call was logged in longer than 1 month ago. I then want to show a section if the call was logged in with in the current month. I have tried to add some formulea to the section expert but cannot get this to work. Hope this makes sense.
Thanks

 

[LizSara]

What version of crystal are you running?

Where does the information appear that you may need to supress? (group, detail)

What fields are you using?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you. ~ Nietzsche"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

[sqw]

Hi

It is Version 11

I want to supress and show info in the group headers depending on what date the call was logged
Thanks

 

[LizSara]

You should just be able to put a formula in your group header supression (section expert) that will supress if your field is greater than the currentdate - 31.

{field} > currentdate - 31

however someone with more knowledge than me might be able to give you additional information that calculates it depending on what month it is and how many days that month has.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you. ~ Nietzsche"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

[sqw]

Thanks for the help I will give this a go and see how I get on