Method:Classic General Q&A

Re: Export to Excel when a Grid has column with SQL override

alexhuang — Mon, 08 Aug 2016 22:33:44 GMT

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".

Re: Export to Excel when a Grid has column with SQL override

Method_Ben — Mon, 08 Aug 2016 14:55:31 GMT

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

Export to Excel when a Grid has column with SQL override

alexhuang — Thu, 04 Aug 2016 21:35:15 GMT

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