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...
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