Page 1 of 1
Only Showing 'Previous Data' if ProjectID Matches
Posted: Sun Sep 03, 2023 5:50 am
by ericp
I currently have a scenario where I want to create a report that shows 'current' data as well as the 'previous' data. I have created a report where it shows most of the information, but was wondering how I can create a condition that shows 'previous' data that ONLY matches the correct ProjectID - right now my second data table is showing all 'previous' data instead of just the one that matches the 'current' data. I have provided screenshots of my Report.JS designer file and a previous of what it's generating in Preview.
Re: Only Showing 'Previous Data' if ProjectID Matches
Posted: Sun Sep 03, 2023 7:01 am
by ericp
I figured out a way to set a filter that says show if 'previous' ID matches 'current' ID, but then it'll lock on project 10109, and if I look at Project10110, it will just show me the 'previous' data for 10109 rather than 10110.
Re: Only Showing 'Previous Data' if ProjectID Matches
Posted: Sun Sep 03, 2023 9:19 pm
by Lech Kulikowski
Hello,
Please send us your report with test data for analysis.
Thank you.
Re: Only Showing 'Previous Data' if ProjectID Matches
Posted: Mon Sep 04, 2023 5:39 am
by ericp
Please see the attached file
Re: Only Showing 'Previous Data' if ProjectID Matches
Posted: Tue Sep 05, 2023 7:49 pm
by ericp
Nevermind - found the solution!
Re: Only Showing 'Previous Data' if ProjectID Matches
Posted: Tue Sep 05, 2023 9:48 pm
by Lech Kulikowski
Hello,
Ok. Thank you for the information.