Dear Team,
I need help in compiling an eql report in SSRS where I want to reuse the sub report in other main report
The challenge is – I want to use a variable as @objects and used to callup the objects
Question – what can I do to get it to work
START WITH @objects
SELECT
Projects.Project.Code,
Projects.Project.Name,
DISPLAY_NAME( Projects.Project.Status ),
CASE Projects.RelationshipType.RightName
WHEN 'Shared Project' THEN 'No'
WHEN 'Owner Project' THEN 'Yes'
ELSE ''
END Owner
WHERE
Id LIKE @coid
The eQL query dataset works just like a SQL query dataset in SSRS. As far as I can tell it is not possible to use a variable on a SQL select statement in SSRS so therefore it would not work with eQL.
Answer Verified By: Jurie Nortje