Forum Discussion
You can accomplish what you want with the following setup:
a) Create a new Report Dates table where you would have just one record. The Record would have 2 fields, Begin Date and End Date. This record and the dates that you enter there would effectively replace your Ask The User filter on your Summary Report.
b) Create 2 new formula date fields (Report Begin Date and Report End Date) in your main table . You would use a Formula Query to pull the Begin Date from the Report Dates table into the Report Begin Date field and the End Date into the Report End Date field.
c) Create a 3rd formula checkbox field on the main table (Include Record in Summary Report) that checks to see if the Call Date is in the Date Range defined by the dates in the Report Date table. If the date is within the date range then set the CheckBox value to True. If it is not in range then it remains as false.
d) Update your Summary Report on the main table so that it only include records where that CheckBox formula field (Include Records on Summary Report) is set to True.
e) Update your Report Formula Query to also only pull in records where that CheckBox formula field is true. This would limit the Call Type output so that only Call Types on records within the specified Date Range would be included in the final Summary.
The Ask The User report filter questions basically act like variable values when running the report. As there is no way to incorporate those values into your Report Formula Query we must think outside the box to come up with a way to be able to use those values. By defining these date values in a field in a new table, you can now create a Formula field that uses a formula query to grab that value which then effectively defines that variable for you but also allows you to use that field value in your Report Filter and Report Formula Query.
Not an ideal solution for running your report but it does solve your issue and allow you to get back the report results that you want when there was really no way to do it before within the confines of the report.
------------------------------
James Grove
------------------------------