Skip to Content
0

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

Nov 21, 2017 at 06:59 AM

43

avatar image
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

mi.jpg (25.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Nov 21, 2017 at 01:13 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded