I am trying to select records based on a date range to display on the main report and a subreport with both reports reporting off of different tables. I have two parameters on the main report to make a date range ?startdate and ?enddate - I made two formulas that share these for the subreport -->@start and @end. The main report is using these fields in the header so I think they are working right. (I've also tried to place them in the group headers, footer, and details sections to help troubleshoot this)
I'm trying to get the subreport to do the same date range selection based on a different table but using the same date range. I'm able to share to the @start and @end dates into the subreport (the fields are displaying) but I am unable to select the data based on those fields (I've also placed these fields in the header and details sections). In the SELECT I'm getting the " This formula cannot be used because it must be evaluated later" error message. Thank you.
I'm trying to get the subreport to do the same date range selection based on a different table but using the same date range. I'm able to share to the @start and @end dates into the subreport (the fields are displaying) but I am unable to select the data based on those fields (I've also placed these fields in the header and details sections). In the SELECT I'm getting the " This formula cannot be used because it must be evaluated later" error message. Thank you.