Getting SSRS Reports to Work in Synergetic

Owned by wayewynn.lee
Last updated: Feb 23, 2023 by Chris Savage
2 min read

Synergetic Parameters

  • In order to be executed from SynWeb, one or both of the following parameters are required to exist in a report. These parameters will be utilised by Synergetic applications and should not be populated by the end user. They should have a data type of 'text', accept NULL and blank values and have a default value of NULL. 
  • For the purposes of executing reports from either a report designer or Report Manager, these parameters should be hidden. When executing a report from SynWeb, these parameters should not be included on the report selection screen at all. 
  • The following screenshots depict the SynApproleCookie parameter in a report designer, however the same settings apply to the SynMainDataset parameter, just replacing values against 'Name' and 'Prompt' with 'SynMainDataset'.

General

Default Values

Parameters

Once a parameter has been created in a report, to add the parameter to a dataset, open the Dataset Properties screen for the dataset in question, click on 'Parameters' on the left-hand side, then click 'Add'. Enter Parameter Name and Parameter value as per the following screenshot, then click 'OK'.

In order to use stored procedures within the report, Please specify as Text in the below format

To utilise the Footer within the report Copy the Footer section from any existing SSRS report and also add the available Shared Dataset as mentioned below