Concern Support
asked on
how to extract last n records using subreport in crystal report 11?
hi,
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.
Thanks,
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.
Thanks,
How do you extract records for the StudentFee?
you can create the subreport through stored procedure right...there u give the query for last n records
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.