Hello, I am looking for some insight on how I can create a report from a defined group of criteria for my project Im working on. So this is a transcript I am producing that gets all of its data from a MSSQL DB that I imported the data into. I set up the report with the following:
CourseID StudentLastName StudentFirstName SchoolName Grade Credits
I have the Course ID as a table in the DB that I would like to have it auto pick a subject for that class, as my import does not identify that as its just something we do.
So take for example course ID 455Algebra. If the CourseID field above that I linked the courseid table to has a 455Algebra, I want it to auto create a header for that and call it Math. So if there were a 455Algebra and a 677Geometry and a 822Trig listing of all the classes that one student took. Then the student also has CourseID 221EnglishLit and CourseID 889USHistory, I am trying to get the output on the report to show:
455Algebra Algebra II A-
677Geometry Geometry I C+
822Trig Intro to Trig D
221Englit English Literature A
889USHISTORY United States History II C+
Please let me know if there are any suggestions out there. Thanks!!