Solved

Crystal Reports Formula end of the month and previous

Posted on 2014-09-25
2
1,546 Views
Last Modified: 2014-09-25
I want to automate a report to run on the first of every month to show past due items and items that will be due for the month.  So on 10/1/14 I want to run the report and it will filter anything with a date of 10/31/14 and before.  How can I do that?
0
Comment
Question by:ITworks
[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
2 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 40344794
To get the items due last month use

{DateDueField} IN LastFullMonth

For the items in the next month (this won't be exactly right but it is close

{DateDueField} IN Next30Days

For the current month you could also use

{DateDUeFIeld} >=CurrentDate and
{DateDUeFIeld} < DateAdd('m',1,CurrentDate)

mlmcc
0
 
LVL 18

Expert Comment

by:vasto
ID: 40344857
When you say "automate" , do you mean that you are going to run the report manually and you want it to get automatically the month data ? The other option is to set something to run the report for you at the beginning of each month and send it to you by email so you can stop thinking about it at all. What is your goal ?
With case 1 you need to set the logic to get the month period inside the report and mlmcc explained how to do this. With case 2 you can set the month period in the scheduler, which is going to run the report for you. You need to define 2 parameters in your report : Start Date and End Date for the beginning and the end of the reporting period and ask the scheduler to fill the current month dates there.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
replacing 2811 to ISR 4331 2 48
Help logging in to my router 12 66
Sum of multiple formulas 6 28
Network over eigrp 100 topology ? 3 61
In the hope of saving someone else's sanity... About a year ago we bought a Cisco 1921 router with two ADSL/VDSL EHWIC cards to load balance local network traffic over the two broadband lines we have, but we couldn't get the routing to work consi…
Quality of Service (QoS) options are nearly endless when it comes to networks today. This article is merely one example of how it can be handled in a hub-n-spoke design using a 3-tier configuration.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

726 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