Hi Friends, I have one confused report, i need to get the Student Fee Payment Details. I Added 2 data sets from data source In Fee Structure Dataset i have these Feilds "Class, Category, Admission_Fee, Building_Fee, Tution_Fee... " In Fee Payment Dataset i have these Feilds "Admission Number , Class, Category , Concession_amount, Tot_amt_paid, Fee balence.. Here In Report i have to get the data filter with Admission Number only, Principal can check the data with Admission Numbet only. If i have Admission Number in Fee Structure Dataset then i can easily filter the data of student. But In Fee Structure Dataset i didt have Admission Numbet Field. My report should be like this, please check this link http://i-netsolution.com/Products/icm/parents/Parent_module/fees1.html Please help me for expression Thanks.MD.Liakath ali

Hi Liakath, You can redesign your T-SQL to make sure that the Fee Structure dataset contain Administrator Number datafield. Of course you could also utilize the LookUp function in Reporting services to join these two datasets together to retrieve Admission_Fee, Building_Fee, Tution_Fee...in Payment Dataset, then you could filter the Payment Dataset by Administrator Number datafield. For more information about Lookup Function, please sse: http://msdn.microsoft.com/en-us/library/ee210531.aspx Thanks,Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.