This is nothing to do with reports as such. You are generating a multiple choice question paper which is printed as a report and issued to students. You want to save a copy of the report for the future. You mention that your report is based on a query (as it should be).
What is not said is how you select a particular question set to issue. Normal practice when dealing with generating sets of multiple choice questions is to have a bank of questions, then select a set either at random or by manual choice. The design of the database has to accommodate the storage of a specific question set so that it can be re-selected and printed on other occasions (as a past paper for other classes to study, for instance).
All this preamble is to say that reporting is the final stage of the process; what matters here is whether you have designed your database to store in a table somewhere the selection of questions making up paper x, where x is whatever reference you give to your paper. You would also need to associate that paper with a particular issue date, so that you can tell it was issued in June 2010, say, if you want to use it in future years, the course in which you are using it, and the exam diet if applicable (for example, Question Paper A832-01, Semester 1, June 2010).
You mention a chapter of some kind; is the question set associated with specific chapters in a textbook rather than a specific exam diet? If it is, the same principle of designing the underlying tables to model the relationships between the chapters and the questions applies.
If you set up the tables correctly from the start you can reprint any question set at any time.
-Stewart
37
