Macro is used to run set of instructions to execute the report but prompt provide a way to change the report dynamically.