Dear Jim and Rebecca,
I spent a bit more time inspecting and experimenting with the HotPot tables you kindly made available.
I noticed that some of the HotPots have the "Grade weighting" set to zero. This has the effect of removing the HotPot from the gradebook. I think this was preventing the report pages from extracting database records, because they expected there always to be a gradebook item for each and every HotPot.
I have made several adjustments to resolve this issue.
- force the HotPot's gradebook entry to be removed if the its "Grade weighting" is zero
- allow the HotPot reports to extract data from the database even if the HotPot is not in the gradebook
- remove the "Grade" column and filter from HotPot report pages if the "Grade weighting" is zero
Please could you update your version of the HotPot module and see if these modifications improve the behavior of your HotPot reports. I would appreciate your feedback, because I may need to make similar adjustments to the TaskChain reports.