if formula
I'm creating table report and using a filter that allows the user to input the criteria when they access the report. Is there a way to use the input from the user in the report formula?
Forum Discussion
The answer is NO, but that does not mean there is not a solution.
One solution is to create a a single record in a new table called Set Criteria. It will be [Record ID#] of 1.
Make a relationship to your details table based on a formula reference field on the right side of the relationship with a formula numeric field of 1.
Create one or more fields on the Set Criteria Record and look them up down to the detail records, and use them as report filters.
The effect is that the user will edit the Criteria, Save, and be able to see the report with the result set as an embedded child Report.
Note that in a multi user environment, there is the possibility that the users will trip over each other. If that is the case post back and there is a solution for that issue too.
One solution is to create a a single record in a new table called Set Criteria. It will be [Record ID#] of 1.
Make a relationship to your details table based on a formula reference field on the right side of the relationship with a formula numeric field of 1.
Create one or more fields on the Set Criteria Record and look them up down to the detail records, and use them as report filters.
The effect is that the user will edit the Criteria, Save, and be able to see the report with the result set as an embedded child Report.
Note that in a multi user environment, there is the possibility that the users will trip over each other. If that is the case post back and there is a solution for that issue too.
