Solved

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

Posted on 2013-02-07
6
1,132 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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 35

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to Bold a formula within another formula 4 48
Crystal Reports 2013 25 77
Sum of multiple formulas 6 41
Multiple Line Graph in Crystal Report 2013 9 51
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. …
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…

734 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