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

[Former Member]

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

[former_member629712]

Hi,

May I know how you solve this issue? Because I also have problem to display all the months when the data is null.

Hope you can share the solution for this issue.

Thank you.

[abhilash_kumar]

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