Crystal REport Date issue

Posted on 2012-09-06
Last Modified: 2013-02-22

i have a report where i need to show values based on dates. its a monthly report so report should show dates even when there is no transaction but that date is not coming from database, for example, there are records from 14 June but no records for june 15, so database doesn't give u june 15 and gives u june 16. Now this can happen multiple times within a month.

so i was hoping if anyone can tell me how to display dates even when there is no records coming out from the database for that particular date and should be able to display multiple times. i would really appreciate any help.

Question by:shirighimire
    LVL 34

    Accepted Solution

    In theory, the simplest thing is if you can create a table that has every date in it and link that to your data, so the report gets at least one record for each date.

     If you can't do that, it may be possible to have the report try to fill in the blanks.  For example, have a formula in the report compare the date in the current record to the date in the previous record and, if they're more than 1 day apart, produce a list of the missing dates.  Whether or not that's practical/possible may depend on the structure of your report.

    LVL 18

    Assisted Solution

    You can generate a table with all days in a period and left join it with your data.
    A SQLServer function and a sample how to use it are available from this link:

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now