Solved

Crystal Reports - Suppress group footer based on date less than six months

Posted on 2013-02-07
6
1,117 Views
Last Modified: 2013-02-08
I would like to suppress my group footer if my running total "date" is less than 6 months.   I have the following formula but it does not work..

I have this in the section expert section.   The supression is not ticked.

Can I supress the whole line in the details section?

{#RTotal0} = CurrentDate - 180
0
Comment
Question by:RichardH1976
6 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 38864415
I'm struggling with the concept of a 'running total Date' - can you explain this please.
0
 

Author Comment

by:RichardH1976
ID: 38865189
Sorry that is not clear.   I have running total on the date which tells me the last date worked on a PO.  (Maximum Date in Running Total)  This works well but I need to supress all dates which are within the last six months.
0
 
LVL 14

Expert Comment

by:LinInDenver
ID: 38866257
Using that "=" sign would only suppress maximum dates that are exactly 180 days ago.

Maybe try:  {#RTotal0} <= CurrentDate - 180 to hide things older than 180 days.

or  {#RTotal0} >= CurrentDate - 180 to hide things newer than 180 days.
0
Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 38866772
Do you need the data in the report or arer you suppressing all information on a PO if it was worked on in the last 180 days?

If you want to see data that is over 180 days old regardless of work after that just use a record selection formula to select data that is older than 180 days.

mlmcc
0
 
LVL 34

Expert Comment

by:James0628
ID: 38867291
This doesn't answer your question (hopefully the others have taken care of that), but, FWIW, if you want the last date for a PO, and the report is grouped by the PO, you could use Maximum instead of a running total.  Something like Maximum ({date field}, {PO group field}).

 James
0
 

Author Closing Comment

by:RichardH1976
ID: 38867621
Thanks.  the formula worked in the selection criteria..
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question