Method Community

Hi,

I have a case when a column with SQL Override, the grid can display date correctly. However, when it is to export to Excel via action, the method says the file is ready to download with a link "Download Excel Report". By clicking this link, it always show "404 - File or Directory not found". What is wrong with this?

[edited[

Seems like if I have "ORDER BY" in SQL, then it failed to output, is that a known issue?

Alex

Hi Alex,

Are you able to send me the name of the Screen you are seeing this issue on So I can take a look? 

As you mentioned, the 'ORDER BY' is known to cause some issues when downloading Reports. Is the download working for you withing the Order By clause?

Thanks Alex.

-Ben

I gave up testing on this by using "Order by" in my SQL with other workaround, so no screen for you at this moment. Yes, whenever I have "Order by" in my SQL, export to Excel fails always, and it works if I remove "Order by".

--