cancel
Showing results for 
Search instead for 
Did you mean: 

Why does adding one filter result in no data being pulled

0 Kudos

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?

msundararaja_perumal
Active Contributor
0 Kudos

You may start by applying individual parameter for troubleshoot.

Thanks.

venkateswaran_k
Active Contributor
0 Kudos

Hi

Please provide the relation between code_5 and year_5

Accepted Solutions (1)

Accepted Solutions (1)

anthony_mendes3
Participant
0 Kudos

The issue may be table linking.

With Table linking note you have a few options if you go through Database Expert option

a. how you manage with different Join Types.

b. How you manage to enforce the Join.

Answers (0)