AnsweredAssumed Answered

Using a sql query from the AF server in SQL Server Report Builder

Question asked by GPaterson on Jul 6, 2015
Latest reply on Jul 8, 2015 by GPaterson

I have no problem running the following query in both Pi SQL Commander and SQL Report Builder:

 

SELECT tc.name, tc.BuildingNumber as BuildingNumber, round(tc.Power, 3)
FROM [PIDB-AF].[Asset].[ElementHierarchy] eh
INNER JOIN [PIDB-AF].[DataT].[ft_TransposeSnapshot_CW Meter Template]  tc
  ON tc.ElementID = eh.ElementID
OPTION (FORCE ORDER, IGNORE ERRORS, EMBED ERRORS)

 

Unfortunately this gives all the data when I just need data for just one building; In a traditional sql query I can restrict the vales by:

 

Where tc.name = @CWName

 

Here, the @CWName is a user selected parameter from a list of all the building names. Unfortunately this format is not working, is there a way to only get values for 1 building?

Outcomes