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],
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!
MODIFY and DROP (from your other post) are SQL keywords. I'm not surprised it doesn't like them appearing in other places.
Agreed, Jim -- the keyword is the trick. Quoted and mid-string makes it a bit of a mind-bender though.
SQL itself doesn't choke on those strings in the Management Studio.
At least it is identifiable and therefore fixable...