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,