Anyone encountered this SSRS error?

Chris Combs 1 Reputation point

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.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,784 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Isabellaz-1451 3,611 Reputation points

    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 :

        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:
    Best Regards,

    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.

    0 comments No comments