Is there a way to way display the value of a tag when another tag changes

Hi I am trying to have a report that displays a status of something and when that status changes it gives the current values of a couple different tags at the time of the status change and then it gets recorded in the report. I thought a nested query would be what I want and have the child queries ran off the status change but I can not seem to get this to work the way I am wanting does anyone have any suggestions of how to accomplish this

Do you really mean an Ignition report (as generated by the Report module) or do you mean a Vision window or a Perspective view?