Anyone encountered this SSRS error?

Question

I am getting the following error in SSRS 2016 builder, appears to be a bug.

System.Web.Services.Protocols.SoapException: The expression used for the parameter ‘@Nlabu Ndebila Patient ’ in the dataset ‘@Nlabu Ndebila Patient ’ refers to a field. Fields cannot be used in query parameter expressions.
at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)
at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)

I have looked at the RDL file in text form, this doesn't exist anywhere.

Answer 1

Hi @Chris Combs

From your error log,I guess your parameter 'Patient' use expression,and the expression contain the feild, but it is not a right way . Maybe you can change your dataset ，for example ：

SELECT CASE   
    WHEN @report_type = 1 THEN daily_start  
    WHEN @report_type = 2 THEN weekly_start   
    WHEN @report_type = 3 THEN monthly_start  
END AS StartDate  
FROM MyTable  

I refer to this thread：https://stackoverflow.com/questions/13580190/fields-cannot-be-used-in-report-parameter-expression
Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.