Macro is set of instructions to run report.
Prompt is just like a dialog box which will ask user to select/enter the information what he needs.
A MACRO IS RUN TIME PARAMETER WHICH CAN BE PLACED IN ANY PART OF SQL SELECT
STATEMENT,WHERE AS PROMPT IS USED TO GIVE CONDITIONS.
Prompt is just like a dialog box which will ask user to select/enter the information what he needs.
A MACRO IS RUN TIME PARAMETER WHICH CAN BE PLACED IN ANY PART OF SQL SELECT
STATEMENT,WHERE AS PROMPT IS USED TO GIVE CONDITIONS.