1 Reply Latest reply: Sep 16, 2010 10:46 AM by APPE RSS

    Disappearing Script Tabs

    APPE

      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?

        • Disappearing Script Tabs
          APPE

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