Hi veryone, maybe anyone can help me, is it possible if we make temporary table in query report?
thx bee
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