Skip to Content
Jun 23, 2020 at 06:29 PM

Why does adding one filter result in no data being pulled


I am trying to modify an existing Crystal Report such that the year variable is incorporated into the filter for the report so I can pull the data for one specific year, but when I add that year field I no longer retrieve any data when I refresh the report. However, before I added this extra filter I was able to retrive data from all previous years. I have only added one new link between “Year_5” in Addon_10 and the “Code ID” in the Code 5 Table. Please see the screen shot 1 below. Additionally, I add a new filter Code5.Code and set it equal to “2020”. Please see the screen shot 2 below. Can you help me figure out what I am doing wrong please?