Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have written a report with 6 tabs in the script. I made a small change to the script, and pressed OK. When I went back into the script, the next tab was missing, and had been appended to the tab I modified, prefixed by ///$tab. No matter what I do, I can't reinstate the next tab. Has anyone else encountered this, and if so, how did you resolve it?
bumpity bump
I found my own solution. By replacing the lines:
SQL SELECT *
FROM DataWarehouse.dbo."View_ProductionOrderMovements#2(B)" WHERE [Plant]='5701'
...with...
SQL SELECT *
FROM DataWarehouse.dbo.[View_ProductionOrderMovements#2(B)] WHERE [Plant]='5701'
...the next tab could be reinstated. As soon as I put the " " back instead of the [ ] in combination with the parentheses on the SQL View name, the problem came back.
So the solution is to only use [ ] on table names, and not " "