Page 1 of 1
Blank report designer screen
Posted: Wed Aug 16, 2023 3:15 am
by 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?
Re: Blank report designer screen
Posted: Wed Aug 16, 2023 11:13 pm
by 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
Re: Blank report designer screen
Posted: Wed Aug 16, 2023 11:42 pm
by treed
And . . . . I found the fix. Changed the double quotes to single.