Вывести любой запрос в отчете

DROP TABLE ##t
select ROW_NUMBER() over (order by [CreatedOn] DESC) as rn, [ID], [CreatedOn], [BasicPrice],OfferingID,RecordID,OfferingName INTO ##t
        from [tbl_OfferingPriceLog]
         WHERE PriceCategoryID = 'B46B83EF-39AD-4687-B375-AB60EF931309'
------------------------------------------------------
DROP TABLE ##m
SELECT A.[ID] ,A.[CreatedOn] ,A.[BasicPrice],A.OfferingID
      ,ISNULL(A.[BasicPrice] - (select top 1 b.[BasicPrice] from ##t B,0) AS DELTAPRICE,
      CASE WHEN ISNULL(A.[BasicPrice] - (select top 1 b.[BasicPrice] from ##t B,0) = 0 THEN 0 ELSE
       1 END AS COUNTDELTA INTO ##m
  FROM ##t A
-------------------------------------------------------
  SELECT o.Name AS Name, SUM(a.COUNTDELTA)AS Count
  FROM ##m A
  LEFT OUTER JOIN tbl_Offering o ON o.ID = a.OfferingID
  GROUP BY OfferingID,o.Name
  ORDER BY Count DESC
 -------------------------------------------------------