sql:

(Select sum(s.amount) from Sales s

  Join Accounts a on a.AccountKey = s.AccountKey

  Join Campaigns c on c.CampaignKey = a.CampaignKey

  Where c.Code = '3EG6')

 

I'd like to write the where clause as: Where c.Code = {?Code}

 

I have written it like that, but nothing is displayed when the report is previewed. Whereas if I hard code the value, data is displayed.

 

I have added SQL Commands, but I get warning messages in the Link tab.

 

Any ideas on how to get the parameter to work?