I have begun my first crystal report project and I have been able to figure some of the basics out. What I have a need for is to create transcripts for students from an excel sheet that contains all of the students information. There are hundreds of students on this sheet, and while it may be nice to run all reports for all students, 99% of the time it will only be running the report on selected criteria. So I only want to run a transcript report for John Doe. How would I set up that type of filtering, and how would I be able to easily have others determine what reports they want to run. Maybe they want a report from a specific school. Or for every student that has a C or lower grade. I wouldnt possibly require the user to determine a query to use.
What are my options for this type of report being that the data is coming from an XLS file as the system that creates it is a 3rd part that I do not have direct DB access?