Quote Originally Posted by Mark Gambo
Why not create a temporary table or use a Union?
I never suggest any one to create temporary table for making the report, use the linking and be the linking expert in the CR.
Temporary table is not the batter solution for making the report because here there is need to fill the table every time when you are calling the report and need to delete the data again.
So try to avoid the temporary table if possible.