Make sure the URL is correct in rsreportserver.config file. The value should be the fully qualified path to your report server, with a hostname that is valid for your certificate. E nsure the CA certificate has been installed in the trusted root for the local computer. See: SSL configuration and Reporting Services. Right-click in the right-hand pane, point to All Tasks, and then click Request New Certificate. The Certificate Request Wizard dialog box opens. Select Certificate type is 'computer'. In the Friendly Name text box you can type a friendly name for the certificate or leave the text box blank, and then complete the wizard. After the wizard finishes, you will see the certificate in the folder with the fully qualified computer domain name.
Say I have a very simple self-contained query in the report: with val as(select val = 'ABC'union all select 'DEF'union all select '1ABC3')select.from valwhere val like @ParamI also have a parameter called Param in the report.By default, even though I have like in the query, there are no wildcards so only exact matches will be returned:If we look at the Dataset Properties, we can update the parameter being passed to add wildcards. By default it looks like this:Change the Parameter Value expression to: ='%' & Parameters!Param.Value & '%'Now the query text will be using a parameter with wildcards, so partial matches are returning data in the report:Alternative methodActually, thinking about this, perhaps an easier way to achieve the above is to do something like this in the report query text: SELECT.FROM Table1WHERE Table1.Name = LIKE '%' + @Name + '%'i.e. Just concatenate the wildcards directly to the parameter string. This works identically to the first option. This is how I did it:.
Create a report parameter (data type text) named MyFilter. Create a DataSet ReportData with an expression for the source query, something like:='SELECT FilteredField, FieldValue FROM DataTable ' & IIF(Parameters!MyFilter.Value.ToString = ', ', 'WHEREFilteredField LIKE '%' &REPLACE(REPLACE(Parameters!MyFilter.Value.ToString,'.' ,'%'),'?'
,')& '%')As you can see, I have a basic SELECT statement which I concatenate with an empty string if the value for MyFilter is an empty string. If a value is filled in, I add a WHERE clause in which I replace the '.' by '%' and '?' By 'This is just a simplified version of what we actually did, allowing only '?'
And '.' to be used as wildcards, but it works fine for our users.