on 06-23-2020 7:29 PM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.