Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Date formula (each day), 2010 -> run date Post Reply Post New Topic
Author Message
Dangoo
Newbie
Newbie


Joined: 13 Jan 2015
Online Status: Offline
Posts: 19
Quote Dangoo Replybullet Topic: Date formula (each day), 2010 -> run date
    Posted: 01 Sep 2015 at 9:50pm
Hello,

I need a formula where I can hypothetically place into a blank report in the details section where it will bring up every single date by day ever (obviously this will be restricted by a parameter).

If a starting date is required then 2010 should be early enough, however I need it to carry on until all eternity or at least until the day the report is ran.


example being:

---
01/01/2010
---
02/01/2010
---
dd/mm/yyyy..., etc.
---

Many thanks in advance!

Daniel
IP IP Logged
Dangoo
Newbie
Newbie


Joined: 13 Jan 2015
Online Status: Offline
Posts: 19
Quote Dangoo Replybullet Posted: 01 Sep 2015 at 11:50pm
I found this formula from http://scn.sap.com/community/crystal-reports/blog/2011/12/13/displaying-all-missing-dates-in-a-range--a-custom-function-sample , which I think is the answer.

Edited by Dangoo - 02 Sep 2015 at 3:27am
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 03 Sep 2015 at 6:17am
Just as an aside then, or an alternative solution...

Typically, to get all the dates, you would need a command or a datatable to select all the dates and then join to that (probably as an outer join) for the display in your report.
IP IP Logged
Dangoo
Newbie
Newbie


Joined: 13 Jan 2015
Online Status: Offline
Posts: 19
Quote Dangoo Replybullet Posted: 07 Sep 2015 at 12:51am
Originally posted by lockwelle

Just as an aside then, or an alternative solution...

Typically, to get all the dates, you would need a command or a datatable to select all the dates and then join to that (probably as an outer join) for the display in your report.


I unfortunately do not have a data table in my ERP database. How would I use a command to bring the dates in?

Unfortunately, the solution that i thought i found was only half good. It managed to bring in the intermediate dates however they were pulled in as big block and not as individual entries as desired. as seen in the below link

http://imgur.com/upncBhO
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.031 seconds.