i have two table in sql server StudentInfo and Studentfee. i have a main report which takes data from studentinfo and a subreport which takes data from student fee.
each student has thousands records in studentfee, which is very expensive to place in subreport. Is there any way where i pass 20 or N in a parameter to subreport and it retrieves only last N records. if it is possible using subreport wizard then it will be very good.