I have a report that will report the data from a sql script but need a way to add data to the query when the date parameters go beyond present data. For example, If I query a date range of 9/1/2020 to 11/30/2020 but there is no rows past 10/31/2020 I still need to show the November data without values on the report?
