Hi Team, I have created a CrossTab query and SELECT query on the same data where I have Type of Certifications in Rows and Years in Columns as shown below:
And I did this, in order to auto-refresh/re-query the data in reports. But when the new Year gets added to the Data, the query is updating, but the Report is not updating. Would you please help me. Thank you in advance.
Certification | 2018 | 2019 | 2020 | 2021 | 2022 |
---|---|---|---|---|---|
Certificate Type 7 | | | 1 | | |
Certificate Type 4 | | 1 | 1 | 1 | |
Certificate Type2 | 1 | 2 | 7 | 3 | 1 |
Certificate Type 3 | | | 2 | 1 | |
And I did this, in order to auto-refresh/re-query the data in reports. But when the new Year gets added to the Data, the query is updating, but the Report is not updating. Would you please help me. Thank you in advance.