Query Report Temporary Table

Hi veryone, maybe anyone can help me, is it possible if we make temporary table in query report?

thx bee

I think latest versions eliminated the requirement which each query must start with “SELECT”.

So you may try

WITH CTE AS .....
END
SELECT ....
FROM CTE ....```

hi morning turker, i will try it first, thanks

hit turker, ive got this message after i create query report with query like write down below

“Query must be SELECT”

My query report

WITH cte_citywarehouse
AS
( select
* from tabDistributor Warehouse
)

SELECT *
FROM cte_citywarehouse

There was a discussion about it but I don’t remember the location. Which version is this?

Your best option is create custom report. Script Report