Link to home
Start Free TrialLog in
Avatar of Concern Support
Concern SupportFlag for Ireland

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,
Avatar of Deepak Lakkad
Deepak Lakkad
Flag of India image

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
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike McCracken
Mike McCracken

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.