Solved

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

Posted on 2013-02-07
6
1,108 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

911 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

22 Experts available now in Live!

Get 1:1 Help Now