I'm working on a report where the user would like to select a date, either today or future date, and calculate a person's age based on that date.
The challenge i'm running into is identifying the necessary Data Item to use. Is there a way to prompt the user on a prompted date, and not necesarily a date from the report package?
??? = ?Prompt date?
Thanks in advance.
You don't need a specific filter to generate a prompt - a data item will do. Try defining a data item in your query with the expression ?Prompt date?, then add a date prompt to your report and set it to use the existing parameter ?Prompt date?. Then you can add your calculation for age and display this in your report. This should hopefully give you what you need.
Regards,
MF.
That works, thanks!!