SSRS - XML Params

Basically, for the AM Templates/reports params to be used in the SSRS reports, you need to have set up the params in the SSRS report.

In the XML [Data] tab (see yellow section in image above, press the [...] to access params), then select the [Parameters] tab. Copy and paste the following:

 

          Name:         Value:

parameters    =Replace(Parameters!queryParam.Value,"@snapshot_type=null","@snapshot_type=2")

When testing the report copy and paste the default values into the dialog box.