Posted by Dilbert on 10/21/49 11:30

Nevermind, It seemed to work the second time i tried to run the query
in reporting services.

BEGIN

CREATE TABLE #temptbl2
(
Enddate VARCHAR(50),
ProjectNumber VARCHAR(50),
ProjectManager VARCHAR(50),
resourceManager VARCHAR(50),
CostCentre VARCHAR(50),
WorkInProgress FLOAT
)

INSERT INTO #temptbl2
EXECUTE jmpwipreportbasic '09/09/2009'

SELECT DISTINCT costcentre FROM #temptbl2


DROP TABLE #temptbl2


END

Maybe this will help someone else.

• Next in forum: Re: Record , Row number
• Prev in forum: Distinct Filter in SQL Reporting Services
• Thread view: Re: Distinct Filter in SQL Reporting Services

[Reply to this message]