exec rpt_GenerateReportPivot
@ReportId=56465,@Type='Gauge',@UserId=44805,@DataSetId=8,@principalUserId=0,@ColumnA='null',@ColumnAName='null',@ColumnB='null',@ColumnBName='null',@ColumnC='null',@ColumnCName='null',@ValueColumn='Calc103_Val',@ValueColumnName='Harsh Cornering
Score',@ValueColumnAggregates='',@startDate='2017-01-01 00:00:00',@endDate='2017-09-30
00:00:00',@Aggregate='Avg',@UniqueField='',@min_latitude=0,@min_longitude=0,@max_latitude=0,@max_longitude=0,@numberOfItems=0,@sortBy='Name',@sortIndex=0,@sortDirection='',@commaSeparatedValues='',@highlightedUserDataIds='',@where=' AND (1 = 0
OR (ud.ScopeTag IN (select gst.scopetag from Group_ScopeTag gst where gst.groupid in
(''1312855'',''10224964'',''10224965'',''10224966'',''10224967'',''10225374'',''10225375'',''10225376'',''10225377'',''10225378'',''10225379'',''10225380'',''10225381'',''10225382'',''10225383'',''10225384'',''10225385'',''10224968'',''10224973'',''10224976'',''10224977'',''10224987'',''10225008'',''10225011'',''10225012'',''10225013'',''10225014'',''10225015'',''10225017'',''10225293'',''10225314'',''10225369'',''10224969'',''10224974'',''10225391'',''10224978'',''10224981'',''10224988'',''10225009'',''10225206'',''10225298'',''10225226'',''10225350'',''10225016'',''10225349'',''10224970'',''10224971'',''10224975'',''10224979'',''10224982'',''10224985'',''10224989'',''10224996'',''10225004'',''10225007'',''10225286'',''10225010'',''10225087'',''10225386'',''10225387'',''10224972'',''10225389'',''10225390'',''10224980'',''10225394'',''10224983'',''10224986'',''10225347'',''10224990'',''10224991'',''10224992'',''10224993'',''10224994'',''10224995'',''10224997'',''10225003'',''10225213'',''10225308'',''10225005'',''10225006'',''10225317'',''10225367'',''10225388'',''10225392'',''10225393'',''10224984'',''10225165'',''10225178'',''10225263'',''10225216'',''10225244'',''10225257'',''10225053'',''10225114'',''10225133'',''10225135'',''10225189'',''10225077'',''10225122'',''10225128'',''10225147'',''10225169'',''10225277'',''10225182'',''10225321'',''10225119'',''10225138'',''10225171'',''10225296'',''10225097'',''10225175'',''10225184'',''10225199'',''10225103'',''10225112'',''10225145'',''10225158'',''10225183'',''10225204'',''10225243'',''10224998'',''10224999'',''10225000'',''10225001'',''10225002'',''10225060'',''10225064'',''10225118'',''10225152'',''10225154'',''10225173'',''10225124'',''10225201'',''10225327'',''10225252'',''10225080'',''10225142'',''10225163'',''10225068'',''10225285'',''10225185'',''10225156'',''10225196'',''10225131'',''10225094'')))
)  AND (ud.ScopeTag IN (select scopetag from User_UserDataScopeTag where userid = 52874) OR ud.ScopeTag IS NULL) ',@preview=0,@database='',@filterByGroupIds='1312855,10224964'