Skip to Content
avatar image
Former Member

How to display all 12 months data in crosstab crystal reports if no data also

Hello all,

Is anyone can help to display jan to dec data if there is no data available in mar month 0 should display for mar in crosstab of crystal reports.

In Database:

Created date is date time format

i have pulled month and year at database level. I have parameter at crystal report level

Begin month,Begin Year, End Month, End Year.

Please see the below screen shot for your reference.

Jan-15 is (begin month begin year i.e., January-2015)

Jan-15

Feb-15

Apr-15

I want to display

Mar-15, May-15, Jun-15, Jul-15, Aug-15,Sep-15, Oct-15, Nov-15,Dec-15

0 0 0 0 0 0 0 0 0

Seeking for help.

mi.jpg

mi.jpg (25.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 21, 2017 at 01:13 PM

    Hi Bhavani,

    You would need to create a 'Look-up' table that lists all Dates/Months in the database.

    If this is not possible, you would need to build a temp table using a Custom SQL and use the Command Object as the report's source.

    You would then need to use a 'Left Join' from the Look-up table to the Original table that contains the Date fields. On the report, wherever you've used the Date/Month field from the Original table, you would need to replace that with the Date/Month field from the 'Look-up' table.

    This will ensure that there are no breaks in Dates and the Crosstab should list all possible Dates/Months.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded