Passing Parameters to FileName in Data Driven Subscription

• mschaper

  Ten Centuries

  Points: 1120

  More actions

  September 14, 2015 at 2:50 pm

  #303079

  I have the following Data Driven Subscription that produces reports. Each report looks like I expect it to. My issue is that I would like to get away from hardcoding the fiscal year and accounting period. The actual report has a prompt for fiscal year (FY) and accounting period (AP). These prompts have a default value and the report is run for the default value. Is there a way to change the query below or subscription so that the report name (filename) contains the prompt values for fiscal year and accounting period? Thanks for the help.........

  select

  s.operating_unit

  ,s.region_cd

  , 'FA Additions – '|| trim(s.operating_unit) || ' - ' || s.region_cd || ' - 2015-03’ as FileName

  , 'http://reportweb/admin/rfs/Report Library/Fixed Asset Backup/FA Additions' as FilePath

  from psfs.ps_asset p

  inner join rfs.stn_ops_hierarchies s on s.operating_unit = p.business_unit

  where p.business_unit between 'A0400' and 'A0899'

  group by s.operating_unit, s.region_cd

  order by s.operating_unit, s.region_cd