Solved

Crystal Reports Formula end of the month and previous

Posted on 2014-09-25
2
1,506 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
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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Printing duplex pages and have a page break 6 44
WAN Site Edge Routers 15 56
What is CPU in "RP/0/RSP0/CPU0:router#"? 6 43
Sum not calculating correctly 21 26
Hello , This is a short article on how would you go about enabling traceoptions on a Juniper router . Traceoptions are similar to Cisco debug commands but these traceoptions are implemented in Juniper networks router . The following demonstr…
I recently attended Cisco Live! in Las Vegas, a conference that boasted over 28,000 techies in attendance, and a week of hands-on learning hosted by a solid partner with which Concerto goes to market.  Every year, Cisco displays cutting-edge technol…
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…

786 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