How to Set an Expression for Max Value in Report viewer

Question

Hi,

 

i wana get fields from multiple tables  for an ssrs report. But i want a Maximum value from only one of the table (just two fields of that table),

Table1: XI(all values)

Table2: ScoreXI(all values)

Table3: Fee(two fields with max. value) ,

can anyone tell me the sql statement for that to put in a query builder. I have also tried to get all values from Fee table along with the other two tables and then on report design under textbox properties i tried to set an fx 'expression' for getting max value for those particular  fields i.e. yearFee and yearFee1, it didnt work for me either.

Please guide me.

Regards,