Crystal Reports filter content for single reports
Hello,
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?
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?
ASKER
Yes, its 2011, sorry about that. Could you give me a few pointers to what you mean by putting a parameter on each field? Where would i do that?
Thanks for the reply.
Thanks for the reply.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Exactly what I needed! Thanks
The tag says CR 11 is that CR 2011 or CR XI?
If it is CR 2011 you can have optional parameters
YOu would create a parameter for each field you think the user might want to filter on
You can then use the select expert to filter based on the field and the criteria.
mlmcc