Hi,

 

I have created a new report with a customized query in the Corporate IT part. The results of the report are ok. However, this report is not available for the rest of the people. They don't show it in the reports tab. I'am as a administrator role so I dont know which is the permissión which regulate this.

 

Any idea?

 

I paste the query. Maybe is  missing something that is related with that.

 

SELECT solution.solutionid 'Solutionid' , KB_Topics.TOPICNAME ' Topic',Solution.TITLE 'Subject ',Creator.FIRST_NAME 'Created By',longtodate(SolutionInfo.CREATEDTIME) 'Created Time',Updater.FIRST_NAME 'Last Modified By',longtodate(SolutionInfo.LASTUPDATEDTIME) 'Last Modified Time',Sol_StatusDefinition.STATUSNAME 'Status' FROM Solution INNER JOIN SolutionInfo ON Solution.SOLUTIONID=SolutionInfo.SOLUTIONID LEFT JOIN KB_Topics ON Solution.TOPICID=KB_Topics.TOPICID LEFT JOIN SolutionCreationInfo ON SolutionInfo.SOLUTIONID=SolutionCreationInfo.SOLUTIONID LEFT JOIN SolutionUpdationInfo ON SolutionInfo.SOLUTIONID=SolutionUpdationInfo.SOLUTIONID LEFT JOIN AaaUser Updater ON SolutionUpdationInfo.LASTUPDATEDBY=Updater.USER_ID LEFT JOIN AaaUser Creator ON SolutionCreationInfo.CREATEDBY=Creator.USER_ID LEFT JOIN Solution_Keywords ON Solution.SOLUTIONID=Solution_Keywords.SOLUTIONID LEFT JOIN Sol_StatusDefinition ON Solution.STATUSID=Sol_StatusDefinition.STATUSID