I have a query in SSRS which is working perfectly and returning the correct data from a webservice on my live webserver when I hard code the parameter value in, however, I need this to be dynamic, and to be a parameter passed into the report itself. I cannot work out what the syntax for this is though, as nothing I have tried seems to work.
Here is the query (the report parameter I need to pass in is called CompanyID):
<Method Name="GetTicketTotalsThisMonth" Namespace="http://tempuri.org/">
I have tried Parameters!CompanyID.Value
e, @CompanyID, [@CompanyID]... all to no avail.
If anyone knows what the correct syntax is for this, I would be very grateful, as it's driving me crazy!