Blank report designer screen Topic is solved

[treed]

I was working on the SQL for a fairly complicated report and something happened and now when I try to open the designer the screen is blank. I restored the reports table and the problem persists. The sql query opens and runs fine when I paste the code into MyPHP admin. Any ideas?

[treed]

So I found the root of the problem is this bit of SQL. It runs perfectly in mysql from the phpmyadmin console. When this code is deleted from the query the report opens. Why???

Code: Select all

,
    if(ISNULL(OrdShipToAddr2),CONCAT(trim(OrdShipToAddr1),", ",trim(OrdShipToCity),", ",trim(OrdShipToState),"  ",OrdShipToZip),CONCAT(trim(OrdShipToAddr1),", ",trim(OrdShipToAddr2),", ",trim(OrdShipToCity),", ",trim(OrdShipToState),"  ",OrdShipToZip)) as SAddr

[treed]

And . . . . I found the fix. Changed the double quotes to single.