Search code examples
c#visual-studioreporting-servicesssrs-2008

BC30201 Expression expected error


When we deploy a report SSRS generates the following error:

Error 1 The GroupExpression expression for the tablix ‘Tablix8’ contains an error: [BC30201] Expression expected. D:\appDirectory\Vication\AV Vication 05300\APP\7\Voilintair\Voilintair\Report2.rdlc Voilintair

when I try to make parent group for costume data in my table I get That error above? my expression is:

(Fields!vic_rank.Value Like "Dda") OrElse(Fields!vic_rank.Value Like "lord")OrElse(Fields!vic_rank.Value Like "same")OrElse(Fields!vic_rank.Value Like "vatv")OrElse(Fields!vic_rank.Value Like "namert")OrElse(Fields!vic_rank.Value Like "csae")OrElse(Fields!vic_rank.Value Like "dgry")OrElse(Fields!vic_rank.Value Like "odel")OrElse(Fields!vic_rank.Value Like "sdfdf")

Any Help Thanks...


Solution

  • I used Query in my DataSet that bring the values I want instead of using expression and the query like that

    SELECT vic_personName, vic_Type, vic_from, vic_to, Vic_days, vic_not, vic_Dep, vic_rank, ID
    FROM            tbl_vication
    WHERE        (vic_to BETWEEN ? AND ?) AND (vic_rank = 'Dda' OR
                             vic_rank = 'lord' OR
                             vic_rank = 'same' OR
                             vic_rank = 'vatv' OR
                             vic_rank = 'namert' OR
                             vic_rank = 'dgry' OR
                             vic_rank = 'sdfdf')
    

    and the result is like what I expected with adding to date parameters to the query ... thanks