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