Hello, I have Crystal Reports 2011 and I am creating a student transcript from an Excel export I get from our grading system. I had set this up to import into a SQL Database as i will be sending this report to multiple recipients who will not have the actual file, but will have access to the DB. That all works fine. What my challenge is that I have 10 rows for example that all have the same student name on it. Last Name is a field. First Name is a field, Course is a field, along with many others. So when I create my parameter using the selection of Last Name, it will only add the first row it finds. How do I tell it to add all rows for the same last name? So each row would be Students Name - Course on each line.
I have found some suggesting an All command that can be used in the parameter, but I do not see anywhere that I can insert a query command, as that article was talking about putting a command on the query value, but thats only a drop menu of defined criteria.