How do I display Date Range parameters in my headers? 2

[krpurcel]

I have a date range parameter that pops up when you run the report and asks for the starting and ending dates for the data. I want to show these starting and ending dates in the header of the report, but am not sure how to do that. I tried putting the parameter itself in the header, but that doesn't work.

Can someone please point me in the right direction?

 

[progenysend]

Do you have an additional formula for your dates? If you do, you can use this formula (My date formulas use "Y" for yesterday, "W" for last week, etc...):

IF {?StartDate} = "Y" OR {@StartDate} = {@EndDate}
THEN "Business Day: " & ({@EndDate})
ELSE "Report Includes : " & ({@StartDate}) & " thru " & ({@EndDate})

If you don't, then try:

IF {?StartDate} = {?EndDate}
THEN "Business Day: " & ({?StartDate})
ELSE "Report Includes Service Requests Created: " & ({?StartDate}) & " thru " & ({?EndDate})

 

[nls4209]

Range parameters, by themselves, will never display.

Create a formula such as this, however, and your range will appear:

totext(minimum({?Dates})) + " to " + totext(maximum({?Dates}))

 

[krpurcel]

Thanks for the great replies! I appreciate it!