I need to take out duplicates from date column in cross tab in crystal report 8.0

Question

​In cross Tab: One column is date. I need to show only month in following order fiscal year order: April May june July August September october november december january febuary march.

It should not be more than one time. While I am trying I am getting duplicates months in the column.

Answer 1

it may happen because of many causes. My opinion is, you should put some screen shot or your codes here, so it easier for experts to understand you problem.

this is what i can suggest to you

• if you have many tables linked together, please double check if the link is correct or not

OR

• you can select Database-->Select Distinct Record at the menu