3 Replies Latest reply on Aug 20, 2015 12:52 PM by Thys Coetzee

    Report Generator chokes on naming columns

    Thys Coetzee
    Thys Coetzee May 8, 2015 9:48 AM

      Having a spot of trouble with the Report Generator.

       

      Perfectly good query executes in SQL Manager, chokes in Report Generator because

      ...

      ...'' END as [Restore from cold storage]

      ...

      Says it's a read only tool and I cannot put titles on columns.  Really??????

       

      okok breathing again... is there either a fix to this tool that can be had, or an alternative replacement tool I should be using.

       

      Thanks,

      Thys

        • Re: Report Generator chokes on naming columns
          Thys Coetzee
          Thys Coetzee May 8, 2015 10:41 AM (in response to Thys Coetzee)

          Further information:  Came across another mind-number...  the word 'modify' in a string breaks the Report Generator.

           

          So I changed the code from

          ...

          CASE (GroupProjectRights.Type & 1) WHEN 1 then 'Yes' ELSE '' END as [Read],

          CASE (GroupProjectRights.Type & 2) WHEN 2 then 'Yes' ELSE '' END as [Check Out],

          ...

          to

          ...

          CASE (GroupProjectRights.Type & 1) WHEN 1 then 'Read' ELSE '' END,

          CASE (GroupProjectRights.Type & 2) WHEN 2 then 'Check out' ELSE '' END,

          ...

          Gives a hideous table but we can see the data we need.

           

          One of the strings was 'Modify data card' -- and Report Generator broke.  Changed 'modify' to 'change'  and we're off to the races!

           

          Yes, I dug through the whole dang thing to isolate that.  Someone at SolidWorks owes me a beer!  ...or and some good code!

           

          --Thys