I have a report that shows an employee id and the amount of hours worked. The report spec ask that when the user runs a report they be able to enter a monthly target number in the prompt page of the report for the number hours they should work. That value they entered would be used in a new formula in the report that subtracts the target they entered to what they actually did. I was playing around with a text box prompt as that allows the user to enter a value in the prompt page but not sure what the setup is to be able to use it on the report side. Any insight would be appreciated!
yes you can use the value from a parameter in the report. for example in the query explorer if you add a detail filter in the expression window that opens you will see tabs in the bottom left hand corner. the last one is parameters.