Forum Discussion
Reusing a Query and retaining applied steps
The easiest way I have found to perfrom this that doesn't involve extensive effort is by grabbing the code from the query while in "edit query mode" (right-click the query and select "advanced editor"). I have copied everything in the editor and then created a blank query in my other report. After pasting everything into the blank query, it ran and applied every step from the prior, as if it were a copy, but it was not dependant on the original source. Actually, i had to resolve a few minor errors since i had made updates to the query in my first report which referenced queries not yet in my new one, so i applied the same steps to copy the referenced queries over and all was well within 5 minutes total!
Thank you for this! I wish that the OP would accept this as a solution becuase it works perfectly for what everyone on this thread is looking for. I'll add that you need to paste the Advanced Editor code into the Advanced Editor for the new Query, as opposed to pasting the code into the blank query itself.