Anyone encountered this SSRS error?

Chris Combs 1 Reputation point
2022-02-10T15:42:46.12+00:00

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
    2022-02-11T02:18:09.257+00:00

    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.

    0 comments No comments