The membership dues revenue report displays information for a membership during a specific time frame that is declared when running the report. The active membership report will show information on memberships as that membership exist in the moment. The time frame you have selected on the membership dues revenue report may be reporting on data as it appeared at that time but the active membership report will show the data as it appears right now.