Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Displaying all missing dates in a range

Hi,

  I followed this link http://scn.sap.com/community/crystal-reports/blog/2011/12/13/displaying-all-missing-dates-in-a-range--a-custom-function-sample and created a function for displaying the dates missing from range which is passed as parameter values.

Here what happens is that, my report will show first the values which are already in db in that range, and then the missing dates.

for each every record, my second section for missing dates is showing.How to include the missing dates with dates have data

for eg, if i select 01-feb-2014 to 20-feb-2014, and in db, data is there for 05-feb and 10-feb

05-feb-2014 ------- data from db

now the missing dates from second section

then

10-feb-----data from db

now the missing dates from second section

Please help

See

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question