I have a master report and 25 subreports that use two user input parameters to drive them all. Works great. I want to be able to take the integer input for quarter (1, 2, 3, or 4) and convert it into the last month and last day of the quarter in the footer. So if the user input 1, I want to get 3/31 as the last day of quarter one. I've tried various things that didn't work. Here's my latest:
="Data for period 1/1/" & Parameters!Yr.Value & " through " & datepart("m",Parameters!Yr.Value) & "/" & datepart("d",Parameters!Qtr.Value)
This is the expression in a textbox in the footer. When I run the report the textbox writes #Error on the report.
I've googled a lot but I haven't found a case of someone wanting to take an integer parameter and converting it last month and day. Almost all examples use the current date with date arithmetic. I would like the flexibility of using the user input quarter for the desired report.
Thanks in advance.