Display all the dimensions in the cross tab

building reports crystal reports
1

Hello Experts,

I have a report where I need to bring in all the months of the year irrespective of the revenue received or not.

In Business objects, we create a separate query to pull all the years and months and then merge at the report level to display all the months.

Any idea how do we implement the same concept in Crystal Reports 2013?

Thanks in advance.

Kalyani.

Kalyani (BOB member since 2007-02-26)

2

You have to have a table that contains all of the dates - not just months. Left Join FROM that dates table TO a date field in your data. Use the date field from the date table in your crosstab and configure it to calculate “for each month”.

-Dell

hilfy :us: (BOB member since 2007-04-16)