Solved

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

Posted on 2013-02-07
6
1,103 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
Comment Utility
I'm struggling with the concept of a 'running total Date' - can you explain this please.
0
 

Author Comment

by:RichardH1976
Comment Utility
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
Comment Utility
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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks.  the formula worked in the selection criteria..
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…
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…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now