Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Automatic Pull Based on three months Post Reply Post New Topic
Author Message
acemurdoc
Newbie
Newbie


Joined: 25 May 2015
Online Status: Offline
Posts: 3
Quote acemurdoc Replybullet Topic: Automatic Pull Based on three months
    Posted: 06 Aug 2015 at 7:40am
This might be a ridiculous question, but I want to create a report that will automatically pull for the past three months from the print date. After I have the data, it will be calculated in a cross tab, so suppressing the records will not work. The date itself comes from a field named bc_dte. Thanks for any type of assistance.

Edited by acemurdoc - 06 Aug 2015 at 7:58am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 06 Aug 2015 at 7:59am
what do you mean by "pull a server past three months from the print date"?
IP IP Logged
acemurdoc
Newbie
Newbie


Joined: 25 May 2015
Online Status: Offline
Posts: 3
Quote acemurdoc Replybullet Posted: 06 Aug 2015 at 8:01am
Sorry I corrected the previous question. The report will be set up on a server and will run automatically on the first of the month.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 06 Aug 2015 at 8:31am
your select criteria can either do a calculation to determine the two dates in question or simpler approach may be to just use a datediff
e.g.
datediff('m', table.bc_dte, currentdate) in 1 to 3


Edited by DBlank - 06 Aug 2015 at 8:31am
IP IP Logged
acemurdoc
Newbie
Newbie


Joined: 25 May 2015
Online Status: Offline
Posts: 3
Quote acemurdoc Replybullet Posted: 06 Aug 2015 at 8:48am
Works, Thanks!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.032 seconds.